Re: Performance-improvement idea: shortcircuit unique-indexchecks

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Performance-improvement idea: shortcircuit unique-indexchecks
Date: 2001-02-20 00:51:12
Message-ID: 3A91BF80.C65CEF0D@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian wrote:
>
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2001-02-20 01:41:52 Re: floating point representation
Previous Message Tom Lane 2001-02-19 23:40:45 Re: [HACKERS] Re: v7.1b4 bad performance