Re: Default autovacuum settings too conservative

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Default autovacuum settings too conservative
Date: 2006-02-07 14:20:08
Message-ID: 20060207142006.GM1293@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

On Mon, Feb 06, 2006 at 11:05:45PM -0600, Jim C. Nasby wrote:
>I don't really see the logic behind that. Problems caused by inadequate
>vacuuming seem to be much more prevalent than problems caused by vacuum
>impacting the system.

Agreed. If your tables are large enough that a vacuum matters, you
probably shouldn't be blindly running autovacuum anyway.

Mike Stone

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message lrotger 2006-02-07 15:33:55 Re: Actual expression of a constraint
Previous Message Markus Schaber 2006-02-07 12:39:34 Re: Default autovacuum settings too conservative

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2006-02-07 22:09:02 Re: partitioning and locking problems
Previous Message Markus Schaber 2006-02-07 12:39:34 Re: Default autovacuum settings too conservative