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?

Minecraft Java Edition 26.2 Snapshot 1: Initial Vulkan Support

Molecular editing tool relocates alcohol groups

Tabsdata vs. Airbyte: Up to 86x faster

Nix: Privilege escalation via symlink following during FOD output registration

The Musician's Guide to Leaving Windows [video]

When the compiler lies: breaking memory safety in safe Go

Anthropic holds Mythos model due to hacking risks

Fifth Element Star Milla Jovovich Reveals AI Memory Tool MemPalace

BYD's luxury EV with 5-min fast charging and 500 miles range is headed overseas

SQLite in the browser with WASM and real-time ER diagram

WSLg: Windows Subsystem for Linux GUI

Show HN: I made a Git wrapper with undo button

Anthropic latest AI model too powerful for public release and broke containment

GLM-5.1 matches Opus 4.6 in agentic performance, at ~1/3 actual cost

GEON: Structure-first decoding for language models

Author's preface to the book: "PGP Source Code and Internals" (1995)

I Just Wanted a Button. It Escalated [video]

Midlife Sleep Irregularity Linked to Higher Risk of Major Cardiac Events

Ask HN: Any advice on 'hacking' Ford lightning?

Trump agrees to suspend 'bombing and attack of Iran' for 2 weeks

'Definitely a Sham': As Tariffs Climb, Fraud Proliferates

Deere and Co agrees to pay $99M to settle 'right to repair' lawsuit

Own your AI. Optimized down to the kernel

Breakthrough Alzheimer's Drug Rewires the Brain Instead of Just Clearing Plaques

Show HN: Clify – generate a CLI from any API docs, use it as agent tooling

I made a Claude skill that refuses to write code for you

Astronautas da Artemis II levaram mensagem espiritual à órbita lunar

Ex-Meta worker investigated for downloading 30k private Facebook photos

MCP has 97M installs. It's also an open door into every dev environment

New York Times Got Played by a Telehealth Scam and Called It the Future of AI