Re: Index AM change proposals, redux

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Index AM change proposals, redux
Date: 2008-04-24 16:34:38
Message-ID: 377.1209054878@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> Well, for these two:
> * For Highly Non-Unique Data we can use Duplicate Compression
> * Multi-Column Leading Value Compression - if you have a multi-column

> You don't need any new logic at all. If _bt_compare says they're equal
> you can compact them.

Not if you'd like to support index key retrieval. (The equality
function that btree is using doesn't necessarily mean "equal for all
purposes".)

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2008-04-24 16:35:59 Re: Is this TODO item done?
Previous Message Bruce Momjian 2008-04-24 16:34:26 Re: Proposed patch - psql wraps at window width