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?

Age of Invention: Tudor Trade War

I have an idea I wanted to share with you all

Show HN: Flash.nvim, but for Tmux Sort Of

Newly discovered coffee compounds beat diabetes drug in lab tests

AI, Japanese chimpanzee who counted and painted dies at 49

Humans Have Accidentally Created a Barrier Around the Earth

NotebookLM Watermark Remover – Remove Watermark from PDF

Video Message from Federal Reserve Chair Jerome H. Powell

The Simpler Things in Life [video]

Linux Market Share Remains Above 3% for 3 Months in a Row – January 2026 Report

One Thousand Words

iFixit The Worst Devices of CES 2026 [video]

Anthropic brings Claude to healthcare with HIPAA-ready Enterprise tools

Select text and search with your preferred engine or AI, all in one click

Jerome Powell's being threatened [video]

Why is it so hard to do the thing I claim to want?

A field guide to sandboxes for AI

Scope: Hierarchical planner beats LLMs, 55x faster, 1/160k size

Revit AI Render: Faster AI Rendering for Architects

You Need to Yearn More

Show HN: Self-hosted micro-learning platform with Full featured (Django/SolidJS)

What Accenture's acquisition of Faculty means for AI enablement services

Ask HN: What business processes still waste time every week?

Show HN: AIIM – platform to build AI agents with psychological depth

AI industry insiders launch site to poison the data that feeds them

AGI Next Frontier Summit in Beijing (260110)

Writing a Program in Par [video]

Show HN: GAM7 Companion – macOS app that automates Google Workspace admin

Show HN: I built a keyword tool that finds terms traditional tools miss

UpgradeLink – An Open-Source All-in-One Cross-Platform App Upgrade System