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 or whole thread)
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-2015 The PostgreSQL Global Development Group