Re: Correlation in cost_index() - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: Correlation in cost_index()
Date
Msg-id Pine.LNX.4.33.0210031059070.5705-100000@css120.ihs.com
Whole thread Raw
In response to Re: Correlation in cost_index()  (Manfred Koizar <mkoi-pg@aon.at>)
Responses Re: Correlation in cost_index()  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-hackers
On Thu, 3 Oct 2002, Manfred Koizar wrote:

> On Wed, 2 Oct 2002 14:07:19 -0600 (MDT), "scott.marlowe"
> <scott.marlowe@ihs.com> wrote:
> >I've found that when the planner misses, sometimes it misses 
> >by HUGE amounts on large tables,
> 
> Scott,
> 
> yet another question: are multicolunm indices involved in your
> estimator problems?

No.  Although I use them a fair bit, none of the problems I've encountered 
so far have involved them.  But I'd be willing to setup some test indexes 
and get some numbers on them.



pgsql-hackers by date:

Previous
From: Justin Clift
Date:
Subject: Re: [GENERAL] Anyone want to assist with the translation of theAdvocacy
Next
From: Tom Lane
Date:
Subject: Re: anoncvs and diff