Skip site navigation (1) Skip section navigation (2)

Re: Recommend dba maintenance tasks on a regular bases

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Recommend dba maintenance tasks on a regular bases
Date: 2008-09-12 16:40:19
Message-ID: 20080912164019.GD2171@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-admin
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/

In response to

Responses

pgsql-admin by date

Next:From: Jeff FrostDate: 2008-09-12 16:55:08
Subject: Re: Recommend dba maintenance tasks on a regular bases
Previous:From: Barbara StephensonDate: 2008-09-12 15:49:46
Subject: Recommend dba maintenance tasks on a regular bases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group