# Autoscaling in Action: Postgres Load Testing with pgbench

DevFeed: [Autoscaling in Action: Postgres Load Testing with pgbench](<https://devfeed.tech/articles/autoscaling-in-action-postgres-load-testing-with-pgbench-5006.md>)

Original publisher: [Read original article](<https://neon.com/blog/autoscaling-in-action-postgres-load-testing-with-pgbench>)

Author: Raouf Chebri

Published: 2024-02-23T09:25:39Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [autoscaling](<https://devfeed.tech/topics/autoscaling.md>), [benchmarking](<https://devfeed.tech/topics/benchmarking.md>), [Database](<https://devfeed.tech/topics/database.md>), [Command-line interface](<https://devfeed.tech/topics/cli.md>), [client](<https://devfeed.tech/topics/client.md>), [Server](<https://devfeed.tech/topics/server.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>)

Tags: [article](<https://devfeed.tech/tags/article.md>), [autoscaling](<https://devfeed.tech/tags/autoscaling.md>), [benchmarking](<https://devfeed.tech/tags/benchmarking.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [command-line](<https://devfeed.tech/tags/command-line.md>), [community](<https://devfeed.tech/tags/community.md>), [concurrent](<https://devfeed.tech/tags/concurrent.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [efficiency](<https://devfeed.tech/tags/efficiency.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [production](<https://devfeed.tech/tags/production.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [scale](<https://devfeed.tech/tags/scale.md>), [server](<https://devfeed.tech/tags/server.md>), [testing](<https://devfeed.tech/tags/testing.md>), [time](<https://devfeed.tech/tags/time.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

## AI overview

This article demonstrates Neon autoscaling by load-testing a Postgres database with pgbench. The test uses 30 clients and a computationally intensive query to show how workload can trigger additional VM resources. It also explains pgbench parameters for running a 120-second benchmark and reporting progress.

## Source excerpt

In this article, I'll show Neon autoscaling in action by running a load test using one of Postgres' most popular benchmarking tool, pgbench. The test simulates 30 clients running a heavy query. While 30 doesn't sound like a lot, the query involves a mathematical function with hig...