From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | "P(dot)J(dot) \"Josh\" Rovero" <rovero(at)sonalysts(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: TOAST performance (was Re: [GENERAL] Delete Performance) |
Date: | 2001-11-22 00:16:11 |
Message-ID: | 26368.1006388171@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-11-22 00:25:17 | Re: TOAST performance (was Re: [GENERAL] Delete Performance) |
Previous Message | Bruce Momjian | 2001-11-22 00:11:08 | Re: TOAST performance (was Re: [GENERAL] Delete Performance) |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-11-22 00:25:17 | Re: TOAST performance (was Re: [GENERAL] Delete Performance) |
Previous Message | Bruce Momjian | 2001-11-22 00:11:08 | Re: TOAST performance (was Re: [GENERAL] Delete Performance) |