From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: TOAST performance (was Re: [GENERAL] Delete Performance) |
Date: | 2001-11-22 09:49:19 |
Message-ID: | 3BFCCA1F.AF32EF7F@tm.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Tom Lane wrote:
>
> 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.
IIRC the double space requrement is what has kept us from implementing
DROP COLUMN.
-----------
Hannu
From | Date | Subject | |
---|---|---|---|
Next Message | Colin 't Hart | 2001-11-22 11:14:54 | Re: Version checking when loading psql |
Previous Message | Hannu Krosing | 2001-11-22 09:34:50 | Re: TOAST performance (was Re: [GENERAL] Delete Performance) |
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2001-11-22 10:13:41 | Re: Database mirroring |
Previous Message | Nicolas Verger | 2001-11-22 09:47:15 | JDBC improvements |