frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Make your LLM accept only signed prompts

https://discounttimu.substack.com/p/make-your-llm-only-accept-signed
1•guardiangod•35s ago•0 comments

Live ranking CVEs based on vibes, not CVSS

https://cves.io/
1•patrikgrobs•1m ago•0 comments

Show HN: CofreAdmin Wallet – Self-Custodial Web3 Personal Finance

https://github.com/cofreadminwallet/app
1•erissonmarques•1m ago•0 comments

Can Solar Murals Make Clean Energy More Attractive?

https://triplepundit.com/2026/solar-murals-artwork-renewable-energy-aesthetics/
1•rdmuser•1m ago•0 comments

Laptop/Phone can hear you without a mic. Proof

https://twitter.com/whyvanamali/status/2122276417031585879
1•mrkn1•3m ago•0 comments

We Logged 183,291 MCP and A2A Requests. Only 2.2% Were Task-Shaped

https://wagerx.io/news/agentic-web-observatory-november-17-2026
1•wagerx•3m ago•0 comments

Framefields v3

https://framefields.dev/v3/
1•oknaslnkn•3m ago•0 comments

California sues OpenAI over safety concerns after rogue agent hacking

https://www.theguardian.com/technology/2026/nov/16/california-openai-rogue-agent-hacking-lawsuit
1•richardbarosky•5m ago•0 comments

Modern LLMs hate Python the most

https://blog.jetbrains.com/ai/2026/11/ai-models-hate-python-and-love-php-we-asked-12-of-them-1-20...
1•neuraldenis•7m ago•0 comments

Amazon Eyes 20k Pairs of Smart Glasses for Delivery Drivers by 2027

https://wwd.com/sourcing-journal/logistics/amazon-smart-glasses-delivery-riders-privacy-1239404883/
1•bookofjoe•8m ago•1 comments

WigglyPaint – Free Animated Drawing Tool

https://wigglypaint.com
1•RomellHenry•9m ago•0 comments

Beyond Ballmer Peak: LLM and ethanol assisted coding [pdf]

https://github.com/meawoppl/katz-peak/blob/main/katz_peak.pdf
1•alexmolas•11m ago•0 comments

The polar vortex just set a new record

https://www.bbc.com/weather/articles/cwdd8dl7830go
1•amelius•13m ago•0 comments

Did an AI or a human write that paper? New detector decides by examining ideas

https://www.science.org/content/article/did-ai-or-human-write-paper-new-detector-decides-examinin...
1•pluc•14m ago•0 comments

Show HN: OpenMarkdown Editor – edits Markdown source, not a document tree

https://github.com/OpenMarkdown-dev/OpenMarkdown-editor
2•XUEYANZ•14m ago•0 comments

WSO2 is now Choreo Labs

https://choreolabs.com/
3•sathindu•15m ago•1 comments

Show HN: Pipbreak – find what a Python dependency update breaks before merging

https://github.com/youssef-elaasri/pipbreak
1•fisher_sun•15m ago•0 comments

How Do You Evaluate Candidates When Hiring for a Small Startup?

https://lobox.com/articles/98
1•LoboxPlatform•16m ago•0 comments

Trump's accounts traded $97.5M in Nvidia as Huang gained access

https://www.cnbc.com/2026/11/16/trump-nvidia-stock-trades-jensen-huang.html
3•Betelbuddy•16m ago•1 comments

Glue work is still harmful in the age of AI

https://www.seangoedecke.com/glue-work-is-still-harmful-in-the-age-of-ai/
1•saikatsg•17m ago•0 comments

Show HN: Crow – High density control plane for Linux servers

https://github.com/errorware/crow
1•errorware•17m ago•0 comments

What if Elon Musk got caught having affairs with a spy and a subordinate?

2•DivingForGold•17m ago•0 comments

Put-Downs, Parties and a 'Royal Family':The Culture Inside Jensen Huang's Nvidia

https://www.wsj.com/business/put-downs-parties-and-a-royal-family-the-culture-inside-jensen-huang...
1•Betelbuddy•19m ago•1 comments

A field of physics, audited by machine

https://science.caseyhandmer.com/physics/
1•bilsbie•21m ago•0 comments

Limits Coming to Apple Intelligence and Siri AI for Those Without iCloud+

https://512pixels.net/2026/11/limits-coming-to-apple-intelligence-and-siri-ai-for-those-without-i...
1•colinprince•21m ago•0 comments

Nov. 17 Update on Japan Cyberattacks: 1,641 Incidents

https://www.mkultraman.com/japan-cybersecurity-tracker/
2•frxx•23m ago•0 comments

LoongPerf: LoongArch instruction-level performance data

https://jia.je/LoongPerf/
1•csmantle•23m ago•0 comments

The Source Code of Law: Agents rewrite and red-team 30k articles of French law

https://thesourcecodeoflaw.com/en/
2•nnx•23m ago•0 comments

When will humans fly on Starship?

https://arstechnica.com/space/2026/11/when-will-humans-actually-fly-on-starship/
2•goatley•26m ago•2 comments

Show HN: An MCP server for searching 71 real, sourced AI agent deployments

https://agentsinthewild.co/mcp-server
1•agentsinthewild•27m 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?