pgsql-server/src/backend/access/nbtree nbtinsert.c - Mailing list pgsql-committers

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql-server/src/backend/access/nbtree nbtinsert.c
Date
Msg-id 20030902221017.4F9EBD1B8AA@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    tgl@svr1.postgresql.org    03/09/02 19:10:17

Modified files:
    src/backend/access/nbtree: nbtinsert.c

Log message:
    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.


pgsql-committers by date:

Previous
From: petere@svr1.postgresql.org (Peter Eisentraut - PostgreSQL)
Date:
Subject: pgsql-server/src/interfaces/cli example1.c exa ...
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: pgsql-server/src/backend bootstrap/bootstrap.c ...