Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 4CF969F9552 for ; Mon, 20 Aug 2007 16:34:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 09327-08 for ; Mon, 20 Aug 2007 16:34:11 -0300 (ADT) X-Greylist: delayed 00:59:59.786247 by SQLgrey-1.7.5 Received: from mmp1.nems.noaa.gov (mmp1.nems.noaa.gov [140.90.121.156]) by postgresql.org (Postfix) with ESMTP id 1A0C39F9571 for ; Mon, 20 Aug 2007 16:34:13 -0300 (ADT) Received: from [204.227.103.140] by mmp1.nems.noaa.gov (Sun Java System Messaging Server 6.2-2.05 (built Apr 28 2005)) with ESMTPSA id <0JN3005QP4WY7360@mmp1.nems.noaa.gov> for pgsql-admin@postgresql.org; Mon, 20 Aug 2007 14:34:12 -0400 (EDT) Date: Mon, 20 Aug 2007 13:33:52 -0500 From: Juliann Meyer Subject: vacuum questions To: pgsql-admin@postgresql.org Message-id: <46C9DE90.1030206@noaa.gov> Organization: Missouri Basin River Forecast Center MIME-version: 1.0 Content-type: multipart/mixed; boundary="Boundary_(ID_WrgbPvXnVh2lGDp8fcpKMg)" User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/231 X-Sequence-Number: 26562 This is a multi-part message in MIME format. --Boundary_(ID_WrgbPvXnVh2lGDp8fcpKMg) Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT 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 --Boundary_(ID_WrgbPvXnVh2lGDp8fcpKMg) Content-type: text/x-vcard; charset=utf-8; name=julie.meyer.vcf Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=julie.meyer.vcf 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 --Boundary_(ID_WrgbPvXnVh2lGDp8fcpKMg)--