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 18456.1005962874@sss.pgh.pa.us
Whole thread Raw
In response to TOAST performance (was Re: [GENERAL] Delete Performance)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: TOAST performance (was Re: [GENERAL] Delete Performance)
Re: TOAST performance (was Re: [GENERAL] Delete Performance)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Is it because we take a snapshot of the page before we write it in case
> we only write part of the page?

AFAIR, the partial-page-write problem is the entire reason for doing it.
If we could be certain that writes to datafile pages were atomic, we'd
not need this.

Of course we can't be certain of that.  But I'm wondering if there isn't
a cheaper solution.
        regards, tom lane


pgsql-hackers by date:

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