Re: WAL Bypass for indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: WAL Bypass for indexes
Date
Msg-id 26766.1144027933@sss.pgh.pa.us
Whole thread Raw
In response to Re: WAL Bypass for indexes  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-hackers
"Jonah H. Harris" <jonah.harris@gmail.com> writes:
> I guess I can think of a few instances, but none that I would've
> chosen to use it in.  IIRC, it's also more likely to increase the cost
> of checkpointing and/or require a good amount of bgwriter tuning.

How so?  AFAICS it'd just eliminate WAL output.

> As long as it's optional, I guess it's OK to let the administrator
> deal with recovery.

As I understood it, the proposal was for a feature that would arrange
for the required index rebuild to happen *automatically* during crash
recovery.  I agree it'd be unacceptable if it requires manual
intervention at restart.

It occurs to me that if we had such a behavior, we could use it to "fix"
hash indexes to be crash-safe, with less effort than WAL-ifying the hash
code: just put in a small kluge to mark all hash indexes as needing
rebuild during recovery.  Not that I'm against teaching hash to do WAL,
but no one's stepped up to the plate on that yet.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: semaphore usage "port based"?
Next
From: Tom Lane
Date:
Subject: Re: semaphore usage "port based"?