Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Dead Space Map
- From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
- To: Tom Lane <tgl(at)sss(dot)pgh(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:23:25 -0500 (EST)
Tom Lane wrote: > 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? If the old row is not visible to any transactions, why would it not work? -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. +
- Follow-Ups:
- Re: Dead Space Map
- From: Tom Lane
- Re: Dead Space Map
- References:
- Re: Dead Space Map
- From: Tom Lane
- Re: Dead Space Map
- Prev by Date: Re: pg_config, pg_service.conf, postgresql.conf ....
- Next by Date: Re: Dead Space Map
- Previous by thread: Re: Dead Space Map
- Next by thread: Re: Dead Space Map
- Indexes: