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

From Tom Lane
Subject Re: unlogged tables vs. GIST
Date
Msg-id 4788.1292616214@sss.pgh.pa.us
Whole thread Raw
In response to Re: unlogged tables vs. GIST  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: unlogged tables vs. GIST  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> On 17.12.2010 21:32, Robert Haas wrote:
>> I guess the question is whether it's right to conflate "table is
>> unlogged" with "LSN is fake".  It's not immediately obvious to me that
>> those concepts are isomorphic, although though the reverse isn't
>> obvious to me either.

> The buffer manager only needs to know if it has to flush the WAL before 
> writing the page to disk. The flag just means that the buffer manager 
> never needs to do that for this buffer. You're still free to store a 
> real LSN there if you want to, it just won't cause any WAL flushes.

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.  It might be
better to reverse the flag sense, and have a new flag that *is* set if
the page contains an LSN that we have to check against WAL.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: proposal: FOREACH-IN-ARRAY (probably for 9.2?)
Next
From: Robert Haas
Date:
Subject: Re: unlogged tables vs. GIST