Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
Date: 2010-04-16 16:39:34
Message-ID: 4BC892C6.1030304@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom,

Neither database has and per-table autovacuum settings.

However, since this is a production database, I had to try something,
and set vacuum_cost_limit up to 1000. The issue with vacuuming one page
at a time went away, or at least I have not seen it repeat in the last
16 hours.

--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-04-16 16:39:54 Re: stats collector suddenly causing lots of IO
Previous Message Josh Kupershmidt 2010-04-16 16:31:51 Re: stats collector suddenly causing lots of IO