commit 8bc84d8bd186dbb4150871a610cc032beae7fcad
author ToineSiebelink <toine.siebelink@est.tech> Thu Aug 18 08:43:07 2022 +0100
committer ToineSiebelink <toine.siebelink@est.tech> Thu Aug 18 08:43:20 2022 +0100
tree 4be4efe74d65231fdf34f0aa9ff9cd58ebeef739
parent 060499cb5a89a0fd3d8480132ed82d2e291839dc

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

diff --git a/cps-application/src/main/resources/application.yml b/cps-application/src/main/resources/application.yml
index 6bbe80b..ea1b93b 100644
--- a/cps-application/src/main/resources/application.yml
+++ b/cps-application/src/main/resources/application.yml
@@ -46,6 +46,13 @@
         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 @@
     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