> > 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 Gould||Date: 1998-03-30 19:14:18|
|Subject: Re: AW: [HACKERS] Re: Let's talk up 6.3|
|Previous:||From: Bruce Momjian||Date: 1998-03-30 18:34:15|
|Subject: Re: Let's talk up 6.3|