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

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

From: dg(at)illustra(dot)com (David Gould)
To: Andreas(dot)Zeugswetter(at)telecom(dot)at (Zeugswetter Andreas SARZ)
Cc: raines(at)SLAC(dot)Stanford(dot)EDU, pgsql-hackers(at)hub(dot)org
Subject: Re: AW: [HACKERS] Re: Let's talk up 6.3
Date: 1998-03-30 19:14:18
Message-ID: 9803301914.AA02899@hawk.illustra.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Andreas:
> > 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).

The rule 'if the first attribute of an index is unique, then additional
attributes are basically useless' is exactly correct for all systems, not
just PostgreSQL. It has nothing to do with whether indexes are used for
'orderby'.

A bit of thought will reveal that if the first key is unique then there
is no way any subsequent key can influence the sort order. Consider:

 col1 col2
 ---- ----
  A    9
  B    5
  C    1
 ...  ...

There is no value you can put in col2 that will make 'A' sort after 'B'.

-dg

David Gould            dg(at)illustra(dot)com           510.628.3783 or 510.305.9468 
Informix Software  (No, really)         300 Lakeside Drive  Oakland, CA 94612
"Of course, someone who knows more about this will correct me if I'm wrong,
 and someone who knows less will correct me if I'm right."
               --David Palmer (palmer(at)tybalt(dot)caltech(dot)edu)

In response to

pgsql-hackers by date

Next:From: teunisDate: 1998-03-30 19:53:58
Subject: CVSup
Previous:From: Bruce MomjianDate: 1998-03-30 18:35:34
Subject: Re: AW: [HACKERS] Re: Let's talk up 6.3

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