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

From Robert Haas
Subject Re: anti-join chosen even when slower than old plan
Date
Msg-id AANLkTim6JBR4PMPt8NoNZgjoQVamxtDhzNv=+cmEVMRq@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 4: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.

Yeah, I've thought about this, but it's not exactly clear what would
be most useful.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: MVCC performance issue
Next
From: Robert Haas
Date:
Subject: Re: temporary tables, indexes, and query plans