You can consider outside DB encryption which is less of worry for performance
and data at rest will be encrypted.
Regards,
Virendra
-Original Message-
From: ROS Didier [mailto:didier@edf.fr]
Sent: Sunday, October 07, 2018 2:33 PM
To: fola...@peoplecall.com
Cc: pavel.steh...@gmail.com;
Can somebody help me avoid nested loops in below query:
--
ap_poc_db=# explain (analyze,buffers)
ap_poc_db-# select site_id, account_id FROM ap.site_exposure se
ap_poc_db-# WHERE se.portfolio_id=-1191836
ap_poc_db-# AND EXISTS (select 1 from ap.catevent_flood_sc_split sp
where
It did not seem to help.
See attachment.
Regards,
Virendra
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Tuesday, January 09, 2018 6:00 PM
To: Kumar, Virendra
Cc: pgsql-performa...@postgresql.org
Subject: Re: Performance of a Query
On Tue, Jan 9, 2018 at
: Tuesday, January 09, 2018 5:08 PM
To: Kumar, Virendra
Cc: pgsql-performa...@postgresql.org
Subject: Re: Performance of a Query
On Tue, Jan 9, 2018 at 2:18 PM, Kumar, Virendra
wrote:
> Hello Gurus,
>
> I am struggling to tune a query which is doing join on top of
> aggregate for arou
Hello Gurus,
I am struggling to tune a query which is doing join on top of aggregate for
around 3 million rows. The plan and SQL is attached to the email.
Below is system Details:
PGSQL version - 10.1
OS - RHEL 3.10.0-693.5.2.el7.x86_64
Binary - Dowloaded from postgres.org compiled and installe
