Re: VACUUM Question - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: VACUUM Question
Date
Msg-id 40C0C475.8070609@selectacast.net
Whole thread Raw
In response to Re: VACUUM Question  (Greg Stark <gsstark@mit.edu>)
Responses Re: VACUUM Question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Greg Stark wrote:
> Alex <alex@meerkatsoft.com> writes:
>

> There won't be anything to VACUUM after the insert, but perhaps you still want
> to run ANALYZE. Note that a plain ANALYZE uses a statistical sample which is
> much faster, whereas VACUUM ANALYZE has to look at every record anyways so
> it's slower but produces more accurate statistics. If you don't have

That is not true.  My nightly vacuum analyze clearly is sampling:

INFO:  "tablename": 22102 pages, 30000 rows sampled, 1712934 estimated
total rows

pgsql-general by date:

Previous
From: Keary Suska
Date:
Subject: Re: Building Thread-Safe on OS X
Next
From: Rick Gigger
Date:
Subject: Re: [HACKERS] Slony-I goes BETA