Re: slow query if add order by

[Gaetano Mendola <mendola@bigfoot.com>]

Paolo Tavalazzi wrote:

> I have 2 query that differ only for order by clause.
> The time of execution  of the two query is a lot of different.

How much sort_mem are you using ?

Regards
Gaetano Mendola




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)