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 |