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

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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
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 18:35:34
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).

Sorry, don't follow this logic.  He is not restricting on the first
field of the index, so the index is not used.

Bruce Momjian                          |  830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

In response to

pgsql-hackers by date

Next:From: David GouldDate: 1998-03-30 19:14:18
Subject: Re: AW: [HACKERS] Re: Let's talk up 6.3
Previous:From: Bruce MomjianDate: 1998-03-30 18:34:15
Subject: Re: Let's talk up 6.3

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