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.