Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM ANALYZE is faster than ANALYZE? - Mailing list pgsql-hackers

From Jeroen Vermeulen
Subject Re: VACUUM ANALYZE is faster than ANALYZE?
Date
Msg-id 4F452BE1.10602@xs4all.nl
Whole thread Raw
In response to Re: VACUUM ANALYZE is faster than ANALYZE?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: pg_test_timing tool for EXPLAIN ANALYZE overhead
Next
From: Andrew Dunstan
Date:
Subject: determining a type oid from the name