Postgres Pro
Downloads
Home   >   mailing lists

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

From Brendan Duddridge
Subject With auto vacuum, is analyze still necessary?
Date
Msg-id 4B90D441-6599-4770-B928-E1E66B7F04A6@clickspace.com
Whole thread Raw
In response to SQL Question  (<operationsengineer1@yahoo.com>)
Responses Re: With auto vacuum, is analyze still necessary?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
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@clickspace.com

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

http://www.clickspace.com
Attachment

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: SQL Question
Next
From: Joao Miguel Ferreira
Date:
Subject: Preventing access of user1 to user2's database