[deleted]
It's 2026, Just Use Postgres
41–50 of 349 posts
Re: It's 2026, Just Use Postgres
#42No thanks. In 2026 I want HA and replication out of the box without the insanity.
Exactly my thoughts immediately after reading the word “just”. Also, PITR.
Re: It's 2026, Just Use Postgres
#43I made the switch from MySQL to postgres a few years ago I didn't really understand what everyone was excited about before I made the switch. I haven't used MySQL since and I think postgres provides everything I need the only thing that I ever snarl at is how many dials and knobs and options there are that's not a bad thing!
Re: It's 2026, Just Use Postgres
#44Caching is mentioned in the article: What do you guys feel about using PostgreSQL for caching instead of Redis? Redis is many times faster, so much that it doesn't seem comparable to me. A lot of data you can get away with just caching in-mem on each node, but when you have many nodes there are valid cases where you really want that distributed cache.
I say do it, if it simplifies the architecture. For example if you are using firestore with a redis cache layer, that's 2 dbs. If you can replace 2 dbs with 1 db (postgres), I think it's worth it. But if you are suggesting using a postgres cache layer in front of firestore instead of redis... to me that's not as clear cut.
Re: It's 2026, Just Use Postgres
#45Blog posts, like academic papers, should have to divulge how AI has been used to write them.
Yes this is clearly verbatim output from an LLM. But it's perfect HN bait, really. The title is spicy enough that folks will comment without reading the article (more so than usual), and so it survives a bit longer before being flagged as slop.
Is HN guidelines to flag AI content? I am unsure of how flagging for this is supposed to work on HN and have only ever used the flag feature for obvious spam or scams.
Re: It's 2026, Just Use Postgres
#46Can anyone comment on whether postgres can replace full columnar DB? I see "full text search" but it feels like this is falling a little short of the full power of elastic -- but would be happy to be wrong (one less tech to remember).
Re: It's 2026, Just Use Postgres
#47I've found that Postgres consumes (by default) more disk than, for example, MySQL. And the difference is quite significant. That means more money that I have to pay every month. But, sure Postgres seems like I system that integrates a lot of subsystems, that adds a lot of complexity too. I'm just marking the bad points because you mention the good points in the post. You're also trying to sell you service, which is g…
Some people do Postgres on compressed ZFS volumes to great success.
I am curious if you know anyone using Btrfs for this too. I like ZFS, but it Btrfs can do this it would be easier to use with some distros, etc. as it's supported in kernel.
Re: It's 2026, Just Use Postgres
#48This post is discussing more specialized databases, but why would people choose Oracle/Microsoft DB instead of Postgres? Your own experience is welcome.
I'd pick MSSQL if I was being compensated based upon the accuracy, performance, durability and availability of the system. Also in any cases where the customer can pay and won't complain even once about how much this costs.
I'd never advocate for a new oracle install. But, I'd likely defend an existing one. I've seen how effective pl/sql can be in complex environments. Rewriting all that sql just because "oracle man bad" (or whatever) is a huge fucking ask of any rational business owner.
Re: It's 2026, Just Use Postgres
#49This is the future of all devtools in the AI era. There's no reason for tool innovation because we'll just use whatever AIs know best which will always be the most common thing in their training data. It's a self-reinforcing loop. The most common languages, tools, libraries of today are what we will be stuck with for the foreseeable future.
Re: It's 2026, Just Use Postgres
#50Can anyone comment on whether postgres can replace full columnar DB? I see "full text search" but it feels like this is falling a little short of the full power of elastic -- but would be happy to be wrong (one less tech to remember).
There are several different plugins for postgres that do columnar tables, including the company TigerData which wrote this blog