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?


Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to