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

From Tom Lane
Subject Re: unlogged tables vs. GIST
Date
Msg-id 4982.1292616916@sss.pgh.pa.us
Whole thread Raw
In response to Re: unlogged tables vs. GIST  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: unlogged tables vs. GIST
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Fri, Dec 17, 2010 at 3:03 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Yeah. �I think that BM_UNLOGGED might be a poor choice for the flag name,
>> just because it overstates what the bufmgr needs to assume.

> I was actually thinking of adding BM_UNLOGGED even before this
> discussion, because that would allow unlogged buffers to be excluded
> from non-shutdown checkpoints.  We could add two flags with different
> semantics that take on, under present rules, the same value, but I'd
> be disinclined to burn the extra bit without a concrete need.

bufmgr is currently using eight bits out of a 16-bit flag field, and
IIRC at least five of those have been there since the beginning.  So our
accretion rate is something like one bit every four years.  I think not
being willing to use two bits to describe two unrelated behaviors is
penny-wise and pound-foolish --- bufmgr is already complicated enough,
let's not add useless barriers to readability.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: proposal: FOREACH-IN-ARRAY (probably for 9.2?)
Next
From: Bill Moran
Date:
Subject: Re: Why don't we accept exponential format for integers?