On 07/19/2017 03:29 PM, Tom Lane wrote: > "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.
I would try autovacuum_vacuum_cost_delay = 0 and for any tables > 1 million rows: autovacuum_vacuum_scale_factor: 0 autovacuum_vacuum_threshold: 100000 (perhaps even smaller) Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
