Re: VACUUM ANALYZE is faster than ANALYZE? - Mailing list pgsql-hackers

From Nicolas Barbier
Subject Re: VACUUM ANALYZE is faster than ANALYZE?
Date
Msg-id CAP-rdTZRDc4P4Zg=+U-Ct68S5V6ri=EeFv3HSVc8TSVgRQMA=g@mail.gmail.com
Whole thread Raw
In response to Re: VACUUM ANALYZE is faster than ANALYZE?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: VACUUM ANALYZE is faster than ANALYZE?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
2012/2/22 Robert Haas <robertmhaas@gmail.com>:

> On Tue, Feb 21, 2012 at 9:00 AM, Pavel Stehule <pavel.stehule@gmail.com> 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?


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: VACUUM ANALYZE is faster than ANALYZE?
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: temporal algebra and data type