Re: Autovacuum on by default?

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autovacuum on by default?
Date: 2006-08-18 13:46:00
Message-ID: 44E5C498.1050101@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut wrote:
> Am Donnerstag, 17. August 2006 18:40 schrieb Josh Berkus:
>> I'm in favor of this, but do we want to turn on vacuum_delay by default
>> as well?
>
> People might complain that suddenly their vacuum runs take four times as long
> (or whatever). Of course, if we turn on autovacuum and advocate a more or
> less hands-off vacuum policy, they won't have to care either way. All of
> this would certainly be release-notes material.
>
> Does anyone, for that matter, want to propose possible default parameters for
> vacuum_delay?

I said vacuum_delay but I should have been more specific, there are
autovacuum GUC variables which is what we should be talking about. This
way manually run, or nighly run by cron vacuums are still as fast as
they ever were.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2006-08-18 13:48:21 Re: pg_terminate_backend
Previous Message Tom Lane 2006-08-18 13:26:25 Re: pg_terminate_backend