Re: Possible bug in vacuum redo

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: Vadim Mikheev <vmikheev(at)sectorbase(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Possible bug in vacuum redo
Date: 2001-12-24 00:44:44
Message-ID: 5492.1009154684@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> writes:
> I don't think it's preferable either. However there's
> no problem unless there's an application which handle
> the tuples containing the t_ctid link.

What about READ COMMITTED mode? EvalPlanQual uses the t_ctid field
to find the updated version of the row. If the t_ctid is wrong,
you might get an elog(), or you might miss the row you should have
updated, or possibly you might update a row that you shouldn't have.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2001-12-24 01:04:47 Re: Possible bug in vacuum redo
Previous Message Hiroshi Inoue 2001-12-24 00:09:03 Re: Possible bug in vacuum redo