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

From Marc Mamin
Subject Re: anti-join chosen even when slower than old plan
Date
Msg-id C4DAC901169B624F933534A26ED7DF31034BB8E4@JENMAIL01.ad.intershop.net
Whole thread Raw
In response to Re: anti-join chosen even when slower than old plan  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Responses Re: anti-join chosen even when slower than old plan
Re: anti-join chosen even when slower than old plan
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Rich
Date:
Subject: Re: MVCC performance issue
Next
From: Jon Nelson
Date:
Subject: do temporary tables have hint bits?