From: Barbara Stephenson <barbara@turbocorp.com>
To: pgsql-admin@postgresql.org
Subject: Recommend dba maintenance tasks on a regular bases
Date: Fri, 12 Sep 2008 11:49:46 -0400
User-Agent: KMail/1.7.1
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200809121149.46137.barbara@turbocorp.com>

Hello,

We are currently using Postgresql 8.3.3 on Red Hat 4 and our largest database 
is around 8454 MB.

I have recommend the below to my group but not sure if reindexing should be 
involved since autovacuum is on?  

How can I be sure auto vacumming is working fine? We haven't had any problems 
plus I do a query and it does list all the tables and shows the last update 
of auto vacuum and auto analyze.  Is that it?


1- pg_dump - binary dump every midday and nightly
2 - auto vacuum
 autovacuum = on     
 log_autovacuum_min_duration = 0        
 autovacuum_max_workers = 3             
 autovacuum_naptime = 1min              
 autovacuum_vacuum_threshold = 50       
 autovacuum_vacuum_scale_factor = 0.2   
 autovacuum_analyze_scale_factor = 0.1 
3- rotate data logs

-- 
Regards,

Barbara Stephenson
EDI Specialist/Programmer
Turbo, division of Ozburn-Hessey Logistics
2251 Jesse Jewell Pkwy NE
Gainesville, GA  30507
tel: (678)989-3020 fax: (404)935-6171
barbara@turbocorp.com
www.ohlogistics.com