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 26463.1006389446@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>)
Responses Re: TOAST performance (was Re: [GENERAL] Delete Performance)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> I don't see how that reduces the total amount of disk traffic?

> Well, right now we write the pre-image to WAL, then write the new page
> over the old one.  In my case, you just write the new, and somewhere
> record that the old page is no longer active.

The devil is in the details of that last little bit.  How is "mark a
page inactive" cheaper than "mark a tuple dead"?  More specifically,
how do you propose to avoid WAL-logging the page you are going to do
this marking in?  Seems you still end up with a WAL page image for
something.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: TOAST performance (was Re: [GENERAL] Delete Performance)
Next
From: Bruce Momjian
Date:
Subject: Re: TOAST performance (was Re: [GENERAL] Delete Performance)