Postgres Pro
Downloads
Home   >   mailing lists

Re: Freeze avoidance of very large table. - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Freeze avoidance of very large table.
Date
Msg-id 20150421150211.GI14483@alap3.anarazel.de
Whole thread Raw
In response to Freeze avoidance of very large table.  (Sawada Masahiko <sawada.mshk@gmail.com>)
Responses Re: Freeze avoidance of very large table.
List pgsql-hackers
Tree view 
On 2015-04-21 23:59:45 +0900, Sawada Masahiko wrote:
> The page as frozen could have the dead tuple for now, but I think to change
> to that the frozen page guarantees that page is all frozen *and* all
> visible.

It shouldn't. That'd potentially cause corruption after a wraparound. A
tuple's visibility might change due to that.

Greetings,

Andres Freund

pgsql-hackers by date:

Previous
From: Sawada Masahiko
Date:
Subject: Freeze avoidance of very large table.
Next
From: Bruce Momjian
Date:
Subject: Re: Turning off HOT/Cleanup sometimes