Re: [HACKERS] autovacuum can't keep up, bloat just continues to rise

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] autovacuum can't keep up, bloat just continues to rise
Дата
Msg-id 3417.1500503382@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [HACKERS] autovacuum can't keep up, bloat just continues to rise  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: [HACKERS] autovacuum can't keep up, bloat just continues to rise  (Joe Conway <mail@joeconway.com>)
Re: [HACKERS] autovacuum can't keep up, bloat just continues to rise  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Дерево обсуждения 
"Joshua D. Drake" <jd@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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: [HACKERS] autovacuum can't keep up, bloat just continues to rise
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] autovacuum can't keep up, bloat just continues to rise