Skip to content

Instantly share code, notes, and snippets.

@omidp

omidp/application.properties

Created March 18, 2023 11:34
Show Gist options
  • Save omidp/e7918e105a527c057869320783b7c879 to your computer and use it in GitHub Desktop.
Save omidp/e7918e105a527c057869320783b7c879 to your computer and use it in GitHub Desktop.
Download ZIP
Spring boot application.properties for production
Raw
application.properties
## Postgresql configuration
set Postgresql max_connections to 250
## HikariCP configuration
spring.datasource.hikari.minimumIdle=0
spring.datasource.hikari.maximum-pool-size=90
spring.datasource.hikari.maxLifetime=900000
spring.datasource.hikari.data-source-properties.useServerPrepStmts=false
spring.datasource.hikari.data-source-properties.cachePrepStmts=true
spring.datasource.hikari.data-source-properties.prepStmtCacheSize=500
spring.datasource.hikari.data-source-properties.prepStmtCacheSqlLimit=1024
## Hibernate properties
spring.jpa.open-in-view=false
spring.jpa.properties.hibernate.jdbc.batch_size=50
spring.jpa.properties.hibernate.order_inserts=true
spring.jpa.properties.hibernate.order_updates=true
spring.jpa.properties.hibernate.query.plan_cache_max_size=4096
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment