[PERFORM] where+orderby+limit not (always) using appropriate index?

2005-05-18 Thread Szűcs Gábor
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

Re: [PERFORM] where+orderby+limit not (always) using appropriate index?

2005-05-18 Thread Tom Lane
=?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 o