Performance Improvement: Postgres Pool Configuration

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

Signed-off-by: ToineSiebelink <toine.siebelink@est.tech>
Change-Id: I6e1e6b28cd8e20800df61deae1826ecc2db2945e

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