Skip site navigation (1) Skip section navigation (2)

Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: "Fahad G(dot)" <Fahad(dot)Gilani(at)anusf(dot)anu(dot)edu(dot)au>,pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever
Date: 2005-01-16 21:08:35
Message-ID: 19671.1105909715@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Michael Fuhr <mike(at)fuhr(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Luiz Gonzaga da MataDate: 2005-01-16 22:00:01
Subject: Re: Bug in check constraint?
Previous:From: Michael FuhrDate: 2005-01-16 20:48:14
Subject: Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group