> mergejoinscansel doesn't currently try to fix up the histogram bounds
> consulting indexes. At the time I was afraid of the costs of doing
> that, and I still am; but it would be a way to address this issue.
Oh? Hmmm. I have a ready-made test case for the benefit case on this. However, I'm not clear on how we would test the costs.
But this type of query plan is clearly pathological, and is experienced by users as a performance regression since 8.3. I now have the user doing analyzes of fairly large tables 2/hour to avoid the problem. So I don't think we can leave it alone.
PostgreSQL Experts Inc.
In response to
pgsql-performance by date
|Next:||From: Greg Smith||Date: 2011-03-28 06:02:42|
|Subject: Re: buffercache/bgwriter|
|Previous:||From: Nathan Boley||Date: 2011-03-25 22:43:04|
|Subject: Re: Shouldn't we have a way to avoid "risky" plans?|