"Joshua D. Drake" <j...@commandprompt.com> writes: > At PGConf US Philly last week I was talking with Jim and Jan about > performance. One of the items that came up is that PostgreSQL can't run > full throttle for long periods of time. The long and short is that no > matter what, autovacuum can't keep up. This is what I have done:
Try reducing autovacuum_vacuum_cost_delay more, and/or increasing autovacuum_vacuum_cost_limit. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers