Re: SELECT ignoring index even though ORDER BY and LIMIT present

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: SELECT ignoring index even though ORDER BY and LIMIT present
Дата
Msg-id 4C0694060200002500031DEA@gw.wicourts.gov
обсуждение исходный текст
Ответ на SELECT ignoring index even though ORDER BY and LIMIT present  (Jori Jovanovich <jori@dimensiology.com>)
Ответы Re: SELECT ignoring index even though ORDER BY and LIMIT present  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения 
Jori Jovanovich <jori@dimensiology.com> wrote:

> what is the recommended way to solve this?

The recommended way is to adjust your costing configuration to
better reflect your environment.  What version of PostgreSQL is
this?  What do you have set in your postgresql.conf file?  What does
the hardware look like?  How big is the active (frequently
referenced) portion of your database?

-Kevin

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

Предыдущее
От: Jori Jovanovich
Дата:
Сообщение: SELECT ignoring index even though ORDER BY and LIMIT present
Следующее
От: Szymon Guz
Дата:
Сообщение: Re: SELECT ignoring index even though ORDER BY and LIMIT present