Re: Setting vacuum_freeze_min_age really low

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Setting vacuum_freeze_min_age really low
Дата
Msg-id 20130509172205.GB27844@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: Setting vacuum_freeze_min_age really low  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-performance
On 2013-05-09 12:09:04 -0400, Robert Haas wrote:
> On Mon, Mar 25, 2013 at 4:31 PM, Josh Berkus <josh@agliodbs.com> wrote:
> > In the past, setting vacuum_freeze_min_age (vfma) really low (say to
> > 10000 or 50000) would have caused lots of extra writing work due to
> > dirtying extra pages for freezing.  This has been our stated reason to
> > keep vfma high, despite the obvious advantage of freezing tuples while
> > they're still in the cache.
>
> That, and Tom's concern about forensics, which I understand to be the
> larger sticking point.

FWIW I found having sensible xmin/xmax repeatedly really useful for
debugging problems. Most problems don't get noticed within minutes so
loosing evidence that fast is bad.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Setting vacuum_freeze_min_age really low
Следующее
От: Vitalii Tymchyshyn
Дата:
Сообщение: Re: In progress INSERT wrecks plans on table