Re: plan question - query with order by and limit not choosing index depends on size of limit, table

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: plan question - query with order by and limit not choosing index depends on size of limit, table
Дата
Msg-id AANLkTinq-xFdC3Lakw6wrJXxeqA+aFGag9w-22cOCtkH@mail.gmail.com
обсуждение исходный текст
Ответ на Re: plan question - query with order by and limit not choosing index depends on size of limit, table  (Mike Broers <mbroers@gmail.com>)
Список pgsql-performance
On Fri, Jan 14, 2011 at 11:36 AM, Mike Broers <mbroers@gmail.com> wrote:
> Thanks Robert, this is what I was looking for.  I will try these suggestions
> and follow up if any of them are the silver bullet.

No problem - and sorry for the off-list reply.  I was a little sleepy
when I wrote that; thanks for getting it back on-list.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: The good, old times
Следующее
От: Robert Haas
Дата:
Сообщение: Re: "SELECT .. WHERE NOT IN" query running for hours