Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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).



pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group