PostgreSQL: set effective_cache_size and increase max_connections

IDR / deployment

Deployment infrastructure for the Image Data Resource

https://idr.openmicroscopy.org/about/deployment.html

BSD 2-Clause "Simplified" License

13 stars 14 forks source link

PostgreSQL: set effective_cache_size and increase max_connections #428

Closed sbesson closed 4 months ago

sbesson commented 5 months ago

The first configuration change was found to be the critical parameter modified during the Rocky Linux 9 migration. The maximal number of connections was bumped during the work on test122

For the next release, we might want to resurrect the work on #424 but the underlying Ansible changes requires additional assessment. In the scope of the prod122 release, this should contain the minimal set of PostgreSQL variable changes to allow deployments without manually copying a configuration file over.

sbesson commented 4 months ago

Closing in favor of #424 which will is expected to be deployed on the next production