Postgres Pro
Downloads
Home   >   mailing lists

Re: With auto vacuum, is analyze still necessary? - Mailing list pgsql-novice

From Tom Lane
Subject Re: With auto vacuum, is analyze still necessary?
Date
Msg-id 29659.1136906378@sss.pgh.pa.us
Whole thread Raw
In response to With auto vacuum, is analyze still necessary?  (Brendan Duddridge <brendan@clickspace.com>)
List pgsql-novice
Tree view 
Brendan Duddridge <brendan@clickspace.com> writes:
> We're using PostgreSQL 8.1 on OS X Server. If we have auto vacuum
> configured, does that mean we don't have to run analyze on our
> tables? Does auto vacuum handle that for us?

Yes, though you might wish to twiddle its settings for how often to
do it.

            regards, tom lane

pgsql-novice by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: translating this SQL query from a different dialect
Next
From: "Lane Van Ingen"
Date:
Subject: Error Returned by A Function