--- title: Autoscaling in Action: Postgres Load Testing with pgbench description: A hands-on walkthrough of Neon's Postgres autoscaling feature using pgbench for load testing. The test simulates 30 concurrent clients running a... canonical: https://daily.dev/posts/autoscaling-in-action-postgres-load-testing-with-pgbench-rrsrxzwcf twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Autoscaling in Action: Postgres Load Testing with pgbench | daily.dev og:description: A hands-on walkthrough of Neon's Postgres autoscaling feature using pgbench for load testing. The test simulates 30 concurrent clients running a... og:url: https://daily.dev/posts/autoscaling-in-action-postgres-load-testing-with-pgbench-rrsrxzwcf og:image: https://api.daily.dev/og/posts/RRsrXZwcF.png og:image:alt: Autoscaling in Action: Postgres Load Testing with pgbench og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Autoscaling in Action: Postgres Load Testing with pgbench **[Neon](https://daily.dev/sources/neontech)** · 6 min read · 0 upvotes · 0 comments ## Summary A hands-on walkthrough of Neon's Postgres autoscaling feature using pgbench for load testing. The test simulates 30 concurrent clients running a computationally expensive SQL query involving logarithms of large factorials, which stresses the database enough to trigger autoscaling. The guide covers setting up the pgbench command, analyzing the query execution plan with EXPLAIN ANALYZE, configuring autoscaling CU ranges (¼ to 7 CUs) in the Neon console, and interpreting the resulting performance metrics including TPS, latency, and resource usage graphs. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [PostgresBench: A Reproducible Benchmark for Postgres Services](https://daily.dev/posts/postgresbench-a-reproducible-benchmark-for-postgres-services-vzebpsymu) · ClickHouse · 1 upvotes · 0 comments - [Scaling PostgreSQL to power 800 million ChatGPT users](https://daily.dev/posts/scaling-postgresql-to-power-800-million-chatgpt-users-3mbfuagbd) · OpenAI · 297 upvotes · 11 comments - [Compute Autoscaling Report](https://daily.dev/posts/compute-autoscaling-report-vsfuupvnx) · Neon · 1 upvotes · 0 comments - [A practical guide to cost optimization with Lakebase Postgres](https://daily.dev/posts/a-practical-guide-to-cost-optimization-with-lakebase-postgres-j082mqjvt) · databricks · 0 upvotes · 0 comments --- Tags: [#postgresql](https://daily.dev/tags/postgresql), [#load-testing](https://daily.dev/tags/load-testing) [View this post on daily.dev](https://daily.dev/posts/autoscaling-in-action-postgres-load-testing-with-pgbench-rrsrxzwcf) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Autoscaling in Action: Postgres Load Testing with pgbench","url":"https://daily.dev/posts/autoscaling-in-action-postgres-load-testing-with-pgbench-rrsrxzwcf","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/autoscaling-in-action-postgres-load-testing-with-pgbench-rrsrxzwcf"},"datePublished":"2026-07-09T06:57:37.505Z","dateModified":"2026-07-09T06:58:57.875Z","description":"A hands-on walkthrough of Neon's Postgres autoscaling feature using pgbench for load testing. The test simulates 30 concurrent clients running a...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/1cbfa6052416e5a81312a87572a5456f?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/1cbfa6052416e5a81312a87572a5456f?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Neon","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Neon","logo":"https://media.daily.dev/image/upload/s--65EDghou--/f_auto/v1724339118/logos/neontech","url":"https://daily.dev/sources/neontech"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/autoscaling-in-action-postgres-load-testing-with-pgbench-rrsrxzwcf","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"postgresql,load-testing","timeRequired":"PT6M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Neon","item":"https://daily.dev/sources/neontech"},{"@type":"ListItem","position":3,"name":"Autoscaling in Action: Postgres Load Testing with pgbench"}]} ```