Re: Correlation in cost_index()

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: Correlation in cost_index()
Дата
Msg-id 6brnpukai7g4fj9sh325svs0i80pitqpke@4ax.com
обсуждение исходный текст
Ответ на Re: Correlation in cost_index()  ("scott.marlowe" <scott.marlowe@ihs.com>)
Ответы Re: Correlation in cost_index()  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список 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 по дате отправления:

Предыдущее
От: Manfred Koizar
Дата:
Сообщение: Re: Correlation in cost_index()
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: psqlODBC *nix Makefile (new 7.3 open item?)