Question

How to test load on managed databases?

Posted July 19, 2019 516 views
DigitalOcean

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.

×
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!

https://www.digitalocean.com/community/tutorials/managed-databases-connection-pools-and-postgresql-benchmarking-using-pgbench

Thanks!

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.
Submit an Answer