AW: [HACKERS] Re: Let's talk up 6.3

From: Zeugswetter Andreas SARZ <Andreas(dot)Zeugswetter(at)telecom(dot)at>
To: "'raines(at)SLAC(dot)Stanford(dot)EDU'" <raines(at)SLAC(dot)Stanford(dot)EDU>
Cc: "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org>
Subject: AW: [HACKERS] Re: Let's talk up 6.3
Date: 1998-03-30 18:19:01
Message-ID: 219F68D65015D011A8E000006F8590C6010A5240@sdexcsrv1.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim B. Mikheev 1998-03-30 18:31:41 Re: Let's talk up 6.3
Previous Message Paul Raines 1998-03-30 17:54:50 Re: Let's talk up 6.3