Company
Date Published
Author
Raouf Chebri
Word count
1000
Language
English
Hacker News points
None

Summary

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.