Am 26.05.2017 um 14:31 schrieb Dinesh Chandra 12108:
Hi Thomas,
Thanks for your reply.
Yes, the query is absolutely same which I posted.
Please suggest if something need to change in query.
As Per your comment...
The query you posted includes there two join conditions:
evidence_to_do.
e-
From: Tomas Vondra [mailto:tomas.von...@2ndquadrant.com]
Sent: 25 May, 2017 9:08 PM
To: Dinesh Chandra 12108
Cc: pgsql-performance@postgresql.org
Subject: [EXTERNAL] Re: FW: Re: [PERFORM] Query is running very slow..
On 5/25/17 2:26 PM, Dinesh Chandra 12108 wrote:
> Hi Tomas,
>
> Please f
On 5/25/17 2:26 PM, Dinesh Chandra 12108 wrote:
Hi Tomas,
Please find the below input for slow query.
(a) something about the hardware it's running on
RAM-->64 GB, CPU->40core
(b) amounts of data in the tables / databases
Database size :32GB
-
Tables size
Hi Tomas,
Please find the below input for slow query.
(a) something about the hardware it's running on
RAM-->64 GB, CPU->40core
(b) amounts of data in the tables / databases
Database size :32GB
-
Tables size
-
Workflow.project: 8194 byte
workflo