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(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:25:27
Message-ID: 16335.1141147527@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> 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?

The old row is ALWAYS visible to somebody, until you commit (if you ever
do). You can't simply overwrite existing data.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-02-28 17:28:45 Re: [HACKERS] how solve diff of API counstruct_md_array between
Previous Message Bruce Momjian 2006-02-28 17:23:25 Re: Dead Space Map