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 26368.1006388171@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:
> What bothers me about this is that we have the original page with the
> old data.  It would be nice if we could write the new page in a
> different location, make the new page active and recycle the old page at
> some later time.

I don't see how that reduces the total amount of disk traffic?

It's also kind of unclear how to do it without doubling (or worse) the
amount of table space used in many common scenarios.  I doubt many
people will be happy if "DELETE FROM foo" requires transient space equal
to twice the original size of foo.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Taking databases offline
Next
From: Bruce Momjian
Date:
Subject: Re: Taking databases offline