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: 219F68D65015D011A8E000006F8590C6010A5240@sdexcsrv1.sd.spardat.at (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group