Re: setting for maximum acceptable plan cost?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: setting for maximum acceptable plan cost?
Date: 2007-11-02 21:47:57
Message-ID: 28423.1194040077@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jeffrey W. Baker" <jwbaker(at)acm(dot)org> writes:
> I was thinking that it might be nice to be able to tell postgres to
> refuse to execute any plan with an estimated cost above some threshold.

What you suggest has been suggested before, and I might think it was
a good idea if I trusted the planner's cost estimates more ;-)

There's always statement_timeout.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Mayer 2007-11-02 21:49:19 Re: select random order by random
Previous Message Joshua D. Drake 2007-11-02 21:45:00 Re: setting for maximum acceptable plan cost?