Re:PostgreSQL maintainer Simon Riggs has died in a small air...
by giovannibonetti on Friday March 29, 2024 @07:51AM
(#39862918)
MySQL has an actively maintained LSM-tree based storage engine like MyRocks, while Postgres doesn't have production-ready options in that regard.
[ Parent
| on HN ]
Re:PostgreSQL maintainer Simon Riggs has died in a small air...
by dboreham on Friday March 29, 2024 @09:50AM
(#39864097)
Why is LSM useful for a RDB workload?
Re:PostgreSQL maintainer Simon Riggs has died in a small air...
by AtlasBarfed on Friday March 29, 2024 @01:18PM
(#39866550)
Log Structured Merge Trees are superior in write volume and scaling B+ trees higher. LSMs are part of the sauce of Cassandra and (I believe) DynamoDB for horizontal scaling.
RocksDB is a single node very efficient (better than Cassandra's in the 2.x/3.x releases, not sure about now) single node LSM implementation.