News for hackers. Stuff that matters.
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.
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.