Re: [HACKERS] Performance-improvement idea: shortcircuit unique-index checks

2001-02-19 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Seems a better solution would be to put a 'deleted' bit in the index so > we would have to visit those heap tuples only once for a committed > status. Similar to what we do with heap tuples so we don't have to > visit pg_log repeatedly. That's only a p

[HACKERS] Performance-improvement idea: shortcircuit unique-index checks

2001-02-19 Thread Tom Lane
Over the weekend I noticed that Tatsuo's pgbench benchmark seems to spend an awful lot of its time down inside _bt_check_unique. This happens because with table declarations like create table accounts(aid int, primary key(aid), bid int, abalance int, filler char(84)) an