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?

Show HN: Sigilla – Spaced repetition for browser tabs (stop hoarding)

Big Tech Companies Prepare to Skirt Trump's $100k H-1B Fee

Show HN: Windy – Place wind turbines on a map, see residential impact

Show HN: Web Scraping Sandbox Website

My OpenClaw Desperately Needs a DevOps Agent

Streeting/Mandelson WhatsApp

DeepComputing Announced Early Access for the DC-ROMA RISC-V Mainboard III

Programmers should hedge against AI

Cursor-agent-team: Single-conversation, multi-role AI collaboration framework

I Built Free Legal Skills for AI Agents

Show HN: The Hidden Bit - A Game Based proof architecture for P vs. NP

LLVM: Concerns about low-quality PRs being merged into main

GroMach

Show HN: AI-Templates for Obsidian Templater

Why Jony Ive put buttons in the electric Ferrari

Show HN: Tigement – private timeline planner that recalculates when tasks change

Allumeria receives false DMCA from Microsoft over infringement of Minecraft IP

Ask HN: How do you trace your own mental loops?

Show HN: We let GPT OSS 120B write and run Python and ARC AGI 2 jumped 4x

Show HN: IntentCode

Deferred Member Initialization in C++

New open source model achieves same score as GPT 5.2 High on AIME2026 I

US Gov borrowed $43.5B per week in Q1 2026

FAA Halts All Flights at El Paso Airport for 10 Days

How to Be Less Wrong in a Polycrisis

Web Tiles: composable docs and apps safe in any context

How to level up the Fediverse [video]

Using YouTube as Cloud Storage

Human Line Project – Protecting emotional well-being in the age of AI

A curated list of excellent books to learn PostgreSQL