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?

Is Musk the richest American ever now? No, except as a consumer

CoreAI_HTCE

From AGI to ASI

Pilot and 11 skydiving passengers killed in Missouri plane crash

How to Build a Phyle

What does high effort mean when AI has made everything low effort?

I built a free tool that tells you if an LLM will run on your GPU

Leave It to Beaver: Everything is bigger at Buc-ee's

Virology Research Is Not a Crime

Abandoned and Little-Known Airfields

2026 Global Peace Index [pdf]

KPMG report on AI found riddled with AI hallucinations

Compute 'S Atari ST Reference Books – By Paul Lefebvre

Ask HN: I am a junior CS and math major. I have no hope for SWE or math. Advice?

Seer – an Ollama workspace where two models build and review code

Show HN: I hate typing continue once my CC quota resets

Frona v2026.6.0 – self-hosted personal AI assistant

Itty Bitty Mosquito Committee

Chaosnet

Road trip – Drop Junk Cars – Cows aren't hurt

Einstein's Mirror

Yserver: A modern X11 server written in Rust

Mathematical and Algorithmic Specification of an Advanced Cognitive Architecture

Ask HN: Which Free Software or Open Source Project Needs Help?

Why isn't the external link symbol in Unicode? (2018)

One Moving Part: The Forest Service Ax Manual

Android's head of security slams Google's door

Losing on Purpose: The Economics of NBA Tanking

The Telematico NMS3000 – Celso Martinho

Karpathy on Why 'Edutainment' Isn't Real Learning (Seek the Sweat) (2024)