Re: Correlation in cost_index()

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Correlation in cost_index()
Date: 2002-10-03 16:59:54
Message-ID: Pine.LNX.4.33.0210031059070.5705-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 3 Oct 2002, Manfred Koizar wrote:

> On Wed, 2 Oct 2002 14:07:19 -0600 (MDT), "scott.marlowe"
> <scott(dot)marlowe(at)ihs(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tino Wildenhain 2002-10-03 17:05:33 Re: Anyone want to assist with the translation of the
Previous Message Tom Lane 2002-10-03 16:57:43 Re: Trigger regression test output