Ask HN: How can I load test PostgreSQL but avoid changing actual data?

1•LawZiL•6mo ago

I'm running a load test on my Node.js application and want to simulate realistic write-heavy scenarios to stress test the system — especially the PostgreSQL database.

There's a part of the code that performs UPDATE queries, but during load testing, I don't want these updates to actually change the state of the database. However, I still want the database to experience the full impact of the update — query planning, locking, I/O, WAL writes, etc. — so I can measure how it affects performance under peak load.

Is there a best-practice approach to achieve this?

So far, the most viable option I’ve found is to wrap the UPDATE queries in a transaction and then roll it back — that way, the queries still execute, but the state doesn’t change. Is this the right way to go? Does rollback introduce any performance overhead that would skew my results? Are there better or more realistic alternatives that simulate the full write path without persisting changes?

Thanks in advance!

Comments

sargstuff•6mo ago

pgbench[2] / pgreplay-go[0] / python locust[1]

very old school approach:

Misuse sql VIEW[3][4] to generate a temporary parallel table setup. Testing database separate from production database would be 'better', IMHO.

-----

[0] pgreplay-go : https://github.com/gocardless/pgreplay-go

[1] python locust : https://miguel-codes.medium.com/unconventional-load-testing-...

[2] pgbench load testing :

   a) https://medium.com/@c.ucanefe/pgbench-load-test-166bdfb5c75a

   b) https://neon.tech/blog/autoscaling-in-action-postgres-load-testing-with-pgbench

   c) https://hackernoon.com/how-to-create-and-load-test-data-in-postgresql-i41e353m

----------------------------

[3] : a) https://hashrocket.com/blog/posts/materialized-view-strategi...

      b) https://tech.jonathangardner.net/wiki/PostgreSQL/Materialized_Views

      c) https://stackoverflow.com/questions/77603705/what-is-the-use-of-materialized-view-in-postgresql

[4] : https://en.wikipedia.org/wiki/View_(SQL)

LawZiL•6mo ago

but again, how can i perform the query, but not actually change the state, i really need the state to keep untouched, but be able to perform the query itself.

MatthiasPortzel•6mo ago

> Does rollback introduce any performance overhead that would skew my results?

I would expect it to be the other way around—since the transactions are rolled back and not committed, they would have significantly less performance impact. But I’m working from an academic model of the database.

apothegm•6mo ago

Load test against a clone instead of a DB whose contents you care about?

Coding Agents Are Outliers

Negotiation Skills Training for Adolescent Girls in Zambia

Ya no vendo informacion fiscal

I Don't Want to Be a Ping-Pong Ball Anymore

InovaTrust – Help a Brother Out

We Built FridayAI: Founders Need Their Time Back

Show HN: My small tool blew up unexpectedly

Tremulous an open source quake3 based RTS/FPS game ported to the web

How to Guess a Gradient

Built a LangChain App for a Startup, Here's What Mattered

Show HN: Monetizing an API using private keys

A welcome pit stop: the US college using parking lots to help unhoused students

Show HN: DocNode, A TypeScript OT library for local-first apps

FDA to probe whether adult deaths linked to coronavirus vaccine

Whatever Happened to NFTs?

Show HN: We built a no-logs cloud provider where users are just a 32-char token

Binary Range Expressions

The Politics of Superintelligence

Running boosts dopamine,coordination in aging mice, poss relevance to Parkinsons

America Has Become a Digital Narco-State - Paul Krugman

A Simple Proof of the Riemann Hypothesis

Don't Trust, Verify: Building End-to-End Confidential Applications on GCP

Americans are holding onto devices longer than ever and it's costing the economy

Operating System AI Agent versus Foundation Model AI Agent

10 Years of Let's Encrypt Certificates

Kent L Beck: You're Ignoring Optionality and Paying for It [audio]

Playing Santa Does Strange Things to a Man

NeurIPS 2025 Top Paper Breakdown: LLMs Are Collapsing into Artificial Hivemind

RAM Is Ruining Everything

No more tokens Locking down NPM Publish Workflows