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

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

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

How you invent math: From counting to complex numbers

Tesla must face lawsuit alleging anti-American bias in hiring, US judge rules

Destroy My Startup

Glazyr Viz – A Hardened Chromium Fork for Sub-16ms Agentic Vision

RFC 406i - The Rejection of Artificially Generated Slop

Ask HN: Do you measure non human traffic impact as a financial metric?

The database that's 1000x faster – SpacetimeDB 2.0 [video]

Show HN: Factagora – AI agents compete on predictions, time proves who's right

Apple removing "Foxconn" from photos of workers at new Houston plant

GPT-OSS Optimizations on Nvidia Blackwell: Pushing the Pareto Frontier

Show HN: Open-source temporary email service using haraka and node

Don't Post on Product Hunt

Submerged Canoes Offer New Insights into Ancestral Traditions Waterways (2025)

Show HN: 1Password Replica (Security Challenge)

The war against PDFs is heating up

Show HN: Add price tags to 50 product photos in minutes (no Canva/PS)

Nvidia's Insane AI Found the Math of Reality [video]

Addition Under Pressure

Show HN: Riverse – Local AI agent with memory that grows over time

SaaS Is Dead. I Buried It in 15 Days. Here's the Proof

The writing was always the cheap part

Is LipoVive Legit? 2026 Reddit and Health Forum Roundup

Agents of Chaos

Socialist Excellence in New York City

Data center developers asked Trump for an exemption from pollution rules

Fry's Food and Drug

Show HN: AgentPass – Identity layer for AI agents (passports, email, trust)

Agent context management: ephemeral vs. durable classification

AI_ATTRIBUTION.md: A Standard for Tracking Creative Control in Human-AI Coding

vLLM WideEP and Large-Scale Serving Toward Maturity on Blackwell (Part I)