How to test load on managed databases?

July 19, 2019 235 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?

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.
Have another answer? Share your knowledge.