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

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

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

What Machines Want

Trust them, don't trust it

The Indian Work Culture – Masochistic, Poor, Intense and Fragile

CooperBench: Benchmarking AI Agents' Cooperation

Google pays $68M to settle claims its voice assistant spied on users

Strategic Violence as Forceful Epistemic Renegotiation

Self-Replicating LLM Artifacts and Accidental Supply-Chain Contamination

Midair collision near Washington DC followed years of ignored warnings

Show HN: I built a tool that turns browser clicks into GitHub PRs for CSS fixes

Show HN: Local Agent – Local AI agent (Nova) with evolving memory

Ask HN: Reviewable Map Like Yelp

Codebase Is the Prompt

Software Interruptions Became Normalized

The "So What?" Problem: Why Smart Health Data Hits a Dead End (and How Fixes It)

A Time Tracking App Wanted $28,800 So I Replaced It with a Homelab

Moltbot (previously Clawdbot) – The AI that actually does things

MacEcho

Ubiquity WiFi is directly supporting the Russian Military in their war effort

I gave Ralph Wiggum a "survival instinct" and it tried to escape its container

Show HN: ModifyWithAI v2 – Add chat-based agents to your app

Show HN: Next.js and Spring Boot SaaS Starter (OAuth, Stripe, Admin)

Uber launches an 'AV Labs' division to gather driving data for robotaxi partners

Tim Cook Says He Is 'Heartbroken' by the Events in Minn, Calls for De-Escalation

The Algorithmic Tax: Rethinking ROAS as a Profit-Extraction Mechanism

Optimizing my note-taking to study 585 medical conditions this year

Is this the longest Chess game? (2020) [pdf]

Native Instruments GmbH is in preliminary insolvency

SEC Form 8-K – EventBrite acquired by BendingSpoons [Dec 2025]

Ask HN: Why all the sudden people are writing browsers with AI?

They Covered the Sky, and Then... (2014)