AW: [HACKERS] Re: Let's talk up 6.3 - Mailing list pgsql-hackers

From Zeugswetter Andreas SARZ
Subject AW: [HACKERS] Re: Let's talk up 6.3
Date
Msg-id 219F68D65015D011A8E000006F8590C6010A5240@sdexcsrv1.sd.spardat.at
Whole thread Raw
Responses Re: AW: [HACKERS] Re: Let's talk up 6.3  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: AW: [HACKERS] Re: Let's talk up 6.3  (dg@illustra.com (David Gould))
List pgsql-hackers
> Would a rule be that
> if the first attribute of an index is unique, then additional
> attributes are basically useless?

For PostgreSQL this is currently true, since indexes are currently not
used for order by. If you have a unique first column in an index,
then all following columns could only be used for sorting,
not for faster access (access actually gets worse).

Andreas


pgsql-hackers by date:

Previous
From: Paul Raines
Date:
Subject: Re: Let's talk up 6.3
Next
From: "Vadim B. Mikheev"
Date:
Subject: Re: Let's talk up 6.3