On Wed, Feb 22, 2012 at 8:13 AM, Nicolas Barbier <nicolas.barb...@gmail.com> wrote: > 2012/2/22 Robert Haas <robertmh...@gmail.com>: > >> On Tue, Feb 21, 2012 at 9:00 AM, Pavel Stehule <pavel.steh...@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.
Yeah, I did. Woops. Let me try that again: ANALYZE should be faster; reads only some pages. VACUUM ANALYZE should be slower; reads them all. Dunno why Pavel's seeing the opposite without more info. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers