Re: bad estimates - Mailing list pgsql-performance

From Ken Geis
Subject Re: bad estimates
Date
Msg-id 3F4F85DB.2030402@speakeasy.org
Whole thread Raw
In response to Re: bad estimates  (Sean Chittenden <sean@chittenden.org>)
Responses Re: bad estimates
List pgsql-performance
Sean Chittenden wrote:
>>I found I'm suffering from an effect detailed in a previous thread titled
>>
>>    Does "correlation" mislead the optimizer on large tables?
>
>
> I don't know about large tables, but this is a big problem and
> something I'm going to spend some time validating later today.  I
> think Manfred's patch is pretty good and certainly better than where
> we are but I haven't used it yet to see if it's the magic ticket for
> many of these index problems.

I had to dig through a lot of archives to find this.  Is this the patch,
from last October?

http://members.aon.at/pivot/pg/16-correlation.diff

If so, I'll try it out and report my results.


Ken



pgsql-performance by date:

Previous
From: Richard Ellis
Date:
Subject: Re: Indexing question
Next
From: Sean Chittenden
Date:
Subject: Re: bad estimates