Home > mailing lists

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

From	Simon Riggs
Subject	Re: Freeze avoidance of very large table.
Date	July 2, 2015 19:23:12
Msg-id	CANP8+j+=rMz8_-zAaJv_cKTHHAaye7s+SpMpVDVXbqVGDb-KEA@mail.gmail.com Whole thread Raw
In response to	Re: Freeze avoidance of very large table. (Sawada Masahiko <sawada.mshk@gmail.com>)
Responses	Re: Freeze avoidance of very large table. (Sawada Masahiko <sawada.mshk@gmail.com>)
List	pgsql-hackers

On 2 July 2015 at 16:30, Sawada Masahiko <sawada.mshk@gmail.com> wrote:

Also, the flags of each heap page header might be set PD_ALL_FROZEN,
as well as all-visible

Is it possible to have VM bits set to frozen but not visible?

The description makes those two states sound independent of each other.

Are they? Or not? Do we test for an impossible state?

Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

From: Heikki Linnakangas
Date: 02 July 2015, 19:22:59
Subject: Re: Fix autoconf deprecation warnings

From: Simon Riggs
Date: 02 July 2015, 20:03:09
Subject: Re: Doubt about AccessExclusiveLock in ALTER TABLE .. SET ( .. );