Re: Column correlation drifts, index ignored again

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Column correlation drifts, index ignored again
Дата
Msg-id 18941.1077487618@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Column correlation drifts, index ignored again  (John Siracusa <siracusa@mindspring.com>)
Ответы Re: Column correlation drifts, index ignored again  (John Siracusa <siracusa@mindspring.com>)
Список pgsql-performance
John Siracusa <siracusa@mindspring.com> writes:
>   I want to do something that will convince Postgres that using the date
> index is, by far, the best plan when running my queries, even when the
> date column correlation stat drops well below 1.0.

Have you tried experimenting with random_page_cost?  Seems like your
results suggest that you need to lower it.

            regards, tom lane

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

Предыдущее
От: John Siracusa
Дата:
Сообщение: Re: Column correlation drifts, index ignored again
Следующее
От: John Siracusa
Дата:
Сообщение: Re: Column correlation drifts, index ignored again