Re: [PERFORM] not using index for select min(...) - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: [PERFORM] not using index for select min(...)
Date
Msg-id 200302021323.50222.josh@agliodbs.com
Whole thread Raw
In response to Re: [PERFORM] not using index for select min(...)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom,

> I think you are leaping to conclusions about why there's a speed
> difference.  Or maybe I'm too dumb to see how an index could be used
> to speed these min/max operations --- but I don't see that one would
> be useful.  Certainly not an index on treeno alone.  Would you care to
> explain exactly how it's done?

If I knew that, I'd have proposed a patch already, yes?

I'm working on it.

--
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: Interactive Documentation - how do you want it to
Next
From: "Dave Page"
Date:
Subject: Re: Interactive Documentation - how do you want it towork?