Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!

From: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
Date: 2018-05-21 14:34:35
Message-ID: 1526913275452-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi abbas,

Thank you so much. I've got this query from my development team asking to
improve its performance.

Now I got pretty much clear idea of it. And it will be the final extent to
which we can tune the performance right?

If there is still a way give me some tips to enhance the query performance.

But kudos for your "floor" function. After a long struggle with the indexes,
joins and the hints I came to know that there is also a way to tune the
query performance by rewriting the query.

Thanks in advance.

Regards,
Pavan

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message pavan95 2018-05-21 14:43:57 Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
Previous Message Abbas 2018-05-21 14:12:06 Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!