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

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

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

Winners of the 2026 Kokuyo Design Awards

Musk asks SpaceX IPO banks to buy Grok AI subscriptions, NYT reports

Crafting Engineering Strategy: How Thoughtful Decisions Solve Complex Problems

Media scraper Gallery-dl is moving to Codeberg after receiving a DMCA notice

A "Unix-style tool" crashes with the –version flag

An open-source 240-antenna array to bounce signals off the Moon

Show HN: Multi-agent coding assistant with a sandboxed Rust execution engine

A local search engine for AI Agents

Better ClassPass Food Searching in Manhattan

Show HN: Open-source ontology – SEC fund filings

Show HN: md-redline - inline review comments for markdown, readable by AI agents

Your File System Is Already A Graph Database

The 1987 Game "The Last Ninja" was 40 kilobytes

Is AI the New Fracking?

More Americans Are Breaking into the Upper Middle Class

Show HN: Not a CLI, Toward a New Agent-Computer Interaction Model

Show HN: Magma Memory Claude Browser cloaking tool

The Spark – A sophisticated scrolling experience

Does coding with LLMs mean more microservices?

Kicking Off the ATP Working Group at the IETF

Best Paper Awards in Computer Science over the past 30 years

Case study: recovery of a corrupted 12 TB multi-device pool

Which is when I got to see what it looks like

Before smart Siri, I made Agentic Quake Terminal

Show HN: I made a free daily puzzle game

Moody – Give your MacBook a personality that reacts to hardware events

Show HN: LLM Wiki – Open-Source Implementation of Karpathy's LLM Wiki

Show HN: The easiest way to generate AI stickers then get them in the mail

New Copilot for Windows 11 includes a full Microsoft Edge package, uses more RAM

Association between Covid-19 vaccination and sudden death in younger individuals