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

Re: enabling autovacuum

From: Chander Ganesan <chander(at)otg-nc(dot)com>
To: Jeremy Harris <jgh(at)wizmail(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: enabling autovacuum
Date: 2008-01-30 02:54:22
Message-ID: 479FE6DE.6070508@otg-nc.com (view raw or flat)
Thread:
Lists: pgsql-general
Jeremy Harris wrote:
> Hi,
>
> We're starting to run autovacuum for the first time on a system
> that's been running with nightly cron-driven vacuum for some time.
>
> Version:
>  PostgreSQL 8.2.4 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 
> 4.1.2 20070418 (Red Hat 4.1.2-10)
>
> We have one problematic table, which has a steady stream of entries
> and a weekly mass-delete of ancient history.  The "bloat" query from
> Greg Sabino Mullane (thanks to Greg Smith for pointing it out) returns:
Inserts don't generate dead tuples, and AVD looks at obsolete tuples..  
As such,  I wouldn't expect AVD to kick off until after you did a mass 
delete...assuming that delete was sizable enough to trigger a vacuum.

-- 
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC  27560
Phone: 877-258-8987/919-463-0999
http://www.otg-nc.com
Ask me about our Expert PostgreSQL & PostGIS Training


In response to

Responses

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2008-01-30 03:08:31
Subject: Re: OT - pg perl DBI question
Previous:From: David OwenDate: 2008-01-30 02:42:31
Subject: Only first statement of two in update-rule is executing?

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