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

From Josh Berkus
Subject Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
Date
Msg-id 4BC892C6.1030304@agliodbs.com
Whole thread Raw
In response to Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
List 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

pgsql-performance by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: stats collector suddenly causing lots of IO
Next
From: Tom Lane
Date:
Subject: Re: stats collector suddenly causing lots of IO