Re: order by slowing down a query by 80 times

Список
Период
Сортировка
От Andres Freund
Тема Re: order by slowing down a query by 80 times
Дата
Msg-id 201006281526.35156.andres@anarazel.de
обсуждение исходный текст
Ответ на Re: order by slowing down a query by 80 times  (Yeb Havinga)
Список pgsql-performance
Дерево обсуждения
order by slowing down a query by 80 times  (Rajesh Kumar Mallah, )
 Re: order by slowing down a query by 80 times  (Yeb Havinga, )
  Re: order by slowing down a query by 80 times  (Andres Freund, )
  Re: order by slowing down a query by 80 times  (Rajesh Kumar Mallah, )
 Re: order by slowing down a query by 80 times  ("Kevin Grittner", )
  Re: order by slowing down a query by 80 times  (Tom Lane, )
   Re: order by slowing down a query by 80 times  (Rajesh Kumar Mallah, )
   Re: order by slowing down a query by 80 times  (Rajesh Kumar Mallah, )
    Re: order by slowing down a query by 80 times  (Tom Lane, )
On Monday 28 June 2010 13:39:27 Yeb Havinga wrote:
> It looks like seq_scans are disabled, since the index scan has only a
> filter expression but not an index cond.
Or its using it to get an ordered result...

Andres

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

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: order by slowing down a query by 80 times
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: order by slowing down a query by 80 times