Postgres Pro
Downloads
Home   >   mailing lists

Re: Why my query not using index to sort? - Mailing list pgsql-general

From Arup Rakshit
Subject Re: Why my query not using index to sort?
Date
Msg-id BFE70F8F-4F4A-431F-BF73-A648BF108C83@zeit.io
Whole thread Raw
In response to Re: Why my query not using index to sort?  (Ravi Krishna <srkrishna1@aol.com>)
Responses Re: Why my query not using index to sort?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to maintain the csv log files in pg_log directory only forpast 30 days
Next
From: Francisco Olarte
Date:
Subject: Re: How to maintain the csv log files in pg_log directory only forpast 30 days