Re: Performance Improvement for Unique Indexes - Mailing list pgsql-hackers

From Gokulakannan Somasundaram
Subject Re: Performance Improvement for Unique Indexes
Date
Msg-id 9362e74e1003240834h531cefd8m52dd70b24877f359@mail.gmail.com
Whole thread Raw
In response to Re: Performance Improvement for Unique Indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

it seems fairly unlikely to me that this would be useful enough to
justify using up a precious hint bit.  The applicability of the hint
is very short-term --- as soon as the tuple is dead to all transactions,
it can be marked with the existing LP_DEAD hint bit.  And if it's only
useful for uniqueness checks, as seems to be the case, that's another
big restriction on the value.

Right. It is of little value.

Gokul.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP: preloading of ispell dictionary
Next
From: Tom Lane
Date:
Subject: last_statrequest is in the future