YugabyteDB的LSM Tree实现基于RocksDB，通过改进布隆过滤器、范围查询和全局缓存，加快了读操作。此外，对日志记录和并发控制进行了不同处理。RocksDB是高性能的键值存储引擎，提供灵活的存储结构。

YugabyteDB的竞争对手在市场推广中使用不准确的比较，导致了对YugabyteDB的误解。作者列出了十个关键事实来澄清这些误解。

在SQL中，可以使用WITH子句执行“获取或创建”操作，其中每个操作都是一个公共表达式（CTE）。通过优化成功的操作而不是异常情况，可以避免插入失败的情况。使用ON CONFLICT构造可能会有意外的事务行为，因此应避免使用。在示例中，使用CTE来实现“获取或创建”操作。通过将“id”列添加到辅助索引中，可以减少对表的读取请求。将数据逻辑整合到一个语句中，使用WITH子句和CTE以声明性的方式，而不是使用多个往返或过程性代码。可以通过查看执行计划来了解确切的时间复杂度。

微软比较了Azure Cosmos DB for PostgreSQL、CockroachDB和Yugabyte的事务处理性能和价格，发现Azure Cosmos DB的吞吐量更高。Citus的使用是一个争议点，CockroachDB和Yugabyte的性能较差。不同的分布式数据库在不同的特性上可能胜出。微软分享了辅助脚本，以便客户在Azure Cosmos DB上运行基准测试。

After looking at the implications of the replication factor for a YugabyteDB cluster, this blogpost looks at how a table "materialises" in a YugabyteDB cluster. The creation of a table in...

One of the most frequently reoccurring questions that we get at YugabyteDB how to interpret the information that YugabyteDB provides when people are testing (high) availability. This is a summary...

Performance is, and always has been an hot topic with databases, and a bit surrounded by mystery, because some specialists would advice changing something, and then all of a sudden the database...

This is an introduction to a new function in YSQL version 2.17. YSQL is YugabyteDB's enriched PostgreSQL version. The name of the function is yb_pg_stat_get_queries(). This new Yugabyte specific...

YugabyteDB YEDIS is a key-value database that is compatible with the redis commands library. Important: YEDIS is deprecated! There are other limitations for YEDIS see the description in the...

YugabyteDB YEDIS is a key-value database that is compatible with the redis commands library. Important: YEDIS is deprecated! There are other limitations for YEDIS see the description in the...

YugabyteDB uses the PostgreSQL source code for PostgreSQL compatibility, which we call YSQL. However, once we store tuples, we transform the PostgreSQL tuples into a storage format that is called...

To see how JSON is stored in YugabyteDB, we have to take a look at both PostgreSQL and YugabyteDB. Let's create two test tables for investigation: drop table if exists test1; create table...

Partitioning is an option to split a table in physical different objects, while the table remains a logical single entity. Partitioning is a PostgreSQL feature, which we piggybacked on with...

This blogpost is about a memory optimization that is applied to YugabyteDB version 2.15.3.0 that we applied that can make a huge difference in common situations with large amounts of memory...

This is an introduction to the hypopg PostgreSQL extension for YugabyteDB 2.15.3.0. Hypopg allows the creation of hypothetical indexes, so indexes that do not really exist. This means this allows...

The PostgreSQL database has a number of very useful functions to calculate the size of the objects on disk. Examples of such functions are pg_table_size(), pg_indexes_size(), pg_tablespace_size(),...