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?

Writing Liveness

AI agent called every pub in Ireland to index the cost of a Guinness

Show HN: Building compiler from scratch without the help of LLMs [video]

Global freedom declined for the 20th consecutive year in 2025

Show HN: Mac-computer-use, an open-source clone of Codex Computer Use

Colombia will euthanize Pablo Escobar's invasive 'cocaine hippos'

Fatal Accident Occurs in Nurburgring Langstrecken-Serie (NLS)

Bounce Off the Atmosphere at Reentry? (2016)

F-14 Central Air Data Computer

Verkada Deceives School That Verkada Cameras Would Not "Brick"

CTX is a cognitive memory layer for AI systems

Show HN: FluxTest for testing network performance of self-hosted infrastructure

NASA selects Falcon Heavy to launch ESA Mars rover mission despite budget threat

Show HN: Hyprmark – Markdown viewer for the Hyprland ecosystem

A resume builder for pets, for those who need to prove their animal isn't feral

The Khan Ted Institute

Ask HN: API Request for Feedback OK in Show HN?

Opentargets-py – Python SDK for the Open Targets drug discovery database

Old Computers Sucked

Is ChatGPT's web front end being intentionally degraded?

Rise against the Machines: The Luddites [video]

At the HumanX conference, everyone was talking about Claude

The Cost of Cheap Clone Boards: Streaming Video on an STM32H750

Robotaxi is now rolling out in Dallas and Houston

AI chip startup Cerebras files for IPO

Show HN: I built a CLI to fake Git commits

No more bill shocks budget alerts comes to Cloudflare

PostgreSQL Just Got Its Biggest Upgrade That Will Change DB Performance in 2026

That 90s Chat Program You Don't Remember

Deutsche Telekom has a bad DKIM key