Re: Buglist - Mailing list pgsql-general

From Jan Wieck
Subject Re: Buglist
Date
Msg-id 3F43D5B7.2000108@Yahoo.com
Whole thread Raw
In response to Re: Buglist  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Buglist  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 #


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Buglist
Next
From: Tom Lane
Date:
Subject: Re: 7.4b1 vs 7.3.4 performance