Distributed SQL Tips and Tricks – Jan 24, 2020

The performance impact of deleting tombstones in YugabyteDB is minimal due to its LSM engine, which performs logical merges of memtables/SSTables sorted by timestamp order, and flushes only retain the latest deleted or overwritten value. YugabyteDB achieves high data density per node by using a customized RocksDB instance with block-based splitting of bloom/index data, size-tiered compactions, smart load balancing across multiple disks, efficient C++ implementation, on-disk block compression, and globally throttled compaction queues. The maximum number of rows in YugabyteDB is theoretically limited to 2^64 - 1, but a real-world limit of 20 billion rows has been achieved. New documentation, blogs, tutorials, and videos have been published, including guides for migrating databases from MongoDB to YugabyteDB and implementing PostgreSQL table functions. The company is hiring software engineers with expertise in cloud infrastructure, core database, full-stack development, and developer advocacy.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.