Re: Default autovacuum settings too conservative

Поиск
Список
Период
Сортировка
От Chris Browne
Тема Re: Default autovacuum settings too conservative
Дата
Msg-id 60mzh4i16z.fsf@dba2.int.libertyrms.com
обсуждение исходный текст
Ответ на Default autovacuum settings too conservative  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-performance
matthew@zeut.net ("Matthew T. O'Connor") writes:
> I think the default settings should be designed to minimize the
> impact autovacuum has on the system while preventing the system from
> ever getting wildly bloated (also protect xid wraparound, but that
> doesn't have anything to do with the thresholds).

That would suggest setting the "base threshold"
autovacuum_vacuum_threshold relatively low, and the "scale factor"
autovacuum_vacuum_scale_factor fairly high.
--
let name="cbbrowne" and tld="ntlug.org" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/nonrdbms.html
I think  it may be  possible to simplify  and condense the  content of
this thread somewhat:
 "GX is an ex-API.  It is no longer supported" - The Rest of Us
 "No it isn't.  It's just pining for the fjords!" - Lawson
-- Michael Paquette

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

Предыдущее
От: Andrew Lazarus
Дата:
Сообщение: Re: execution plan : Oracle vs PostgreSQL
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: partitioning and locking problems