Postgres Pro
Downloads
Home   >   mailing lists

Index problem Need an urgent fix - Mailing list pgsql-hackers

From chanukya SDS
Subject Index problem Need an urgent fix
Date
Msg-id CAB4f4B5Ca-QhQ15+qbmwBh1upcAroGr2s8CC8cMxB3dDz3FYJA@mail.gmail.com
Whole thread Raw
Responses Re: Index problem Need an urgent fix
Re: Index problem Need an urgent fix
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: Perform streaming logical transactions by background workers and parallel apply
Next
From: Bharath Rupireddy
Date:
Subject: Re: How to write a new tuple into page?