Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Dead Space Map
- 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: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>, Greg Stark <gsstark(at)mit(dot)edu>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-hackers(at)postgresql(dot)org
- Subject: Re: Dead Space Map
- Date: Tue, 28 Feb 2006 12:09:18 -0500
- Message-id: <16148(dot)1141146558(at)sss(dot)pgh(dot)pa(dot)us>
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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
- Follow-Ups:
- Re: Dead Space Map
- From: Bruce Momjian
- Re: Dead Space Map
- References:
- Re: Dead Space Map
- From: Bruce Momjian
- Re: Dead Space Map
- Prev by Date: Re: pg_config, pg_service.conf, postgresql.conf ....
- Next by Date: Re: pg_config, pg_service.conf, postgresql.conf ....
- Previous by thread: Re: Dead Space Map
- Next by thread: Re: Dead Space Map
- Indexes: