Index problem Need an urgent fix

From: chanukya SDS <chanukyasds(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Index problem Need an urgent fix
Date: 2023-02-03 03:33:03
Message-ID: CAB4f4B5Ca-QhQ15+qbmwBh1upcAroGr2s8CC8cMxB3dDz3FYJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hey All,

I have a query like below

SELECT * FROM data WHERE val=trunc(val) AND
acc_id='kfd50ed6-0bc3-44a9-881f-ec89713fdd80'::uuid ORDER BY ct DESC LIMIT
10;

table structure is

data
(id uuid,
c_id uuid,
acc_id uuid,
val numeric,
ct timestamptz);

Can you please help me to write an index?

or Can someone write an index and revert here..

its very urgent for me.

Thanks
--
Thanks,
Chanukya SDS
+918186868384

Sent From My iPhone

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2023-02-03 03:51:06 Re: How to write a new tuple into page?
Previous Message houzj.fnst@fujitsu.com 2023-02-03 03:29:27 RE: Perform streaming logical transactions by background workers and parallel apply