frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Crimean Bridge partly collapses as Zelensky hails unprecedented attack

https://www.bbc.com/news/articles/cw772jk4rvmxo
3•onemoresoop•1m ago•0 comments

WhatsApp is rolling out a new cloud backup storage on Android

https://wabetainfo.com/whatsapp-is-rolling-out-a-new-cloud-backup-storage-on-android/
1•thunderbong•2m ago•0 comments

Are We All Going Bots**T Crazy?

https://blog.discourse.org/2026/11/are-we-all-going-bots-t-crazy/
2•joanwestenberg•6m ago•1 comments

List of aviation shootdowns and accidents during the 2026 Iran war

https://en.wikipedia.org/wiki/List_of_aviation_shootdowns_and_accidents_during_the_2026_Iran_war
1•DASD•9m ago•0 comments

Self-Adapting Language Models

https://jyopari.github.io/posts/seal
1•jonbaer•9m ago•0 comments

Google's AI answers reducing search traffic by 40%

https://revscope.co/blog/search-seo-geo-2026/
3•slashdev•12m ago•0 comments

No plans to reinstate CEO Jensen Huang, Nvidia chair tells investors

https://www.cbc.ca/news/business/nvidia-earnings-jensen-huang-9.7425620
4•uladzislau•14m ago•0 comments

iOS 27.3's redesigned Apple Health app requires newer iPhone model

https://9to5mac.com/2026/11/17/ios-27-3s-redesigned-apple-health-app-requires-newer-iphone-model/
2•bochoh•14m ago•0 comments

Waymo pauses US freeway operations of its self-driving cars after California ban

https://www.cnn.com/2026/11/17/us/california-waymo-ban-freeways
1•canucker2016•14m ago•0 comments

Build-a-Pal – Offline robot kids teach by voice and gesture

https://www.indiegogo.com/en/projects/ghassen/build-a-pal
6•xifodl•21m ago•0 comments

Calif discloses Java4Shell flaw in OpenJDK's Base64 decoder

https://runtimewire.com/article/calif-discloses-java4shell-flaw-in-openjdk-s-base64-decoder
1•birdculture•22m ago•0 comments

Dynamic Any-Casting in C++

https://nicbn.com/posts/dynamic_any_cast_cxx/
1•nicbn•22m ago•0 comments

Nvidia earnings beat estimates; attention turns to call

https://www.reuters.com/business/view-nvidia-earnings-beat-estimates-attention-turns-call-2026-11...
2•wslh•24m ago•0 comments

Stripe backer Atomico calls for Europe to own its success stories

https://techcrunch.com/2026/11/17/stripe-backer-atomico-calls-for-europe-to-own-its-success-stories/
1•doener•25m ago•0 comments

The geometry of morphospaces: lessons from the classic Raup shell coiling model [pdf]

https://onlinelibrary.wiley.com/doi/10.1111/brv.12276
1•thunderbong•26m ago•0 comments

Voyager 1's 'light-day' milestone has been a half-century in the making

https://www.scientificamerican.com/article/voyager-1-approaches-a-light-day-milestone/
1•divbzero•26m ago•0 comments

U.N. Starts Uncertain Effort to Regulate Lethal Autonomous Weapons

https://www.nytimes.com/2026/11/16/world/europe/un-killer-robots-autonomous-weapons.html
1•bookofjoe•26m ago•1 comments

Vivaldi Social: Mastodon server hosted in Iceland by the makers of Vivaldi

https://social.vivaldi.net/about
1•doener•27m ago•0 comments

An open letter to OpenAI and Anthropic on cybersecurity access

https://openletter.earth/stop-blocking-defenders-an-open-letter-to-openai-and-anthropic-on-cybers...
4•wslh•29m ago•0 comments

My Dog Ate a Ketchup Packet – What to Do Now – PetToxCheck

https://pettoxcheck.com/dogs/my-dog-ate-ketchup-packet/
1•iris_blackwood•30m ago•1 comments

Show HN: A more readable take on HN

https://hn.orbitalchicken.com
1•y1n0•32m ago•1 comments

Show HN: Dropbox for AI Skill Files

https://www.mdkit.ai
1•tannerjames711•33m ago•0 comments

Show HN: Shard – Distributed AI Inference Across Multiple Computers

https://github.com/avelone123123/shard
2•avelone•34m ago•1 comments

IIHF confirms cyberattack after website goes offline

https://www.cbc.ca/news/world/iihf-website-hacked-russia-9.7424810
1•BiraIgnacio•34m ago•1 comments

Does locking up a student's phone improve test scores? A new study suggests so

https://www.npr.org/2026/11/17/nx-s1-6035684/school-cellphone-ban-learning-loss-yondr-research
5•billybuckwheat•35m ago•1 comments

Performance of a formally-verified C compiler vs. GCC -O2

https://ut-infraai.github.io/2026/11/13/trying-to-make-compcert-as-fast-as-gcc-o2/
1•matt_d•37m ago•0 comments

OpenAI Shipped Astra 6.2 despite known behavioral regressions!

https://twitter.com/AdamHoltererer/status/2122830568501256563
3•bigwheels•38m ago•0 comments

AI Helps Find Major Security Bug in Java

https://www.nytimes.com/2026/11/17/us/politics/ai-security-bug-java.html
1•donohoe•39m ago•0 comments

Large, Empty Deflate Streams

https://yossarian.net/til/post/large-empty-deflate-streams/
1•woodruffw•41m ago•0 comments

Hutter Prize

https://en.wikipedia.org/wiki/Hutter_Prize
1•jonbaer•41m 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?