pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (6+ messages)  latest in thread

Message-ID: <46C9DE90.1030206@noaa.gov>
Permalink:  ../46C9DE90.1030206@noaa.gov/
Also on:    postgresql.org/message-id/46C9DE90.1030206@noaa.gov

 · 

reply

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