frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Is Postgres read heavy or write heavy?

https://www.crunchydata.com/blog/is-postgres-read-heavy-or-write-heavy-and-why-should-you-care
76•soheilpro•1d ago

Comments

alberth•55m ago
Odd that OLTP wasn’t mentioned in the article.

Postgres an an OLTP databases, which are designed for write heavy workloads.

While that being said, I agree most people have read-heavy needs.

da_chicken•23m ago
I disagree. I think the only people that have read-heavy needs are big data and data warehouses. AI being hot right now doesn't mean big data is the only game in town.

Most applications are used operationally or have a mix of read and write. Even on applications where the user can only consume content present there, there is often more than enough data capture just tracking page history to be relatively write heavy.

withinboredom•5m ago
Hmmm. Not really. Yes, everything is a mix, but for applications, it very much is on the read-heavy side. Think about how many queries you have to do just to display an arbitrary page. You might, maybe, just maybe, net 2-3 writes vs. hundreds of reads. If that starts to balance out, or even flip, then you probably need to rethink your database as you start to exit traditional db usage patterns. But <30% writes is not write-heavy.
developper39•51m ago
Very usefull, and it is clear that the author knows what he is talking about. Nice intro to Pg18 too.
gdulli•49m ago
Is a ball red or green? How long is a piece of string?
Rendello•47m ago
How thick is WAL?

https://youtu.be/PvDBGqEykvc?t=7

lysace•34m ago
Insipid text.

Also: HN needs to upgrade it's bot upvoting detection tech. This is embarrassing. It was proper ownage of the HN #1 position for like 15 minutes straight.

jagged-chisel•12m ago
> When someone asks about [database] tuning, I always say “it depends”.

Indeed. On your schema. On your usage. On your app. On your users.

How to sequence your DNA for <$2k

https://maxlangenkamp.substack.com/p/how-to-sequence-your-dna-for-2k
46•yichab0d•2h ago•21 comments

Root System Drawings

https://images.wur.nl/digital/collection/coll13/search
221•bookofjoe•8h ago•41 comments

Is Postgres read heavy or write heavy?

https://www.crunchydata.com/blog/is-postgres-read-heavy-or-write-heavy-and-why-should-you-care
77•soheilpro•1d ago•8 comments

Chen-Ning Yang, Nobel laureate, dies at 103

https://www.chinadaily.com.cn/a/202510/18/WS68f3170ea310f735438b5bf2.html
61•nhatcher•16h ago•20 comments

Tinnitus Neuromodulator

https://mynoise.net/NoiseMachines/neuromodulationTonesGenerator.php
197•gjvc•6h ago•135 comments

What Dynamic Typing Is For

https://unplannedobsolescence.com/blog/what-dynamic-typing-is-for/
60•hit8run•4d ago•38 comments

Adding Breadcrumbs to a Rails Application

https://avohq.io/blog/breadcrumbs-rails
9•flow-flow•4d ago•0 comments

Flowistry: An IDE plugin for Rust that focuses on relevant code

https://github.com/willcrichton/flowistry
122•Bogdanp•7h ago•23 comments

Who invented deep residual learning?

https://people.idsia.ch/~juergen/who-invented-residual-neural-networks.html
60•timlod•5d ago•21 comments

./watch

https://dotslashwatch.com/
281•shrx•12h ago•77 comments

Solution to CIA’s Kryptos sculpture is found in Smithsonian vault

https://www.nytimes.com/2025/10/16/science/kryptos-cia-solution-sanborn-auction.html
86•elahieh•2d ago•34 comments

Titan submersible’s $62 SanDisk memory card found undamaged at wreckage site

https://www.tomshardware.com/pc-components/microsd-cards/tragic-oceangate-titan-submersibles-usd6...
97•WithinReason•1d ago•63 comments

Why the open social web matters now

https://werd.io/why-the-open-social-web-matters-now/
61•benwerd•4d ago•14 comments

Secret diplomatic message deciphered after 350 years

https://www.nationalarchives.gov.uk/explore-the-collection/the-collection-blog/secret-diplomatic-...
61•robin_reala•2d ago•6 comments

Using CUE to unify IoT sensor data

https://aran.dev/posts/cue/using-cue-to-unify-iot-sensor-data/
24•mvdan•9h ago•2 comments

K8s with 1M nodes

https://bchess.github.io/k8s-1m/
68•denysvitali•2d ago•19 comments

Liva AI (YC S25) Is Hiring

https://www.ycombinator.com/companies/liva-ai/jobs/inrUYH9-founding-engineer
1•ashlleymo•5h ago

Carbonized 1,300-Year-Old Bread Loaves Unearthed in Turkey

https://ancientist.com/1300-year-old-communion-bread-unearthed-in-karaman-a-loaf-for-the-farmer-c...
12•ilamont•5d ago•1 comments

New Work by Gary Larson

https://www.thefarside.com/new-stuff
483•jkestner•1d ago•124 comments

When you opened a screen shot of a video in Paint, the video was playing in it

https://devblogs.microsoft.com/oldnewthing/20251014-00/?p=111681
113•birdculture•2d ago•10 comments

Coral NPU: A full-stack platform for Edge AI

https://research.google/blog/coral-npu-a-full-stack-platform-for-edge-ai/
80•LER0ever•2d ago•10 comments

Picturing Mathematics

https://mathenchant.wordpress.com/2025/10/18/picturing-mathematics/
33•jamespropp•6h ago•1 comments

Ripgrep 15.0

https://github.com/BurntSushi/ripgrep/releases/tag/15.0.0
309•robin_reala•8h ago•72 comments

SQL Anti-Patterns

https://datamethods.substack.com/p/sql-anti-patterns-you-should-avoid
197•zekrom•9h ago•140 comments

Lux: A luxurious package manager for Lua

https://github.com/lumen-oss/lux
55•Lyngbakr•9h ago•16 comments

Our Paint – a featureless but programmable painting program

https://www.WellObserve.com/OurPaint/index_en.html
40•ksymph•6d ago•5 comments

Fast calculation of the distance to cubic Bezier curves on the GPU

https://blog.pkh.me/p/46-fast-calculation-of-the-distance-to-cubic-bezier-curves-on-the-gpu.html
108•ux•13h ago•24 comments

Show HN: The Shape of YouTube

https://soy.leg.ovh/
18•hide_on_bush•6d ago•7 comments

Attention is a luxury good

https://seths.blog/2025/10/attention-is-a-luxury-good/
140•herbertl•6h ago•84 comments

Most users cannot identify AI bias, even in training data

https://www.psu.edu/news/bellisario-college-communications/story/most-users-cannot-identify-ai-bi...
8•giuliomagnifico•4h ago•0 comments