On Sat, Nov 13, 2010 at 1:32 AM, Marc Mamin <M(dot)Mamin(at)intershop(dot)de> wrote:
> Hello,
>
> Just a short though:
>
> Is it imaginable to compare the prognoses of the plans with the actual
> results
> and somehow log the worst cases ?
>
> a) to help the DBA locate bad statistics and queries
> b) as additional information source for the planner
>
> This could possibly affect parameters of your formula on the fly.
>
> best regards,
>
> Marc Mamin
The contrib module auto_explain might help out here if you wanted to
roll your own solution for plan comparison.