Re: Order by optimisations? - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Order by optimisations?
Date
Msg-id 1996.24.211.165.134.1121341100.squirrel@www.dunslane.net
Whole thread Raw
In response to Re: Order by optimisations?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Order by optimisations?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Christopher Kings-Lynne said:
>

> usatest=# explain select * from users_myfoods_map where
> date='2004-11-21' order by date;

I assume that this is program generated SQL, as I hope a human would know
better than to write this. In which case, isn't the answer to improve the
generator rather than expect postgres to make up for its defficiencies?

cheers

andrew






pgsql-hackers by date:

Previous
From: Michael Fuhr
Date:
Subject: 7.3 regression failures after recent commit
Next
From: "Qingqing Zhou"
Date:
Subject: Re: win32 _dosmaperr()