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(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/