Re: Buglist

Jan Wieck <janwieck@yahoo.com>

From: Jan Wieck <JanWieck@Yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Stephan Szabo <sszabo@megazone.bigpanda.com>, Alvaro Herrera <alvherre@dcc.uchile.cl>, Vivek Khera <khera@kcilink.com>, pgsql-general@postgresql.org
Date: 2003-08-20T20:10:31Z
Lists: pgsql-hackers, pgsql-general
Tom Lane wrote:

> Recall also that "committed deleted" does not mean "safe to remove".
> There may still be live transactions that could see the tuple.  The
> "committed deleted" bit just exists to allow subsequent visitors to the
> row to skip one of the more expensive steps in deciding whether they can
> see it or not.
> 
> To determine that a row is removable requires additional tests above and
> beyond what backends normally do.

Aah - there is the first bullet hole in my multi-ctid-index-idea. Now 
the question becomes how expensive these tests are (if a normal backend 
can do them at all within reason)?


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #