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

Recommend dba maintenance tasks on a regular bases

From: Barbara Stephenson <barbara(at)turbocorp(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Recommend dba maintenance tasks on a regular bases
Date: 2008-09-12 15:49:46
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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


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


pgsql-admin by date

Next:From: Andrew SullivanDate: 2008-09-12 16:40:19
Subject: Re: Recommend dba maintenance tasks on a regular bases
Previous:From: Thomas JacobDate: 2008-09-12 14:24:01
Subject: Re: open source ERD for postgresql database

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