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
Message-ID: <200809121149.46137.barbara@turbocorp.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: barbara@turbocorp.com
Subject: Re: Recommend dba maintenance tasks on a regular bases
In-Reply-To: <200809121149.46137.barbara@turbocorp.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox