Re: Re: New server to improve performance on our large and busy DB - advice? (v2)

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Re: New server to improve performance on our large and busy DB - advice? (v2)
Дата
Msg-id 603c8f071001150641p696411f0o4360c7068221fa23@mail.gmail.com
обсуждение исходный текст
Ответ на Re: New server to improve performance on our large and busy DB - advice? (v2)  (Ivan Voras <ivoras@freebsd.org>)
Список pgsql-performance
Дерево обсуждения 
On Fri, Jan 15, 2010 at 8:43 AM, Ivan Voras <ivoras@freebsd.org> wrote:
> Have you tried decreasing random_page_cost in postgresql.conf? Or setting
> (as a last resort) enable_seqscan = off?

If you need to set enable_seqscan to off to get the planner to use
your index, the chances that that index are actually going to improve
performance are extremely poor.

...Robert

В списке pgsql-performance по дате отправления:

Предыдущее
От: Ivan Voras
Дата:
Сообщение: Re: New server to improve performance on our large and busy DB - advice? (v2)
Следующее
От: "Ing. Marcos L. Ortiz Valmaseda"
Дата:
Сообщение: Re: Re: New server to improve performance on our large and busy DB - advice? (v2)