Re: Order by optimisations?

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: <chriskl(at)familyhealth(dot)com(dot)au>
Cc: <hannu(at)skype(dot)net>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Order by optimisations?
Date: 2005-07-14 11:38:20
Message-ID: 1996.24.211.165.134.1121341100.squirrel@www.dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Fuhr 2005-07-14 12:13:48 7.3 regression failures after recent commit
Previous Message Michael Paesold 2005-07-14 09:32:44 Re: Order by optimisations?