High-level recommendations for database tuning

Open Beginner friendly
#2,129 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
2/5
Estimated time
1-3 hours
Newbie friendliness
67/100
Issue type
Documentation
Clarity
Mostly clear
Activity status
Active
Tech stack
postgresql
Domain
documentation

Research direction

Start by reading the linked forum discussion about tuning the bundled Postgres from environment variables and check the repository’s existing database deployment documentation for where these recommendations belong. Document when to use a separately managed database, explain the conservative defaults and tuning considerations, and describe how PG_* variables can be set in .env; done when the guidance is added in the relevant documentation section.

Written by the indexing model from the issue text.

Description

  • Recommend separately-managed db service for high-load and/or high-availability deployments
  • Postgres default config is conservative, should consider tuning for load and resources available
  • PG_* config vars can be set in .env

https://forum.getodk.org/t/tune-the-bundled-postgres-from-env/58789

Dominant language
Python
Stars
58
Forks
161
Avg merge
20h 51m
Merged PRs (30d)
2

Getting set up

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from getodk/docs

All issues in getodk/docs

Similar issues

More Python issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.