frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Benchmarking Postgres 17 vs. 18

https://planetscale.com/blog/benchmarking-postgres-17-vs-18
65•bddicken•1w ago

Comments

alberth•4h ago
Am I interrupting the data correctly in that, if you’re running on NVMe - it’s just so fast, that it doesn’t make a difference what mode you pick.
6r17•1h ago
typo *interpreting i guess ?
cientifico•1m ago
[delayed]
anarazel•3h ago
Afaict nothing in this benchmark will actually use AIO in 18. As of 18 there is aio reads for seq scans, bitmap scans, vacuum, and a few other utility commands. But the queries being run should normally be planned as index range scans. We're hoping to the the work for using AIO for index scans into 19, but it could work end up in 20, it's nontrivial.

It's also worth noting that the default for data checksums has changed, with some overhead due to that.

mebcitto•2h ago
That explains why `sync` and `worker` have so similar results in almost all runs. The benchmarks from Tomas Vondra (https://vondra.me/posts/tuning-aio-in-postgresql-18/) showed some significant differences.
p_zuckerman•26m ago
Thanks for posting this interesting article! Do we know if timescale extension is available as well?
travisgriggs•5m ago
As in timescaledb? Or something else…?

Roc Camera

https://roc.camera/
122•martialg•3h ago•112 comments

Betty White's shoulder bag is a time capsule of World War II (2023)

https://americanhistory.si.edu/explore/stories/betty-white-world-war-ii
182•thunderbong•1w ago•11 comments

Claude Memory

https://www.anthropic.com/news/memory
425•doppp•13h ago•245 comments

/dev/null is an ACID compliant database

https://jyu.dev/blog/why-dev-null-is-an-acid-compliant-database/
273•swills•9h ago•107 comments

Counter-Strike's player economy is in a multi-billion dollar freefall

https://www.polygon.com/counter-strike-cs-player-economy-multi-billion-dollar-freefall/
79•perihelions•6h ago•99 comments

Cheap DIY solar fence design

https://joeyh.name/blog/entry/cheap_DIY_solar_fence_design/
86•kamaraju•1w ago•32 comments

Computer science courses that don't exist, but should (2015)

https://prog21.dadgum.com/210.html
151•wonger_•4h ago•103 comments

How memory maps (mmap) deliver faster file access in Go

https://info.varnish-software.com/blog/how-memory-maps-mmap-deliver-25x-faster-file-access-in-go
93•ingve•8h ago•68 comments

Fast-DLLM: Training-Free Acceleration of Diffusion LLM

https://arxiv.org/abs/2505.22618
15•nathan-barry•3h ago•0 comments

Benchmarking Postgres 17 vs. 18

https://planetscale.com/blog/benchmarking-postgres-17-vs-18
65•bddicken•1w ago•7 comments

JupyterGIS breaks through to the next level

https://eo4society.esa.int/2025/10/16/jupytergis-breaks-through-to-the-next-level/
28•arjxn-py•2h ago•7 comments

Can “second life” EV batteries work as grid-scale energy storage?

https://www.volts.wtf/p/can-second-life-ev-batteries-work
134•davidw•12h ago•149 comments

When is it better to think without words?

https://www.henrikkarlsson.xyz/p/wordless-thought
117•Curiositry•9h ago•49 comments

React Flow, open source libraries for node-based UIs with React or Svelte

https://github.com/xyflow/xyflow
107•mountainview•7h ago•17 comments

PyTorch Monarch

https://pytorch.org/blog/introducing-pytorch-monarch/
332•jarbus•20h ago•41 comments

Killing Charles Dickens (2023)

https://www.newyorker.com/magazine/2023/07/10/on-killing-charles-dickens
10•bryanrasmussen•6d ago•1 comments

Summary of the Amazon DynamoDB Service Disruption in US-East-1 Region

https://aws.amazon.com/message/101925/
465•meetpateltech•1d ago•144 comments

I spent a year making an ASN.1 compiler in D

https://bradley.chatha.dev/blog/dlang-propaganda/asn1-compiler-in-d/
262•BradleyChatha•17h ago•181 comments

Automating Algorithm Discovery: A Case Study in MoE Load Balancing

https://adrs-ucb.notion.site/moe-load-balancing
111•melissapan•8h ago•54 comments

Introduction to the concept of likelihood and its applications (2018)

https://journals.sagepub.com/doi/10.1177/2515245917744314
34•sebg•7h ago•3 comments

Date bug in Rust-based coreutils affects Ubuntu 25.10 automatic updates

https://lwn.net/Articles/1043103/
138•blueflow•9h ago•132 comments

OpenAI acquires Sky.app

https://openai.com/index/openai-acquires-software-applications-incorporated
163•meetpateltech•13h ago•107 comments

Apple loses UK App Store monopoly case, penalty might near $2B

https://9to5mac.com/2025/10/23/apple-loses-uk-app-store-monopoly-case-penalty-might-near-2-billion/
241•thelastgallon•8h ago•231 comments

FocusTube: A Chrome extension that hides YouTube Shorts

https://github.com/CaptainYouz/FocusTube
191•youz•9h ago•144 comments

US probes Waymo robotaxis over school bus safety

https://www.yahoo.com/news/articles/us-investigates-waymo-robotaxis-over-102015308.html
89•gmays•18h ago•145 comments

Kaitai Struct: declarative binary format parsing language

https://kaitai.io/
111•djoldman•1w ago•37 comments

Color-changing organogel stretches 46 times its size and self-heals

https://phys.org/news/2025-09-organogel-size.html
5•PaulHoule•1w ago•0 comments

Binmoji: A 64-bit emoji encoding

https://github.com/jb55/binmoji
12•jb55•1w ago•2 comments

Zram Performance Analysis

https://notes.xeome.dev/notes/Zram
74•enz•10h ago•24 comments

Antislop: A framework for eliminating repetitive patterns in language models

https://arxiv.org/abs/2510.15061
98•Der_Einzige•14h ago•95 comments