On Tue, Feb 21, 2012 at 9:00 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> 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. Not sure what's happening in your
The Enterprise PostgreSQL Company
In response to
pgsql-hackers by date
|Next:||From: Nicolas Barbier||Date: 2012-02-22 13:13:34|
|Subject: Re: VACUUM ANALYZE is faster than ANALYZE?|
|Previous:||From: Robert Haas||Date: 2012-02-22 12:57:50|
|Subject: Re: leakproof|