Re: 8.3.1 autovacuum stopped doing anything months ago

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Jeffrey Baker <jwbaker(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.3.1 autovacuum stopped doing anything months ago
Date: 2008-09-19 07:18:14
Message-ID: 48D35236.9020407@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jeffrey Baker wrote:
> Secondly, there really does need to be an autovacuum=off,really,thanks so
> that my maintenance can proceed without competition for i/o resources. Is
> there any way to make that happen?

You could bump up autovacuum_freeze_max_age while you run the vacuums
manually, and then set it back. It will require a restart, though.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2008-09-19 08:25:35 Re: Where to Host Project
Previous Message Heikki Linnakangas 2008-09-19 07:13:43 Re: WIP patch: Collation support