Skip site navigation (1) Skip section navigation (2)

Re: VACUUM ANALYZE is faster than ANALYZE?

From: Jeroen Vermeulen <jtv(at)xs4all(dot)nl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: VACUUM ANALYZE is faster than ANALYZE?
Date: 2012-02-22 17:54:41
Message-ID: 4F452BE1.10602@xs4all.nl (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2012-02-22 18:00:55
Subject: determining a type oid from the name
Previous:From: Greg SmithDate: 2012-02-22 17:36:28
Subject: Re: pg_test_timing tool for EXPLAIN ANALYZE overhead

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group