Re: [DOCS] Autovacuum and XID wraparound
От | Tom Lane |
---|---|
Тема | Re: [DOCS] Autovacuum and XID wraparound |
Дата | |
Msg-id | 7145.1179347418@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: [DOCS] Autovacuum and XID wraparound (Heikki Linnakangas <heikki@enterprisedb.com>) |
Ответы |
Re: [DOCS] Autovacuum and XID wraparound
|
Список | pgsql-patches |
Heikki Linnakangas <heikki@enterprisedb.com> writes: > Tom Lane wrote: >> Heikki Linnakangas <heikki@enterprisedb.com> writes: >>> Now that I think this a bit more, I think CLUSTER should freeze the >>> tuples. >> >> I disagree with that... > Ok. Why? It's removing potentially-important data without any notice or recourse to the user. There seems to be a contingent around here that thinks that as soon as xmin is older than GlobalXmin it is no longer of interest to anyone, but I have lost count of how often I have found it invaluable for forensic purposes. I have resisted having VACUUM freeze tuples before they've reached a quite-respectable age, and I object to having CLUSTER do it either. I could maybe accept a CLUSTER FREEZE option to do this, but that's not what's in the patch. regards, tom lane
В списке pgsql-patches по дате отправления: