How to test load on managed databases?

Posted July 19, 2019 2.3k views

I’m trying to see how to calculate a maximum number of connections to read on a basic plan for managed databases. Do you have any information about that or any tool to recommend for doing such a test?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

Hey there, Bruno!

Here is an article in which we walk through connection pools and benchmarking Managed Databases for Postgres using pg_bench. I think this will help!


by Hanif Jetha
In this tutorial we'll use `pgbench`, PostgreSQL's built-in benchmarking tool, to run load tests on a DigitalOcean Managed PostgreSQL Database. We'll dive in to connection pools, describe how they work, and show how to create one using the Cloud Control panel. Finally, using results from the `pgbench` tests, we'll demonstrate how using a connection pool can be an inexpensive method of increasing database throughput.