Jeremy Harris wrote:
> 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.
> 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.
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Ask me about our Expert PostgreSQL & PostGIS Training
In response to
pgsql-general by date
|Next:||From: Joshua D. Drake||Date: 2008-01-30 03:08:31|
|Subject: Re: OT - pg perl DBI question|
|Previous:||From: David Owen||Date: 2008-01-30 02:42:31|
|Subject: Only first statement of two in update-rule is executing?|