On 9/28/18 6:19 AM, Arup Rakshit wrote:
Hi Ravi,
Yes you are right. It seems it is doing sorting in memory by name. But I
have `name` column in index.
You are looking for the vessels.company_id not vessels.name so not sure
why you expect an index lookup on name?
Thanks,
Arup Rakshit
[email protected] <mailto:[email protected]>
On 28-Sep-2018, at 6:38 PM, Ravi Krishna <[email protected]
<mailto:[email protected]>> 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)?
--
Adrian Klaver
[email protected]
