Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance-improvement idea: shortcircuit unique-indexchecks - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: Performance-improvement idea: shortcircuit unique-indexchecks
Date
Msg-id 3A91BF80.C65CEF0D@tpf.co.jp
Whole thread Raw
In response to Re: Performance-improvement idea: shortcircuit unique-index checks  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Bruce Momjian wrote:
> 
> > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 
> Yes.  Let me add some TODO items:
> 
>         * Add deleted bit to index tuples to reduce heap access

ISTM this isn't a bad idea. However note that there remains only
1 bit unused in IndexTupleData.

Regards,
Hiroshi Inoue

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [ADMIN] v7.1b4 bad performance
Next
From: Hiroshi Inoue
Date:
Subject: Re: floating point representation