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

1•LawZiL•1y 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•1y 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•1y 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•1y 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•1y ago

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

American Express launches NFTs in 2026

Kids (With Phones) Are Alright

Show HN: Abralo – Manage several Claude Code agents in one window

Venus Aerospace raises $91M to advance its revolutionary rocket engine design

ArticleOne – a daily tech briefing app

Measuring and improving AI-generated UI design

BrAIn, reactive AI agent nodes on a NATS bus instead of a chat loop

Start with A – Open-source, self-hosted investment research platform (BYOK AI)

OpenAI/YC, Netflix, Michaels and Apollo

A free Claude skill that turns one blog post into 3 ready-to-publish posts

Show HN: RepoFleet – A CLI to manage Git workflows across multiple repositories

LLM-wiki-tags: LLM-readable codebase docs with grep-friendly tags

Anyone here with an "in" with eBay?

Are all evils caused by insufficient knowledge?

Waterfall CAD Playground: Haskell-Powered Programmable CAD in Browser with WASM

German Exit Tax: What to Do Before Your First Funding Round

Digital show and tell: how digital audio signals behave in the real world

Quilt: Run many AI coding agents in one Git checkout

Cayley graph search with Claude Code: what puzzle competitions look like in 2026

Introducing My Apple Franken-Lisa Project · Rhyme

Show HN: Boards.md – A project board that writes itself while you build

Spit – On-device voice dictation for Mac, free and open source

Ask HN: What features do you want in a free online timer?

America's Greatest Hot Dog

Running Kubernetes without C in Rust-based Asterinas kernel

IBM Expands Z17 and LinuxONE 5 Mainframe Lineups with Single Frame and Rackmount

The Lolcow-ification of Politics in the Attention Economy

Razer Certifying Their First Laptop for Linux: Razer Blade 18 RZ09-0582 Review

I RE'd (and reimplemented) the ICSee camera app. The security is atrocious

America Talked Itself into Chinese Open Source AI