Re: Mini improvement: statement_cost_limit - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Mini improvement: statement_cost_limit
Date
Msg-id 4894A8DA.2060406@dunslane.net
Whole thread Raw
In response to Mini improvement: statement_cost_limit  ("Hans-Jürgen Schönig" <postgres@cybertec.at>)
Responses Re: Mini improvement: statement_cost_limit  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Hans-Jürgen Schönig wrote:
> hello ...
>
> i picked up csaba nagy's idea and implemented a very simple yet very 
> useful extension.
> i introduced a GUC called statement_cost_limit which can be used to 
> error out if a statement is expected to be too expensive.
> the advantage over statement_timeout is that we are actually able to 
> error out before spending many seconds which is killed by 
> statement_timeout anyway.
>
>  
>   

You clearly have far more faith in the cost estimates than I do.

cheers

andrew


pgsql-hackers by date:

Previous
From: "Hans-Jürgen Schönig"
Date:
Subject: Mini improvement: statement_cost_limit
Next
From: Michael Meskes
Date:
Subject: Re: WITH RECUSIVE patches 0723