SlothDB is a from-scratch C++20 embedded SQL database in active development. Same model as DuckDB and SQLite: query Parquet, CSV, JSON, Arrow, Avro, SQLite, and Excel files directly with SQL, ...

Queen MQ is a partitioned message queue backed by PostgreSQL, built with uWebSockets, libuv, and the libpq async API. It gives you unlimited FIFO partitions that process independently, consumer groups ...

When dealing with massive datasets (billions of rows), queries like aggregations, filtering, and joins become slow because the engine scans the entire table. This leads to: Partitioning solves this by ...

When tuning SQL databases for performance, two concepts often come up: Clustered Indexes and Table Partitioning. While both aim to optimize how data is stored and accessed, they are fundamentally ...

The series of blog posts I wrote last year on semantic model memory usage, in particular this post on the query memory limit and the “This query uses more memory ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

If you’ve been following some of my recent posts about improving Power BI refresh performance by partitioning tables you will have seen a lot of screenshots that look like the one below: It’s a ...

Major upgrade to the ever-evolving Oracle Database brings JavaScript support, graph optimizations, in-memory enhancements, and dramatic improvements to JSON operations and in-database machine learning ...

墨墨导读：本文来自墨天轮用户投稿，详细描述Oracle分区表之创建维护分区表索引的步骤。 分区索引分为本地(local index)索引和全局索引(global index)。局部索引比全局索引容易管理, 而全局索引比较快。 与索引有关的表： dba_part_indexes 分区索引的概要统计信息 ...

Kevin Xu is general manager of global strategy and operations at PingCAP. TiDB is an open-source, cloud-native, MySQL-compatible distributed database that handles hybrid transactional and analytical ...