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

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

From: Zeugswetter Andreas SARZ <Andreas(dot)Zeugswetter(at)telecom(dot)at>
To: "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org>
Cc: 'raines(at)SLAC(dot)Stanford(dot)EDU'
Subject: Re: [HACKERS] Re: Let's talk up 6.3
Date: 1998-03-31 07:48:39
Message-ID: 219F68D65015D011A8E000006F8590C6010A5242@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?
	>>  
<< cut some of my nonsense here >> 

	David Gould writes:
	>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'.

The second Ooops in one day, I guess I have to relearn the meaning of
"First think then talk.", Sorry.  (what a day, well at least the sun is
shining here :-) 
But to speak in self defense there is still one case where the trailing 
columns in this index would help. If only index columns are selected,
the engine could do an index only scan (not in postgresql yet).

Andreas



pgsql-hackers by date

Next:From: Vadim B. MikheevDate: 1998-03-31 08:20:55
Subject: Re: [HACKERS] Reminder: Indices are not used
Previous:From: Zeugswetter Andreas SARZDate: 1998-03-31 07:21:13
Subject: AW: AW: [HACKERS] Re: Let's talk up 6.3

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