Re: Mini improvement: statement_cost_limit

On Aug 3, 2008, at 9:57 PM, Robert Treat wrote:
>>> I think a variation on this could be very useful in development
>>> and test
>>> environments. Suppose it raised a warning or notice if the cost
>>> was over
>>> the limit. Then one could set a limit of a few million on the
>>> development
>>> and test servers and developers would at least have a clue that they
>>> needed to look at explain for that query. As it is now, one can
>>> exhort
>>> them to run explain, but it has no effect. Instead we later see
>>> queries
>>> killed by a 24 hour timeout with estimated costs ranging from
>>> "until they
>>> unplug the machine and dump it" to "until the sun turns into a red
>>> giant".
>>
>> Great argument. So that's 4 in favour at least.
>>
>
> Not such a great argument. Cost models on development servers can
> and often
> are quite different from those on production, so you might be
> putting an
> artifical limit on top of your developers.

We should have an approved API for dumping stats from one database
and loading them into another. pg_dump needs this as well, IMO.
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828