Re: Recommend dba maintenance tasks on a regular bases

On Fri, Sep 12, 2008 at 11:49:46AM -0400, Barbara Stephenson wrote:
> I have recommend the below to my group but not sure if reindexing should be
> involved since autovacuum is on?

No, there's no reason to reindex regularly if everything is working as
expected.

>
> How can I be sure auto vacumming is working fine?

Check the pg_statitistic_all_tables entries in last_autovacuum and
last_autoanalyze.

A


--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/