4 ms·
Very good overview and easy to read. In recent years I‘ve encountered more and more businesses that use or want to use Postgres instead of other proprietary or
by ManBeardPc 3y ago
Very good overview and easy to read. In recent years I‘ve encountered more and more businesses that use or want to use Postgres instead of other proprietary or NoSQL databases, so this post is very useful.
- franckpachot 3y agoThe article is a marketing promotion for Citus. They ignore Neon, a major innovation in distributed cloud storage solutions. They reduce Distributed SQL to key-value stores, when it is actually the only distributed architecture that preserves all SQL features (ACID, consistent reads, referential integrity, global indexes). And the only fact about performance is a benchmark comparing elastic and resilient distributed SQL to non-HA Citus running on larger machines.
- ManBeardPc 3y agoBig parts of the article are pretty generic concepts and only mention other products as an example. Haven't heard of Neon yet. What does Neon do differently? Is there a good introduction/overview? Good, fair and reproducible benchmarks are a rarity. Do you have any (independent) benchmarks that compare different distributed PostgreSQL-based solutions?
- franckpachot 3y agoAll benchmarks are biased because nobody does the same level of config tuning on different databases. But this GigaOm/Microsoft one is a joke. They run Citus with no replication on 12x16+1x32 vCores and the others on 14x16 vCPU (so 14x8 cores) with replication factor 3.
- ManBeardPc 3y agoWithout good benchmarks it's hardly possible to compare different products. But I agree that this benchmarks seems questionable at best then. I usually only work with on-premise deployments, so I don't know the details of all the cloud offerings. People will probably judge products on what is available on the first few search results though.
- tristan957 3y agoHere is a blog post that should be a good dive into the Neon storage engine. I work at Neon, and am happy to answer any other questions you might have. https://neon.tech/blog/get-page-at-lsn https://neon.tech/blog/get-page-at-lsn
- indymike 3y agoNeon is a very confusing name, and honestly needs to be changed to something that can be distinct in the marketplace.
- franckpachot 3y agoI mentioned Neon because it is open source and the article says "Not OSS" for "DBMS-optimized cloud storage". Think of it as open-source Aurora https://neon.tech/ https://neon.tech/
- indymike 3y agoI think Neon is KDE's Linux distribution.
- mnming 3y agoI fail to see this as a marketing promotion though, it doesn't seem to have much bias. Though I do agree calling distributed SQL as key value store inaccurate and maybe a bit inappropriate.