Skip to content
This repository has been archived by the owner on Aug 31, 2021. It is now read-only.

Optimize DB performance at the connection pool level #195

Open
2 of 4 tasks
i-norden opened this issue May 6, 2020 · 0 comments
Open
2 of 4 tasks

Optimize DB performance at the connection pool level #195

i-norden opened this issue May 6, 2020 · 0 comments

Comments

@i-norden
Copy link
Collaborator

i-norden commented May 6, 2020

Test the following, incorporate improvements:

  • Increase MaxIdleConns

  • Separate connection pools for backfill, sync, and serve processes

  • Increase max_connections in postgresql.conf

  • Prioritize sync db connections over backfill connections (sql/sqlx.DB does not provide this level of control natively, this is much more involved than any of the above)

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant