Tag
PlanetScale introduces Database Traffic Control, a Postgres traffic management system that lets users enforce flexible budgets on database resources, preventing overload from bad queries or runaway workloads.
pg_plan_advice is a PostgreSQL module that allows users to influence and stabilize query plan choices by specifying plan advice using a mini-language. It helps in controlling join order, scan methods, and other planner decisions, but overriding planner defaults can backfire if data distribution changes.
This article explains how continuation-passing style (CPS) can be used to fuse database operators, avoiding materialization of intermediate results and improving performance, as an alternative to vectorization and compilation. The author presents a simplified example with numeric list operations and describes the inspiration from a short paper.
Postgres 19 introduces query hints via new contrib modules pg_plan_advice and pg_stash_advice, ending a long-standing community debate and providing DBAs with an escape hatch for optimizer edge cases.
PostHog used an AI agent based on Karpathy's autoresearch to find a three-year-old bug in their ClickHouse query engine that prevented proper primary key usage for timestamp filters. Fixing it improved performance by 11% and reduced scanned granules by 62%.
GreptimeDB v1.0 integrates DataFusion's dynamic filter pushdown to accelerate TopK queries by pushing runtime bounds to the scan layer, reducing query time from 29 seconds to 0.21 seconds on a 5B-row trace table.
A tutorial on optimizing MongoDB query performance using indexes, demonstrating how to identify slow queries, apply compound indexes, and manage them visually using the VisuaLeaf tool. The workflow covers query profiling, index recommendations, and common indexing mistakes.