DuckLake writes took 3+ minutes because over 99% of catalog stats belonged to deleted tables. Two SQL queries show whether yours is next.
Eight to ten features were reverted, Postgres 14 hits EOL a week before GA, and here are the pg_upgrade --check steps to run against 19 RC1 now.
The query win at 100M vectors on 4x less RAM holds up. The 42-hour build gap is tilted, and the extension is alpha and needs PostgreSQL 18.
34x on recursive CTEs, about 20% on TPC-H SF10, and 2.0 database files that 1.5.6 can't open. Plus the lambda change that breaks old SQL.
MySQL's 20-year-old view subquery restriction (Bug #11472) finally has a reported fix. Here's how to refactor views with CTEs and nested views today.
Self-hosted ebook servers often break past 50k books. Here's why the database is usually the bottleneck and how to fix indexing, search, and metadata at scale.
A step-by-step guide to diagnosing and fixing common Barman backup failures for PostgreSQL, from SSH issues to WAL archiving and replication slots.
Stop context-switching between pgAdmin, Redis CLI, and mongosh. Here's how to consolidate your database workflow into a single lightweight client.
pgbackrest is reportedly no longer maintained. Here's how to audit your PostgreSQL backup setup and migrate to alternatives like Barman or WAL-G.
AI agents with unchecked database access are a disaster waiting to happen. Here's how to sandbox credentials, restrict permissions, and prevent autonomous tools from destroying production data.
Learn how copy-on-write database branching solves the pain of testing Postgres schema migrations, with practical workflows and CI/CD integration.
