frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Postgres for everything, does it work?

3•saisrirampur•2h ago
I recently revisited an HN discussion on using “Postgres for everything” (https://news.ycombinator.com/item?id=42347606 ) and also read/participated in this Twitter thread: https://x.com/BenjDicken/status/2002742633966514544 . Both prompted a few reflections. What stood out to me was how divided opinions still are—some people strongly believe in this approach, while others don’t. I wanted to share my perspective on this.

In my experience, many proponents of “Postgres for everything” haven’t been exposed enough to (newer) purpose-built technologies and the tremendous value they can create. I was firmly in that camp for nearly a decade while working at Citus and on the Microsoft Postgres team. After building PeerDB (a Postgres CDC product that syncs data to various systems) and working at ClickHouse, my perspective completely changed. Seeing firsthand the “magic” that purpose-built systems deliver for their specific use cases—especially in terms of cost, performance, and scale—was truly eye-opening.

Don’t get me wrong—I’m a huge Postgres proponent and have spent 10 years helping customers implement it. However, I strongly believe in using Postgres for what it was designed for in the first place. Postgres is a row-based OLTP database, with over 30 years of engineering effort dedicated to making it robust for that specific workload.

Proponents of “Postgres for everything” often argue that a single stack is simpler and reduces complexity. What’s frequently overlooked, however, is the CAPEX and OPEX required to make Postgres work well for use cases it wasn’t designed for. At Citus, many customers had reasonably sized teams of Postgres experts whose primary job was to constantly tune, operate, and “babysit” the system to keep it working at scale.

Separately, we’re seeing the need for purpose-built technologies emerge much earlier in a company’s lifecycle, likely driven by AI. At ClickHouse, many customers using Postgres CDC are seed-stage companies that have grown rapidly. We pulled together some data that highlights these trends here: https://clickhouse.com/blog/postgres-cdc-year-in-review-2025#use-cases

Ultimately, I believe it’s better to make it seamless and even magical for users to integrate purpose-built technologies with Postgres, rather than making an overgeneralized claim of “Postgres for everything.”

Waymo updates fleet in response to Bay Area outage chaos

https://www.theregister.com/2025/12/24/waymo_updates_power_outages/
2•raybb•5m ago•0 comments

FFmpeg files DMCA takedown request against Rockchip MPP for LGPL violation

https://github.com/github/dmca/blob/master/2025/12/2025-12-18-ffmpeg.md
1•csmantle•6m ago•0 comments

Make a Moon Phases Calendar and Calculator

https://www.jpl.nasa.gov/edu/resources/project/make-a-moon-phases-calendar-and-calculator/
1•tzury•6m ago•0 comments

Show HN: Why delegation beats memory in AI Agents

https://www.getseer.dev/blogs/lessons-dec-2025
1•akshay326•6m ago•0 comments

Some snapshot memories from the film "Alien" (2009)

https://web.archive.org/web/20090412150651/http://www.zen171398.zen.co.uk/Alien.html
1•exvi•7m ago•0 comments

Neuro‑IDE: A Visual Surgical Environment for Kernel Analysis

1•neuro-os•11m ago•0 comments

Qron0B: A sleek and low-power binary wirstwatch

https://github.com/qewer33/qron0b
2•thunderbong•20m ago•0 comments

Ideal isn't real: Stress testing CockroachDB's resilience

https://www.cockroachlabs.com/blog/stress-testing-cockroachdb-resilience/
1•LittleCat38•21m ago•0 comments

CEO of Health Care Software Company Sentenced for $1B Fraud Conspiracy

https://www.justice.gov/opa/pr/ceo-health-care-software-company-sentenced-1b-fraud-conspiracy
1•healsdata•22m ago•0 comments

CorsixTH – An open source clone of Theme Hospital

https://corsixth.com
1•ibobev•28m ago•1 comments

Emergent temporal abstractions in autoregressive models enable hierarchical RL

https://arxiv.org/abs/2512.20605
1•simonpure•31m ago•0 comments

Aichat for SSH

https://github.com/au-zen/sh-ai
1•auzen•32m ago•0 comments

The Proton, the 'Most Complicated Thing You Could Possibly Imagine'

https://www.quantamagazine.org/inside-the-proton-the-most-complicated-thing-imaginable-20221019/
1•tzury•37m ago•0 comments

Former ULA President and CEO Tory Bruno Joins Blue Origin

https://spaceflightnow.com/2025/12/26/former-ula-president-and-ceo-tory-bruno-joins-blue-origin/
2•geeB•40m ago•0 comments

We're Delegating More and More Thinking to AI

https://www.railly.dev/blog/on-ai-detox/
3•Hunter17•47m ago•1 comments

Ask HN: Non-native speaker here – how to avoid sounding like ChatGPT?

2•haebom•50m ago•2 comments

State of Vibe 2025 – Vibe Creation Ecosystem Report of China

https://stateofvibe.ai/
1•kalasoo•1h ago•1 comments

Probably Post More

https://www.aadillpickle.com/blog/post-more
2•aadillpickle•1h ago•0 comments

All my senses are being tortured simultaneously

https://news.lettersofnote.com/p/all-my-senses-are-being-tortured
3•animal_spirits•1h ago•0 comments

Santa Claus on delivering 99% Uptime [video]

https://www.youtube.com/watch?v=uMoql_RYVBQ
3•vismit2000•1h ago•0 comments

Ukraine After 4 Years of War [video]

https://www.youtube.com/watch?v=U5FShLz-Q8Q
2•dralley•1h ago•0 comments

Circuit Artist – Pixel art circuit design with NANDs, now with rewind and layers

https://github.com/lets-all-be-stupid-forever/circuit-artist
3•rafinha•1h ago•3 comments

Christian Marclay on Why 'The Clock' Challenges a Digitally Obsessed Generation

https://news.artnet.com/art-world/the-clock-christian-marclay-2723438
2•bookofjoe•1h ago•0 comments

Crosspost Automatically between X and Bluesky

https://microposter.so/features/cross-post-x-bluesky
1•ProgrammerByDay•1h ago•1 comments

Ukraine delivers humiliating Christmas Day blow to Putin by recapturing key city

https://nypost.com/2025/12/25/world-news/ukraine-delivers-humiliating-christmas-day-blow-to-putin...
2•MilnerRoute•1h ago•0 comments

Rapace – RPC over SHM / WS / TCP / Mem

https://rapace.bearcove.eu/
3•todsacerdoti•1h ago•0 comments

DockBridge – Run Docker on cheap cloud servers, pay only when you use it

https://github.com/Max-Levitskiy/DockBridge
3•FunShot•1h ago•1 comments

Sorting Tutor: sorting algorithm visualizer

https://tilde.team/~kiedtl/sorting/
2•movezig•1h ago•0 comments

Show HN: Apps by AI (Claude Opus 4.5)

https://lawrencehook.github.io/apps-by-ai/
1•lawrencehook•1h ago•0 comments

Retreating from EVs could be hazardous for Western carmakers

https://www.economist.com/business/2025/12/17/retreating-from-evs-could-be-hazardous-for-western-...
14•smurda•1h ago•23 comments