Re: Why my query not using index to sort?

Поиск
Список
Период
Сортировка
От Arup Rakshit
Тема Re: Why my query not using index to sort?
Дата
Msg-id BFE70F8F-4F4A-431F-BF73-A648BF108C83@zeit.io
обсуждение исходный текст
Ответ на Re: Why my query not using index to sort?  (Ravi Krishna <srkrishna1@aol.com>)
Ответы Re: Why my query not using index to sort?
Список pgsql-general
Дерево обсуждения
Hi Ravi,


Yes you are right. It seems it is doing sorting in memory by name. But I have `name` column in index.


Thanks,

Arup Rakshit



On 28-Sep-2018, at 6:38 PM, Ravi Krishna <srkrishna1@aol.com> wrote:


Is there anyway, I can improve the sorting so that it can use the index ?

Are you telling that why PG is not simply reading the data from the index (which is already in sorted
order)?


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: How to maintain the csv log files in pg_log directory only forpast 30 days
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: How to maintain the csv log files in pg_log directory only forpast 30 days