Re: unlogged tables vs. GIST - Mailing list pgsql-hackers

From Robert Haas
Subject Re: unlogged tables vs. GIST
Date
Msg-id AANLkTikN5D=3RGzS_YSm3k2_5VchRzR2vCquuTE4zbUS@mail.gmail.com
Whole thread Raw
In response to Re: unlogged tables vs. GIST  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Dec 17, 2010 at 2:31 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> Another possibly-useful thing about mandating a full page header for
>> every page is that it might give us a way of avoiding unnecessary full
>> page writes.  As I wrote previously:
>
> Could we do that via a bufmgr status bit, instead?  Heikki's idea has
> the merit that it actually reduces bufmgr's knowledge of page headers,
> rather than increasing it (since a buffer marked UNLOGGED would need
> no assumptions at all about its content).

That was my first thought, but it doesn't work.  The buffer could be
evicted from shared_buffers and read back in.  If a checkpoint
intervenes meanwhile, we're OK, but otherwise you fail to emit an
otherwise-needed FPI.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: unlogged tables vs. GIST
Next
From: Tom Lane
Date:
Subject: Re: Why don't we accept exponential format for integers?