performance

su - postgres
"/usr/lib/postgresql/15/bin/vacuumdb" -p 45432 --all --analyze-in-stages
"/usr/lib/postgresql/15/bin/vacuumdb" -p 45432 --all -v

Default configuration: Web worker configuration:

OPENPROJECT_WEB_WORKERS="2"
OPENPROJECT_WEB_TIMEOUT="60"
OPENPROJECT_WEB_WAIT__TIMEOUT="10"
OPENPROJECT_WEB_MIN__THREADS="4"
OPENPROJECT_WEB_MAX__THREADS="16"

Scaling the number of web workers

openproject config:set OPENPROJECT_WEB_WORKERS=4
openproject configure
# or
openproject restart web

Run Puma in single-mode (workers = 0) in order to reduce memory overhead.

/etc/openproject/conf.d/other

export OPENPROJECT_WEB_WORKERS="0"
export OPENPROJECT_WEB_MIN__THREADS="2"
export OPENPROJECT_WEB_MAX__THREADS="4"
# Settings this by env also works:
#expprt RAILS_MIN_THREADS="2"
#export RAILS_MAX_THREADS="4"

openproject configure
# or
openproject restart web

journalctl -u openproject
journalctl -u openproject-web-1

openproject config:set OPENPROJECT_WEB_TIMEOUT="300"
openproject restart web