Please post EXPLAIN ANALYZE output for the two queries.
As I wrote in my first post, I pasted this together with the two queries
at pastebin.com:
http://pastebin.com/m3c0d1896
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
In response to Matthew [EMAIL PROTECTED]:
On Fri, 30 Nov 2007, cluster wrote:
Can anyone explain the following odd behavior?
I have a query that completes in about 90 ms. If I append LIMIT to the
very end, eg. LIMIT 500 the evaluation time increases to about 800 ms.
How can performance
On Fri, 30 Nov 2007, cluster wrote:
Can anyone explain the following odd behavior?
I have a query that completes in about 90 ms. If I append LIMIT to the
very end, eg. LIMIT 500 the evaluation time increases to about 800 ms.
How can performance get *worse* by giving the database the option to
Can anyone explain the following odd behavior?
I have a query that completes in about 90 ms. If I append LIMIT to the
very end, eg. LIMIT 500 the evaluation time increases to about 800 ms.
How can performance get *worse* by giving the database the option to
stop the evaluation earlier (when it