» Tag
database-performance
4 postsDuckDB Parquet Paging: file_row_number vs OFFSET, and a Correctness Trap
DuckDB Parquet paging compared: file_row_number vs OFFSET performance, plus a hidden data-correctness risk in parallel scans.
Diagnosing Slow Postgres Queries: Planning Time vs Execution Time
Learn to read EXPLAIN ANALYZE buffer stats to tell if a slow Postgres query needs partition/plan fixes or memory/storage fixes.
PostgreSQL Row-Level Security: Where the Performance Cost Hides
Benchmarks show PostgreSQL row-level security is free with proper indexing, but unstable helper functions and membership checks can add seconds of latency.
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.comPostgreSQL Batch UPSERT with CTE: From 90 Seconds to 5
An email sync process with audit history was rewritten from separate queries into a single PostgreSQL CTE, cutting 100k-row processing time from 90 seconds to 5.