Skip site navigation (1) Skip section navigation (2)

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(dot) 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: 2006-02-28 17:23:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
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
  SRA OSS, Inc.

  + If your life is a hard drive, Christ can be your backup. +

In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 2006-02-28 17:25:27
Subject: Re: Dead Space Map
Previous:From: Peter EisentrautDate: 2006-02-28 17:19:48
Subject: Re: [HACKERS] how solve diff of API counstruct_md_array between

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group