In _bt_check_unique() loop, don't bother applying _bt_isequal() to

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 5ac2d7c0ebdb1071643f77a6f1fa1a54fd469fb8
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2003-09-02T22:10:16Z
Releases: 7.4.1
In _bt_check_unique() loop, don't bother applying _bt_isequal() to
killed items; just skip to the next item immediately.  Only check for
key equality when we reach a non-killed item or the end of the index
page.  This saves key comparisons when there are lots of killed items,
as for example in a heavily-updated table that's not been vacuumed lately.
Seems to be a win for pgbench anyway.

Files

PathChange+/−
src/backend/access/nbtree/nbtinsert.c modified +27 −15