PostgreSQL 18 will improve EXPLAIN output by showing fractional row counts with two decimal digits for better query plan accuracy.
A developer details their week-long project building a minimal, in-memory storage engine for MariaDB/MySQL in C++, covering the process and API comparisons.
A technical deep dive into intercepting and walking PostgreSQL query execution plans to reconstruct SQL and enable custom evaluation.
A guide to creating an in-memory storage engine for PostgreSQL using the Table Access Method API introduced in version 12.
Explores how different database systems execute query expressions, comparing tree-walking interpreters, virtual machines, and JIT compilers.
A software developer shares a curated list of high-quality, topic-specific tech subreddits for advancing programming skills.
Explains the internal workings of SQL databases, covering data structures like tables, indexes, rows, and pages for both storage and querying.
A guide to tuning PostgreSQL's autovacuum feature, covering internals, configuration, and providing a sample Docker setup.
The author praises Joe Obbish's blog for its original, critical analysis of the SQL Server Query Optimizer, declaring it the Data Platform blog of 2017.
