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?

Ask HN: What is your (AI) dev tech stack / workflow? (June 2026)

The European Social Stack

YouVersion Platform – Developer Platform for Bible-Based Experiences

New IronWorm malware hits 36 packages in NPM supply-chain attack

Good Careers at Bad Companies

Gene flow from wild apples and selection shaped the domesticated Apple genome

Watch crypto protocols exploited in real time

Something is jamming GPS over Europe

PostgreSQL and the OOM Killer: Why We Use Strict Memory Overcommit

Antares SMR goes zero power critical

Apple's Plan for AI Dominance Rests on Fixing Its Much-Maligned Chatbot

The British university is dying, and it seems that almost nobody cares

Introduce Loon: lake-native storage engine behind Milvus 3.0 for AI data

New method turns ocean water into drinking water, without waste

We reduced tests from hours to just minutes using automatic GlassFish pools

Astronauts on ISS told to shelter as repairs under way to fix air leaks

Simulism · on Env

I customized a MacBook Neo with colorful spare parts

Building a zero-cloud, local semantic indexing engine for AI agents

VibeOS – Hallucinated Operating System [video]

Valve says it's ready to launch the Steam Machine this summer

Ethical and Moral Considerations in Proprietary Software Usage

AI-indecision is a recursive trap. Don't get stuck

Show HN: One-Shot Program Generation Through Direct Memory Diffusion

Show HN: 0llm is a small app to help you spend time away from AI

Playing with Vision Embeddings

Gain of Function, Loss of Control

LLM agent performance is a distributed systems problem

Israel's tech paradox:$1.1B raised in a week as layoffs sweep industry

New York just passed a one-year temporary ban on data centers