Re: TOAST performance (was Re: [GENERAL] Delete Performance) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: TOAST performance (was Re: [GENERAL] Delete Performance)
Date
Msg-id 200111170509.fAH59we27942@candle.pha.pa.us
Whole thread Raw
In response to TOAST performance (was Re: [GENERAL] Delete Performance)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Seriously, how do OS's handle partial page write, especially to
> > directories?


I realize UPDATE also requires pre-page writes for the old tuples.  What
bothers me is that unlike INSERT and UPDATE of new rows, DELETE and
UPDATE of old rows is not writing new data but just setting transaction
ID's.  I wish there was a way to store those XID's somewhere else so the
page wouldn't have to be modified.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Mike Rogers"
Date:
Subject: Re: [BUGS] [PG MAIL LISTS] SEND OUT ALL????
Next
From: Bruce Momjian
Date:
Subject: Re: TOAST performance (was Re: [GENERAL] Delete Performance)