Josh Berkus wrote:
> 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.