On 2012-02-22 16:29, Tom Lane wrote:
(Snip context)
VACUUM ANALYZE
consists of two separate passes, VACUUM and then ANALYZE, and the second
pass is going to be "random" I/O by your definition no matter what.
I don't suppose there's a case where the VACUUM (1) gets to delete lots
and lots of rows that then don't need ANALYZE'ing, and (2) can do so
without actually touching all those pages?
Jeroen
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
