Starting from openBIS version 20.10.0, memory and CPU usage greatly improved. The following guidelines cannot be applied to previous versions.


Below we provide a template for a small ELN-LIMS installation. Please bear in mind that the more customised an openBIS installation is, the more memory settings can vary from the template. 


Small ELN-LIMS Installation (3GB configuration)


Use-case

  • Default ELN LIMS UI using Generic or Life-Sciences Technologies
  • New Admin UI
  • 5 concurrent users


Settings

  • CPU : 2 modern x86 CPU cores.
  • AS: 512MB
  • Postgres : 1GB
  • DSS : 512MB
  • Linux OS: 1G


Postgres memory settings

Postgres memory settings can be obtained from https://pgtune.leopard.in.ua/ following this template:

  • DB Version: 11
  • OS Type: Linux
  • DB Type: Web
  • Total Memory (RAM): X GB
  • CPUs num: 2
  • Connections num: 50
  • Data Storage: SSD or HDD


Postgres configuration for SSD Storage


# DB Version: 11
# OS Type: linux
# DB Type: web
# Total Memory (RAM): 1 GB
# CPUs num: 2
# Connections num: 50
# Data Storage: ssd

max_connections = 50
shared_buffers = 256MB
effective_cache_size = 768MB
maintenance_work_mem = 64MB
checkpoint_completion_target = 0.9
wal_buffers = 7864kB
default_statistics_target = 100
random_page_cost = 1.1
effective_io_concurrency = 200
work_mem = 5242kB
min_wal_size = 1GB
max_wal_size = 4GB
max_worker_processes = 2
max_parallel_workers_per_gather = 1
max_parallel_workers = 2
max_parallel_maintenance_workers = 1

Postgres configuration for HHD Storage

# DB Version: 11
# OS Type: linux
# DB Type: web
# Total Memory (RAM): 1 GB
# CPUs num: 2
# Connections num: 50
# Data Storage: hdd

max_connections = 50
shared_buffers = 256MB
effective_cache_size = 768MB
maintenance_work_mem = 64MB
checkpoint_completion_target = 0.9
wal_buffers = 7864kB
default_statistics_target = 100
random_page_cost = 4
effective_io_concurrency = 2
work_mem = 5242kB
min_wal_size = 1GB
max_wal_size = 4GB
max_worker_processes = 2
max_parallel_workers_per_gather = 1
max_parallel_workers = 2
max_parallel_maintenance_workers = 1

General Tips to modify above template

  • Slower Query Execution: Increase CPU number and/or AS & Postgres memory settings. Obtain new Postgres settings from https://pgtune.leopard.in.ua/.
  • AS log shows out of memory errors: Increase AS Memory. This easily happens in old installations using the Legacy Core UI that requires additional memory for cache.
  • DSS log shows out of memory errors: Increase DSS Memory.
  • No labels