bcgov / quickstart-openshift

QuickStart template targeted for OpenShift.
https://quickstart-openshift-test-frontend.apps.silver.devops.gov.bc.ca/
Apache License 2.0
30 stars 5 forks source link

chore: postgres-fine-tune #2147

Closed mishraomp closed 3 weeks ago

mishraomp commented 3 weeks ago

Postgres fine tuning based on below https://vladmihalcea.com/postgresql-performance-tuning-settings/


Thanks for the PR!

Deployments, as required, will be available below:

Please create PRs in draft mode. Mark as ready to enable:

After merge, new images are deployed in:

mishraomp commented 3 weeks ago

need to look into this,

2024-10-27 21:21:24,948 WARNING: postgresql parameter max_connections=20 failed validation, defaulting to 100
2024-10-27 21:21:25,003 INFO: Changed effective_io_concurrency from 1 to 20
2024-10-27 21:21:25,004 INFO: Changed shared_buffers from 16384 to 51Mi (restart might be required)
2024-10-27 21:21:25,004 INFO: Changed wal_buffers from 512 to 1Mi (restart might be required)
2024-10-27 21:21:27,308 WARNING: Removing integer parameter=shared_buffers from the config due to the invalid value=51Mi
2024-10-27 21:21:28,104 WARNING: Removing integer parameter=wal_buffers from the config due to the invalid value=1Mi
mishraomp commented 3 weeks ago

need to look into this,

2024-10-27 21:21:24,948 WARNING: postgresql parameter max_connections=20 failed validation, defaulting to 100
2024-10-27 21:21:25,003 INFO: Changed effective_io_concurrency from 1 to 20
2024-10-27 21:21:25,004 INFO: Changed shared_buffers from 16384 to 51Mi (restart might be required)
2024-10-27 21:21:25,004 INFO: Changed wal_buffers from 512 to 1Mi (restart might be required)
2024-10-27 21:21:27,308 WARNING: Removing integer parameter=shared_buffers from the config due to the invalid value=51Mi
2024-10-27 21:21:28,104 WARNING: Removing integer parameter=wal_buffers from the config due to the invalid value=1Mi

This is now fixed