From 8bc84d8bd186dbb4150871a610cc032beae7fcad Mon Sep 17 00:00:00 2001
From: ToineSiebelink <toine.siebelink@est.tech>
Date: Thu, 18 Aug 2022 08:43:07 +0100
Subject: [PATCH] Performance Improvement: Postgres Pool Configuration

Issue-ID: CPS-1198
Issue-ID: CPS-1126

Signed-off-by: ToineSiebelink <toine.siebelink@est.tech>
Change-Id: I6e1e6b28cd8e20800df61deae1826ecc2db2945e
---
 cps-application/src/main/resources/application.yml | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/cps-application/src/main/resources/application.yml b/cps-application/src/main/resources/application.yml
index 6bbe80bfb..ea1b93ba4 100644
--- a/cps-application/src/main/resources/application.yml
+++ b/cps-application/src/main/resources/application.yml
@@ -46,6 +46,13 @@ spring:
         password: ${DB_PASSWORD}
         driverClassName: org.postgresql.Driver
         initialization-mode: always
+        hikari:
+            minimumIdle: 5
+            maximumPoolSize: 80
+            idleTimeout: 120000
+            connectionTimeout: 300000
+            leakDetectionThreshold: 300000
+            pool-name: CpsDatabasePool
 
     cache:
         type: caffeine
@@ -164,4 +171,4 @@ timers:
     locked-modules-sync:
         sleep-time-ms: 300000
     cm-handle-data-sync:
-        sleep-time-ms: 30000
\ No newline at end of file
+        sleep-time-ms: 30000
-- 
2.16.6