Re: anti-join chosen even when slower than old plan - Mailing list pgsql-performance

From bricklen
Subject Re: anti-join chosen even when slower than old plan
Date
Msg-id AANLkTimLhP0Ja_gETnSoW9uuQGS0ETGFZMztpxeaAhkh@mail.gmail.com
Whole thread Raw
In response to Re: anti-join chosen even when slower than old plan  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-performance
On Sat, Nov 13, 2010 at 1:32 AM, Marc Mamin <M.Mamin@intershop.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.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: temporary tables, indexes, and query plans
Next
From: Jon Nelson
Date:
Subject: Re: temporary tables, indexes, and query plans