Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever
Date
Msg-id 19671.1105909715@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever  (Michael Fuhr <mike@fuhr.org>)
Responses Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
Michael Fuhr <mike@fuhr.org> writes:
> Would it be accurate to say that the planner makes the bet most
> likely to win without regard to how badly it might lose?

Yes, I think that's a fair summary.

> Is taking the downside into consideration a tough problem to solve, or
> is it simply not worthwhile in the large?

I don't know how to solve it, and whether it would be worthwhile would
depend considerably on how expensive the proposed solution is ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Luiz Gonzaga da Mata"
Date:
Subject: Re: Bug in check constraint?
Next
From: Josh Berkus
Date:
Subject: Error in 8.0 rc5 with repeat calls to array operator