Re: [PERFORM] not using index for select min(...)

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PERFORM] not using index for select min(...)
Date: 2003-02-02 21:23:50
Message-ID: 200302021323.50222.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2003-02-02 21:26:46 Re: Interactive Documentation - how do you want it towork?
Previous Message Neil Conway 2003-02-02 20:51:40 Re: Interactive Documentation - how do you want it to