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.