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?

Diving into the Bun Rust rewrite [video]

Mapping AI-enabled cyber threats: Insights from the LLM ATT&CK Navigator

You Are an 'Avatar in a VR Game,' Scientist Claims

AI and the Psychology of Cognitive Surrender

Raytracing Geometries in 3D Rendering

Why GPTHuman AI Is the Best AI Humanizer?

Ask HN: Playlist – Hit the Road

Scientists Create Tiny Chip That Uses Light Instead of Electricity

Zamicus+|+Dang.ai

The AI Question That No AI Person Asks [video]

PlayStation Architecture

Open Source Aviation Maps

Illegal live TV streaming in Germany grows 33% since 2022, to €2.4B loss in 2025

Google must let publishers opt out of AI Search features, rules UK

Exploring geospatial link between soils and national intelligence quotient

What we learned mapping a year's worth of AI-enabled cyber threats

JL Collins goes global, and why that feels familiar

You won't be talking to AI in natural language for too long

Oils – Reviewing Our NLnet Grants After 4 Years

Mathematicians issue warning as AI rapidly gains ground

Redis 8.8: New array data structure, rate limiter, performance improvements

The empty field that wasn't

Japan declines to join movement to ban youth from social media

A runtime verification pipeline that reduced hallucinations from 67% to 11%

Gödel and Turing outlined the limits of AI

Build 2026: WSL improvements and the new Containers CLI and APIs

Embedding Tailwind Design System in Obsidian

Show HN: Vivix – See inside JavaScript as it executes (open source)

UK lawmakers call on government to ditch Palantir NHS contract

Google Is Quietly Buying Code from Play Store Developers to Train AI