Re: Why my query not using index to sort?

From: Arup Rakshit <ar(at)zeit(dot)io>
To: Ravi Krishna <srkrishna1(at)aol(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why my query not using index to sort?
Date: 2018-09-28 13:19:31
Message-ID: BFE70F8F-4F4A-431F-BF73-A648BF108C83@zeit.io
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
ar(at)zeit(dot)io

> On 28-Sep-2018, at 6:38 PM, Ravi Krishna <srkrishna1(at)aol(dot)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)?
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2018-09-28 13:28:23 Re: How to maintain the csv log files in pg_log directory only for past 30 days
Previous Message Adrian Klaver 2018-09-28 13:19:16 Re: How to maintain the csv log files in pg_log directory only for past 30 days