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 #