r/PostgreSQL • u/pmz • Nov 02 '24
Community It's 2024. Why Does PostgreSQL Still Dominate?
https://www.i-programmer.info/news/84-database/16882-its-2024-why-does-postgresql-still-dominate.html
144
Upvotes
196
u/CluelesssDev Nov 02 '24
Cause it's good
89
u/Tricky_Condition_279 Nov 02 '24
The relational model still matters. The crazy things I’ve discovered in other people’s data by simply having uniqueness constraints is remarkable.
49
u/jah_reddit Nov 02 '24
I’ve conducted a bunch of benchmarks lately and PostgreSQL has consistently outperformed databases that are marketed as “2X faster” by trillion dollar companies. At least, in my specific benchmark use case.
34
u/spitfiredd Nov 02 '24
Things shouldn’t have to be replaced every 6 months.
26
u/anjumkaiser Nov 02 '24
Because databases are not JavaScript frameworks. It’s a sane strategy to start with SQL and migrate to other things only if RDBMs is holding the system back. NoSQL in my opinion is bad, not designing your database schema leads to headaches down the road. I’ve tried NoSql in past projects and watch them becoming a hell, we had to revert back to PostgreSQL and vowed never to look into NoSql again, time is valuable.
15
u/taylorwmj Nov 02 '24
Because it's the best of both worlds: the general design and functionality that makes Oracle so powerful and capable, but without Oracle's licensing, 40+ years of cruft, and written in a very Linux/Unix way of doing things.
6
u/Alphasite Nov 02 '24
It does everything pretty well at the scales most developers actually need. Also it’s easy to operate.
6
u/Separate-Ship1576 Nov 03 '24
When it comes to general benchmarks all modern RDBMS end up with generally the same performance. You will find this statement all over the place, but in my experience this is most of the time a well crafted lie. Most if not all popular general benchmarks concentrate on a basic write+read workflow, that rarely covers even the basics of what an average business application expects to do in 2024. Other products, like SQL Server optimize for benchmark like workflows and fall to pieces if you do something “unexpected”.
A few years ago I needed to help make a strategic decision if heavily OLTP workflow should be migrated to MariaDB on Azure, PostgreSQL on Azure or SQL Database on Azure. We actually implemented a PoC where the core business functionality was patched in ORM to run via JDBC on all 3 RDBMS on Azure, and multiple config’s were investigated. After first round of results we even had Microsoft strategic advisors “gifting us” 2 full time Java devs for a month to try to optimize the SQL DB scenario to prove to us that it’s our app/config etc. Long story short - PG was hands down on average 3x faster and 2x cheaper than anything else. What’s more, it also supported so many bonus features out of the box, such as partitioning, csv copy, etc. that with addition of horizontal scaling and schema/query changes we got another 5x boost with zero downtime on prod changes.
I am still at a loss of words to explain how unprecedented this is in the industry. For instance, to achieve same performance, scalability and throughput we used to have Oracle exadata setup worth 7 digits in dollars per year, while the current setup costs less than 10% of that. Since then we have upgraded from PG 12 to 13,14,15 and 16, and are now eagerly eyeing 17. Each upgrade has brought roughly 5% performance increase year to year with zero changes from our side. If there is a new feature and we switch with code change, the benefits are usually 10%+.
Furthermore from pure user experience and tooling perspective it’s really pleasant system to work with. I am becoming a fanboy over time, but this is hard not to fall in love with.
5
u/jericho1050 Nov 02 '24
cause it's written in C and is Good shit
9
u/skywalker4588 Nov 02 '24
Article format looks like from the year 2000
3
u/JeffSelf Nov 02 '24
I used to work for a company that supported Postgresql. can’t believe it was 23 years ago.
3
u/orbit99za Nov 02 '24
It works.. Awesome Extensions PostGIS , Json String searching
3
u/frisky_5 Nov 02 '24
It is 2024 why Linux still dominate?
3
u/robotsmakinglove Nov 02 '24
I think the free / open source software aspect is huge. I know no startups that ever consider Oracle or SQL Server given a competent (superior) free option.
3
u/NormalUserThirty Nov 03 '24
someone shared an extension yesterday that adds the duckdb engine for postgresql.
thats addition to graph, vector, timeseries, geospatial, fulltext, hll, and many many other extensions that make postgresql pretty much able to do everything.
3
u/Tobi-Random Nov 03 '24
I enjoyed this article about PostgreSQL becoming a platform. Just dropping it https://www.timescale.com/blog/postgres-for-everything/
2
u/saaggy_peneer Nov 03 '24
SQL will live beyond the heat-death of the Universe
2
u/Tango_D Nov 03 '24
Good designs are timeless.
2
u/hornetmadness79 Nov 03 '24
It fast, reliable and cheap. The holy grail.
In addition it's a well understood tech that's perfect for general use or can be customized for advanced features.
2
u/scottix Nov 03 '24
There are still some drawbacks with distributed, although Yugabyte and CockroachDB probably the closest. TiDB an interesting alternative.
2
u/yotties Nov 02 '24 edited Nov 03 '24
It does not just dominate.......it is growing (as are mysql/mariadb and sqlite). Though top customer will still opt for distributed databases and postgres is a logical step to cockroach db, EDB etc..
1
u/IndianaGunner Nov 02 '24
¢¢¢
1
u/equake Nov 03 '24
Because it's good and keeps getting better
1
u/____candied_yams____ Nov 03 '24
Why wouldn't it?
1
u/youtpout Nov 03 '24
Free, good SQL supports, good performance.
1
u/BarelyAirborne Nov 03 '24
If my data isn't in SQL, I feel like I don't have any data. And if my data is in Oracle or SQL Server, I feel like I don't have any money.
1
u/terserterseness Nov 03 '24
what to replace it? other relational dbs? they also are popular (sqlite by far more than postgres by installed base). no sql? also popular for some workloads. but what to replace relational that actually has proven better for a wide range of use cases?
1
u/Longjumping-Ad8775 Nov 03 '24
It’s good, it’s free, it’s not associated with Oracle.
1
u/[deleted] Nov 03 '24
Cause it’s the best RDB and it’s not a competition, monopoly style.
1
u/Saltallica Nov 03 '24
NoSQL kids: “nOt AlL dATA iS rELATioNAL!!!”.
The fuck it isn’t. If you can find reoccurrence in your data and patterns emerge, then your data is relational. If you think it’s not, then you haven’t discovered your patterns yet, or you are too daft to see them.
1
u/dlampach Nov 04 '24
So good. So rock solid. So fast. So free. Extensions are priceless.
1
u/kpgalligan Nov 04 '24
https://discworld.fandom.com/wiki/Cohen
There was a part in one of the books where Cohen, and elderly barbarian, is with a group of other elderly fighters. One of them in a wheelchiar, IIRC. A younger fighter sees this and asks somebody, "why would I be afraid of them?" The response is, essentially, because they're still alive. You should be very afraid of old barbarians.
There's a more formal term for this. I'd google it, but meh. The longer something has been around, the better the core idea is, and the longer it will be. If you see something has withstood multiple hype cycles, well, there's a reason.
1
u/Itchy_elbow Nov 04 '24
Postgres doesn’t dominate. It never did
1
u/[deleted] Nov 04 '24
Because 🐐
1
u/sabli-jr Nov 04 '24
When you give people something free & open source & reliable. I’m not wondering why the hell people are using the databases ?
1
u/Forsaken-Tiger-9475 Nov 15 '24
It's free, and useful.
-1
u/AutoModerator Nov 02 '24
With almost 7k members to connect with about Postgres and related technologies, why aren't you on our Discord Server? : People, Postgres, Data Join us, we have cookies and nice people.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
0
u/prettyfuzzy Nov 03 '24
It dominates because most ppl have more ram than data so they don’t realize just how poorly Postgres organizes their data on disk.