Re: TOAST performance (was Re: [GENERAL] Delete Performance) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: TOAST performance (was Re: [GENERAL] Delete Performance)
Date
Msg-id 27152.1006393246@sss.pgh.pa.us
Whole thread Raw
In response to Re: TOAST performance (was Re: [GENERAL] Delete Performance)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I was thinking of just throwing the inactive page number into WAL.  Much
> smaller than the entire page image.  You don't touch the page.  Does
> that help?

I don't think so.  Somehow you have to tell the other backends that that
page is dead; merely recording it in WAL doesn't do that.

More to the point, you can't recycle (overwrite) that page until you've
checkpointed or WAL-logged the replacement page; so you still end up
with disk I/O for the replacement.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Quick question
Next
From: Tom Lane
Date:
Subject: Re: Mention NLS option in INSTALL