With auto vacuum, is analyze still necessary?

From: Brendan Duddridge <brendan(at)clickspace(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: With auto vacuum, is analyze still necessary?
Date: 2006-01-10 07:01:19
Message-ID: 4B90D441-6599-4770-B928-E1E66B7F04A6@clickspace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

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? Or should we still
create a cron job to run analyze at a regularly scheduled interval?

Thanks,

____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 | brendan(at)clickspace(dot)com

ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB T2G 0V9

http://www.clickspace.com

In response to

  • SQL Question at 2006-01-07 00:02:53 from operationsengineer1

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Vanja 2006-01-10 13:04:56 translating this SQL query from a different dialect
Previous Message operationsengineer1 2006-01-10 01:08:43 Re: SQL Question