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 по дате отправления: