Re: Get more from indices. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Get more from indices.
Date
Msg-id 3790.1383240163@sss.pgh.pa.us
Whole thread Raw
In response to Re: Get more from indices.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I wrote:
> Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> writes:
>> Unique indexes can sort the tuples in corresponding tables
>> prefectly. So this query might can use index.

BTW, how much of any of this is correct if the "unique" index contains
multiple NULL values?  We might need to restrict the optimization(s)
to cases where the unique-ified columns are all marked NOT NULL.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: API bug in DetermineTimeZoneOffset()
Next
From: Tom Lane
Date:
Subject: Re: API bug in DetermineTimeZoneOffset()