Skip site navigation (1) Skip section navigation (2)

Re: anti-join chosen even when slower than old plan

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: anti-join chosen even when slower than old plan
Date: 2010-11-14 00:20:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Sat, Nov 13, 2010 at 4: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.

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

Robert Haas
The Enterprise PostgreSQL Company

In response to

pgsql-performance by date

Next:From: Robert HaasDate: 2010-11-14 00:46:05
Subject: Re: temporary tables, indexes, and query plans
Previous:From: Craig RingerDate: 2010-11-14 00:10:56
Subject: Re: MVCC performance issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group