Re: obsessive-compulsive vacuum behavior

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: obsessive-compulsive vacuum behavior
Date: 2010-03-09 19:35:31
Message-ID: 41B159F2-E9CD-4202-97DA-F8C92390328E@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 off the cost delay, things are much happier. Thanks!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Serguei Mokhov 2010-03-09 19:48:35 Re: [pgsql-ru-general] Deleting Large Objects
Previous Message Alvaro Herrera 2010-03-09 19:31:07 Re: Not all functions in schema pg_catalog are "visible"