Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
Date
Msg-id 20100416165514.GB3310@alvh.no-ip.org
Whole thread Raw
In response to Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine  (Josh Berkus)
Responses Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine  (Josh Berkus)
List pgsql-performance
Josh Berkus wrote:
> 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.

How many autovac workers are there?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: stats collector suddenly causing lots of IO
Next
From: Josh Berkus
Date:
Subject: Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine