frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Discuss – Do AI agents deserve all the hype they are getting?

2•MicroWagie•1h ago•0 comments

Ask HN: Anyone Using a Mac Studio for Local AI/LLM?

47•UmYeahNo•1d ago•29 comments

LLMs are powerful, but enterprises are deterministic by nature

3•prateekdalal•5h ago•3 comments

Ask HN: Non AI-obsessed tech forums

26•nanocat•16h ago•21 comments

Ask HN: Ideas for small ways to make the world a better place

16•jlmcgraw•18h ago•19 comments

Ask HN: 10 months since the Llama-4 release: what happened to Meta AI?

44•Invictus0•1d ago•11 comments

Ask HN: Who wants to be hired? (February 2026)

139•whoishiring•4d ago•517 comments

Ask HN: Who is hiring? (February 2026)

313•whoishiring•4d ago•512 comments

Ask HN: Non-profit, volunteers run org needs CRM. Is Odoo Community a good sol.?

2•netfortius•13h ago•1 comments

AI Regex Scientist: A self-improving regex solver

7•PranoyP•20h ago•1 comments

Tell HN: Another round of Zendesk email spam

104•Philpax•2d ago•54 comments

Ask HN: Is Connecting via SSH Risky?

19•atrevbot•2d ago•37 comments

Ask HN: Has your whole engineering team gone big into AI coding? How's it going?

18•jchung•2d ago•13 comments

Ask HN: Why LLM providers sell access instead of consulting services?

5•pera•1d ago•13 comments

Ask HN: How does ChatGPT decide which websites to recommend?

5•nworley•1d ago•11 comments

Ask HN: What is the most complicated Algorithm you came up with yourself?

3•meffmadd•1d ago•7 comments

Ask HN: Is it just me or are most businesses insane?

8•justenough•1d ago•7 comments

Ask HN: Mem0 stores memories, but doesn't learn user patterns

9•fliellerjulian•2d ago•6 comments

Ask HN: Is there anyone here who still uses slide rules?

123•blenderob•4d ago•122 comments

Kernighan on Programming

170•chrisjj•4d ago•61 comments

Ask HN: Any International Job Boards for International Workers?

2•15charslong•15h ago•2 comments

Ask HN: Anyone Seeing YT ads related to chats on ChatGPT?

2•guhsnamih•1d ago•4 comments

Ask HN: Does global decoupling from the USA signal comeback of the desktop app?

5•wewewedxfgdf•1d ago•3 comments

We built a serverless GPU inference platform with predictable latency

5•QubridAI•2d ago•1 comments

Ask HN: Does a good "read it later" app exist?

8•buchanae•3d ago•18 comments

Ask HN: Have you been fired because of AI?

17•s-stude•4d ago•15 comments

Ask HN: How Did You Validate?

4•haute_cuisine•1d ago•6 comments

Ask HN: Anyone have a "sovereign" solution for phone calls?

12•kldg•4d ago•1 comments

Ask HN: Cheap laptop for Linux without GUI (for writing)

15•locusofself•3d ago•16 comments

Ask HN: OpenClaw users, what is your token spend?

14•8cvor6j844qw_d6•4d ago•6 comments
Open in hackernews

Postgres for everything, does it work?

11•saisrirampur•1mo 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.”

Comments

websiteapi•1mo ago
postgres is great but seems too high level "for everything."
speedgoose•1mo ago
Because you worked at Citus and Clickhouse, I think you are more experienced than most of us.

But I can add that saving medium to large files in PostgreSQL, or clickhouse, doesn’t work well.

romanhn•1mo ago
My interpretation of "Postgres for everything", which I totally agree with, is that it is a sane initial default for just about anything. It is a well-understood stack that most people have had some exposure to, and that can handle quite a wide variety of problems. New/specialized tech will have all sorts of sharp edges, it will absolutely introduce complexity, and bring about headaches you didn't expect. And frankly, in lots of cases it's premature optimization. With all that said, if the use case has proven itself out and Postgres is truly starting to struggle - by all means, good time to explore alternatives. There are no silver bullets in this business.
nacozarina•1mo ago
‘Every app is properly a db app’ is Oracle’s defining mantra and they weren’t the first.

Their sales reps LOVE the Postgres For Everything movement. It realigns app arch debates to traditional structures, conventions and objection handling.

Once a target account has made a tech commitment to PG4E, it is a trivial matter for sales to walk in later, have a ‘business conversation’, and the next thing you know your boss signed a seven-year Oracle deal.

borplk•1mo ago
Simply speaking "Postgres for everything" is meant as a fool-proof default choice for the average person making an average app. It helps startups avoid tangling themselves with some bespoke/complex combination of Redis+Postgres+RabbitMQ+MongoDB from day 1 for their app that reaches a peak of 10 requests per second with 100 daily average users if they are lucky.

This usually happens because a junior dev wants to have fun and pad their resume while playing around with tech. Or they are insecure and want to make the "maximally proper" choice with everything so they appear to be an expert. For example they think storing any JSON or cache data in Postgres is somehow incorrect or forbidden and they must use something more specific to feel like they've made the correct choice.

In general Postgres will take people very far. Majority of companies could start with it and live with it forever. If they are lucky enough to need something else by that point hopefully they have enough money and staff to re-evaluate the stack and make changes for the future of the company.