Re: Dead Space Map - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Dead Space Map
Date
Msg-id 16148.1141146558@sss.pgh.pa.us
Whole thread Raw
In response to Re: Dead Space Map  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Dead Space Map
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> One idea Simon and I had was to reuse heap rows where all indexed values
> in the old row and the new row were the same, meaning the heap value
> could be replaced without changing the indexes at all.  We thought this
> would be very useful for frequently-updated rows.  It could also be used
> if no index are on the table.

MVCC goes out the window, eh?  Not to mention transaction rollback ability?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Mark Woodward"
Date:
Subject: Re: pg_config, pg_service.conf, postgresql.conf ....
Next
From: Tom Lane
Date:
Subject: Re: pg_config, pg_service.conf, postgresql.conf ....