Re: bad estimates

Поиск
Список
Период
Сортировка
Искать
От
Ken Geis
Тема
Re: bad estimates
Дата
Msg-id
3F4F85DB.2030402@speakeasy.org
Ответ на
Re: bad estimates (Sean Chittenden)
Список
Дерево обсуждения
bad estimates / non-scanning aggregates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates / non-scanning aggregates Bruno Wolff III <bruno@wolff.to>
Re: bad estimates / non-scanning aggregates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates / non-scanning aggregates Bruno Wolff III <bruno@wolff.to>
Re: bad estimates / non-scanning aggregates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates / non-scanning aggregates Bruno Wolff III <bruno@wolff.to>
Re: bad estimates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates Bruno Wolff III <bruno@wolff.to>
Re: bad estimates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates Bruno Wolff III <bruno@wolff.to>
Re: bad estimates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates Jeff <threshar@torgo.978.org>
Re: bad estimates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates Bruno Wolff III <bruno@wolff.to>
Re: bad estimates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates Tom Lane <tgl@sss.pgh.pa.us>
Re: bad estimates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: bad estimates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates Sean Chittenden <sean@chittenden.org>
Re: bad estimates Ken Geis <kgeis@speakeasy.org>
Re: bad estimates Sean Chittenden <sean@chittenden.org>
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 по дате отправления
От: Richard Ellis
Дата:
Сообщение: Re: Indexing question
От: Sean Chittenden
Дата:
Сообщение: Re: bad estimates
FAQ