Re: With auto vacuum, is analyze still necessary?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brendan Duddridge <brendan(at)clickspace(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: With auto vacuum, is analyze still necessary?
Date: 2006-01-10 15:19:38
Message-ID: 29659.1136906378@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Brendan Duddridge <brendan(at)clickspace(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Lane Van Ingen 2006-01-10 15:42:39 Error Returned by A Function
Previous Message A. Kretschmer 2006-01-10 14:53:00 Re: translating this SQL query from a different dialect