Subject: Re: [HACKERS] VACUUM ANALYZE is faster than ANALYZE?
2012/2/22 Robert Haas <robertmhaas@xxxxxxxxx>:

> On Tue, Feb 21, 2012 at 9:00 AM, Pavel Stehule <pavel.stehule@xxxxxxxxx>
> wrote:
>
>> I had to reply to query about usage VACUUM ANALYZE or ANALYZE. I
>> expected so ANALYZE should be faster then VACUUM ANALYZE.
>>
>> But is not true. Why?
>
> I'm pretty sure that VACUUM ANALYZE *will* be faster than ANALYZE in
> general, because VACUUM has to scan the whole table, and ANALYZE only
> a fixed-size subset of its pages.

It sounds like you just said the opposite of what you wanted to say.

Nicolas

--
A. Because it breaks the logical sequence of discussion.
Q. Why is top posting bad?

--
Sent via pgsql-hackers mailing list (pgsql-hackers@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

(C)2011 mailinglist-archive.com