Autoscaling in Action: Postgres Load Testing with pgbench

In this article, the author demonstrates Neon autoscaling in action by running a load test using Postgres' popular benchmarking tool, pgbench. The test simulates 30 clients running a heavy query with high computational overhead to signal the autoscaler-agent to allocate more resources to the VM. The effectiveness and efficiency of autoscaling are often assumed without thorough testing, so this demonstration showcases its utility in real-time adjustment of resources allocated to a database based on its current workload. The author also explains how to enable autoscaling by defining the minimum and maximum compute units (CU) for a Postgres instance.