frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

All code is slop (except mine) [video]

https://www.youtube.com/watch?v=O_zcc6Xl12g
1•jebarker•13s ago•0 comments

Show HN: Brewlet – Patch golden images across Kubernetes without rebuilding apps

https://brewlet.sh/
1•brunoborges•24s ago•0 comments

Disaster recovery efforts temporarily boosted health for some men

https://news.northwestern.edu/stories/2026/10/disaster-recovery-efforts-temporarily-boosted-healt...
1•sieste•4m ago•0 comments

[SPLASH'26] Mojo: Towards One Systems Language for All Hardware [video]

https://www.youtube.com/watch?v=9-97SB5XJh4
1•melodyogonna•5m ago•0 comments

Suitcase does more than one job

https://usefulls.com/
1•channusingh1424•5m ago•1 comments

United Airlines has a widespread system outage

https://apnews.com/article/united-airlines-outage-5a5e5f75bb07f11ffb8750901f0076ff
6•tedd4u•9m ago•1 comments

United Airlines experiencing 'widespread system outage'

https://www.nbcchicago.com/news/local/united-airlines-experiencing-widespread-system-outage/4017556/
3•scapecast•9m ago•0 comments

Marlow – an AI app builder that deploys to your own server

https://marlow.app
3•morzanius•9m ago•0 comments

Xcode now includes skills for performance profiling

https://developer.apple.com/documentation/xcode-release-notes/xcode-27_3-release-notes
1•Austin_Conlon•10m ago•0 comments

A Collage Showing 49 Drill Holes Made by NASA's Curiosity Mars Rover

https://science.nasa.gov/photojournal/a-collage-showing-49-drill-holes-made-by-nasas-curiosity-ma...
1•wawayanda•11m ago•0 comments

How to Break into Security, Ptacek Edition

https://krebsonsecurity.com/2012/06/how-to-break-into-security-ptacek-edition/
12•ronfriedhaber•12m ago•0 comments

US datacenters emit as much CO2 as Denmark

https://www.nature.com/articles/s41893-026-01985-7
2•28304283409234•12m ago•0 comments

United Airlines Widespread System Outage

https://www.cnn.com/2026/11/16/us/united-airlines-outage
14•bearsyankees•16m ago•0 comments

Adding MCP Support to PgDog

https://pgdog.dev/blog/mcp
1•levkk•16m ago•0 comments

Agent remote control in LM Studio Bionic

https://lmstudio.ai/blog/agent-remote-control
4•yags•18m ago•0 comments

Diamane OS: Graphene for the Fairphone

https://diamaneos.de/
1•maelito•19m ago•0 comments

Breach of a 3rd-party JavaScript host impacting high value websites

https://x.com/Scott_Helme/status/2122422157959471456
3•Palmik•20m ago•0 comments

Identity Confirmed [James Bond]

https://twitter.com/007/status/2122343820180275593
1•scapecast•21m ago•1 comments

HolyArrs: One app for your whole media server

https://holyarrs.com/
1•doener•22m ago•0 comments

Microsoft Edge suggests unrelated websites if your site is down

https://twitter.com/Tomas_Zubiri/status/2122450911100604804
4•TZubiri•24m ago•0 comments

FBI has possession of router that the FAA says is behind Friday's ATC meltdown

https://www.cnn.com/2026/11/16/politics/video/the-arena-fbi-possesion-router-faa-atc-meltdown
4•zzzeek•26m ago•1 comments

QuickTime VR Reborn – Babylon 5 Fans

https://www.babylon5fans.com/artifacts/quicktime-vr-reborn/
2•justsomehnguy•27m ago•0 comments

LANDrop Closed Source (2024)

https://github.com/landrop/landrop
1•chonkey_monkey•28m ago•1 comments

Cooked

1•shaikhabdullahw•32m ago•0 comments

No matter how you ask, more Americans are negative than positive about AI

https://ourworldindata.org/no-matter-how-you-ask-more-americans-are-negative-than-positive-about-ai
3•atlasunshrugged•33m ago•0 comments

Carbon Emissions of Biggest US Data Centers Rival Entire Countries, Study Says

https://www.nytimes.com/interactive/2026/11/16/climate/ai-data-center-pollution-carbon-emissions....
2•ytpete•33m ago•0 comments

Coordinating Codex and Claude Across macOS, Linux, and Windows

https://www.provos.org/p/coordinating-ai-agents-across-operating-systems/
1•nielsprovos•33m ago•1 comments

Latest Debian 12 LTS images have a kernel crash

https://www.mail-archive.com/debian-lts@lists.debian.org/msg12577.html
3•trestacos•34m ago•1 comments

Local voice, intelligence closer to you

http://lily.md/device/
1•itsrag•35m ago•0 comments

Beyond Floating Point: Next-Generation Computer Arithmetic

https://web.stanford.edu/class/ee380/Abstracts/170201.html
2•Bluestein•37m ago•0 comments
Open in hackernews

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?