From: Juliann Meyer <Julie.Meyer@noaa.gov>
To: pgsql-admin@postgresql.org
Subject: vacuum questions
Date: Mon, 20 Aug 2007 13:33:52 -0500
Message-ID: <46C9DE90.1030206@noaa.gov> (raw)
Currently running v7.4.8 postgres on a RHE Linux 4.0 box. Will be
upgraded to postgres 8.2.x sometime this fall.
Several of the tables in the database that resides on this system have
lots of inserts and updates. Very little is deleted at this time, as
the database is intended for archiving.
Currently a cron job runs a vacuum analyze 3 times a day. Is there any
need to run a vacuum full every so often?
If so, how often should a vacuum full be done? And do all other
processes that "hit" the database need to shut off when a vacuum full is
done?
Also another office that has a similar setup has switched to running
pg_autovacuum instead of the vacuum analyze 3 times/day, are there any
advantages and/or disadvantages to this approach?
Thanks in advance for any information and guidance you can give,
Julie
Attachments:julie.meyer.vcf (text/x-vcard, 247B) download
begin:vcard
fn:A. Juliann Meyer
org:National Weather Service;Missouri Basin River Forecast Center
adr;dom:;;;Pleasant Hill;MO;64080
email;internet:julie.meyer@noaa.gov
title:Sr. Hydrologist - Data Systems
x-mozilla-html:FALSE
version:2.1
end:vcard
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: Julie.Meyer@noaa.gov
Subject: Re: vacuum questions
In-Reply-To: <46C9DE90.1030206@noaa.gov>
* 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