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

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

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

Securing AI Agents and MCP interactions at the network layer with Tailscale

LogMeIn – Instant Login Links, No Password Sharing

Corporate America Is Minting Money–and Not Just in Tech and Finance

Ketamine, psychedelics, GHB: is the US falling out of love with cocaine?

Chatting with myself about AI

Ask HN: Is anyone building/selling VT220-type terminals?

Taiwan's stock market surpasses the UK's, thanks to AI

TopCarPlay Wireless CarPlay

China blocks Meta's acquisition of AI startup Manus

LFM2.5-VL-450M: Structured Visual Intelligence, Edge to Cloud

Choo Choo Words: Spell words to make train tracks, stop the train from crashing

Show HN: Webhook API – inbound email –> webhook

Show HN: A terminal spreadsheet editor with Vim keybindings

Carbon nanotube wiring gets closer to competing with copper

Gatekeeping: A Partial History of Cold Fusion

Show HN: I built a reference site for the recurring hard problems in software

Show HN: Slerp.audio – VDJ with WebGL2 and real-time DSP

Show HN: TermToMD past in choppy terminal output get clean Markdown

Gallium oxide electronics withstand extreme cold

In which Lisp generates music

Entire NSF science advisory board fired by Trump administration

Isaac-Flath/Agentkb

Kinetic Displays

OpenVPN 2.7 security audit: 18 findings, one critical bug

"48 agents thinking in one window"

Carl Sagan on Military Spending and Climate Change [video]

Electricity Provider Comparison Tool

PAuth – Precise Task-Scoped Authorization for Agents

Qdrant Cluster Dashboard – Chrome Extension

Robinhood mass phishing incident – April 2026