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?

AI Has Taken over Open Source

How to Teach AI the "Taste"

Code-mapper: Free CLI tool to reduce LLM token usage on any codebases

The Mystical Meaning of 369 and Its Link to Nikola Tesla

Important Update: Transitioning Bitnami Offerings on AWS

Ask HN: Have you seen Star Wars The Mandalorian and Grogu,nice CGI, no storyline

China Launches Manned Spaceship on Mission Orbit Tiangong Space Station [video]

D. Trump Jr. and Eric Trump Running Felony Fraud Scheme Prosecutable in New York

Geopolitical Technicals

Global AI Diffusion: Q1 2026 Trends and Insights [pdf]

Ravens Don't Follow Wolves, They Predict Their Patterns

NymphCast – Libre Multicast DNS Media Streaming to Any Device

Freediving, Embodiment and Humanity – Joanna Rutkowska

How Telescope Rancher Became the Hot New Job in Texas

Ghost CMS SQL injection flaw exploited in large-scale ClickFix campaign

HN: Silau – AI detects employee burnout"

Army runs secret wargames under central London

The Morale of Tech Workers Is Plunging as Layoffs Mount

Cache – Meal plans from your local store's weekly sales

A Unified Theory of Alignment in Layered Systems

The quiet grief of adult friendship

Show HN: SaveNeighbor – food delivery through your own personal network

Canonical to shut Ubuntu Pastebin after 18 years of service

I built an online leather goods store focused on making gift buying less painful

Tfdraw.dev – turn Terraform plan JSON into an editable architecture diagram

Show HN: The first (free) podcast ad blocker

Fatherhood Dramatically Rewires Your Brain

How AI Talks People Out of Conspiracy Theories–and What We Can Learn from That

Honopinion

We Built Secure, Scalable Agent Sandbox Infrastructure