Re: VACUUM Question

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM Question
Date: 2004-06-04 18:50:29
Message-ID: 40C0C475.8070609@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark wrote:
> Alex <alex(at)meerkatsoft(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Rahm-Coffey 2004-06-04 19:09:40 Updating a unique constrant
Previous Message Keary Suska 2004-06-04 18:35:01 Re: Building Thread-Safe on OS X