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
Re: Aggressive freezing in lazy-vacuum |
Список | 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 по дате отправления: