Re: Aggressive freezing in lazy-vacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Aggressive freezing in lazy-vacuum
Дата
Msg-id 18982.1173110551@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Aggressive freezing in lazy-vacuum  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Ответы Re: Aggressive freezing in lazy-vacuum  ("Florian G. Pflug" <fgp@phlo.org>)
Re: Aggressive freezing in lazy-vacuum  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Список pgsql-hackers
ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> This is a stand-alone patch for aggressive freezing. I'll propose
> to use OldestXmin instead of FreezeLimit as the freeze threshold
> in the circumstances below:

I think it's a really bad idea to freeze that aggressively under any
circumstances except being told to (ie, VACUUM FREEZE).  When you
freeze, you lose history information that might be needed later --- for
forensic purposes if nothing else.  You need to show a fairly amazing
performance gain to justify that, and I don't think you can.

            regards, tom lane

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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Latest plans for Utilities with HOT
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: HOT - whats next ?