Re: TOAST performance (was Re: [GENERAL] Delete Performance)

> 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