On Tue, Feb 21, 2012 at 9:00 AM, Pavel Stehule <[email protected]> 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. Not sure what's happening in your particular case... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
