Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

optimise postgres config #4

Closed
julie-sullivan opened this issue Jul 15, 2019 · 1 comment
Closed

optimise postgres config #4

julie-sullivan opened this issue Jul 15, 2019 · 1 comment

Comments

@julie-sullivan
Copy link
Member

intermine_postgres   | LOG:  checkpoints are occurring too frequently (4 seconds apart)
intermine_postgres   | HINT:  Consider increasing the configuration parameter "checkpoint_segments".

https://intermine.readthedocs.io/en/latest/system-requirements/software/postgres/postgres/#postgresql-parameters

We recommend this setting:

checkpoint_segments | 128

Is there an easy way to update the config of the postgres in the docker container?

@leoank
Copy link
Member

leoank commented Jul 16, 2019

you can easily do this! look for postgresql.conf file inside postgres directory. Modify it according to your needs. Only caveat is that you cannot use prebuilt images. You have to use Option 1 in the quickstart section to build images locally.

@leoank leoank closed this as completed Dec 6, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants