Re: obsessive-compulsive vacuum behavior - Mailing list pgsql-general

From Ben Chobot
Subject Re: obsessive-compulsive vacuum behavior
Date
Msg-id 41B159F2-E9CD-4202-97DA-F8C92390328E@silentmedia.com
Whole thread Raw
In response to Re: obsessive-compulsive vacuum behavior  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mar 8, 2010, at 7:16 AM, Tom Lane wrote:

> After it's done you probably ought to look into your autovacuum
> settings.  You shouldn't have gotten into a state with so many dead
> tuples in the first place, I would think, if autovac were functioning
> properly.

Yeah, it turns out our autovacuums kept getting canceled because this table gets a lot of churn. Now that we've turn
offthe cost delay, things are much happier. Thanks! 

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Not all functions in schema pg_catalog are "visible"
Next
From: Serguei Mokhov
Date:
Subject: Re: [pgsql-ru-general] Deleting Large Objects