Re: reducing random_page_cost from 4 to 2 to force index scan

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: reducing random_page_cost from 4 to 2 to force index scan
Дата
Msg-id BANLkTiknDrghb5MWczB8foL83HVPy=kR5g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: reducing random_page_cost from 4 to 2 to force index scan  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: reducing random_page_cost from 4 to 2 to force index scan  (Claudio Freire <klaussfreire@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On Wed, Apr 27, 2011 at 3:04 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
> The very first thing to check is effective_cache_size and to set it to
> a reasonable value.
>

The problem there, I think, is that the planner is doing a full join,
instead of a semi-join.

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: reducing random_page_cost from 4 to 2 to force index scan
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: reducing random_page_cost from 4 to 2 to force index scan