On May 15, 2005, at 5:37 AM, Andre Nas wrote:Hello …Im using source postgresql 8.0.3 under FreeBSD and already install, the database is running well. Not that this has much to do with performance, but the problem is that you need to use gmake to build postgres stuff. The BSD make doesn't know abo
=?ISO-8859-2?Q?Sz=FBcs_G=E1bor?= <[EMAIL PROTECTED]> writes:
> Create a table with (at least) two fields, say i and o.
> Create three indexes on (i), (o), (i,o)
> Insert enough rows to test.
> Try to replace min/max aggregates with indexable queries such as:
> SELECT o FROM t WHERE i = 1 ORDER BY
SELECT o FROM t WHERE i = 1 ORDER BY o LIMIT 1;
use :
ORDER BY i, o
If you have a multicol index and want to order on it, you should help the
planner by ORDERing BY all of the columns in the index...
It bit me a few times ;)
---(end of broadcast)---
Dear Gurus,
I don't think it's a bug, I just don't understand what's behind this. If
there's a paper or something on this, please point me there.
Version: 7.4.6
Locale: hu_HU (in case that matters)
Dump: see below sig.
Abstract:
Create a table with (at least) two fields, say i and o.
Create three
