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

From Manfred Koizar
Subject Re: Correlation in cost_index()
Date
Msg-id 6brnpukai7g4fj9sh325svs0i80pitqpke@4ax.com
Whole thread Raw
In response to Re: Correlation in cost_index()  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Correlation in cost_index()
List pgsql-hackers
On Wed, 2 Oct 2002 14:07:19 -0600 (MDT), "scott.marlowe"
<scott.marlowe@ihs.com> wrote:
>I'd certainly be willing to do some testing on my own data with them.  

Great!

>Gotta patch?

Not yet.

>  I've found that when the planner misses, sometimes it misses 
>by HUGE amounts on large tables, and I have been running random page cost 
>at 1 lately, as well as running cpu_index_cost at 1/10th the default 
>setting to get good results.

May I ask for more information?  What are your settings for
effective_cache_size and shared_buffers?  And which version are you
running?

ServusManfred


pgsql-hackers by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: Correlation in cost_index()
Next
From: "Dave Page"
Date:
Subject: Re: psqlODBC *nix Makefile (new 7.3 open item?)