· 5 min · PostgreSQL

Twenty Years, Three CVEs, One AI

Three heap buffer overflows in PostgreSQL — including a 20-year-old pgcrypto bug — were found by an AI code analyzer. But.

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: commit_delay and commit_siblings

Tune `commit_delay` to batch WAL flushes and trade latency for throughput—but only if `pg_test_fsync` proves sync time is your bottleneck.

0 comments

· 5 min · PostgreSQL

REPACK CONCURRENTLY: pg_squeeze Gets a Promotion

PostgreSQL 19 brings REPACK CONCURRENTLY, a native alternative to pg_repack that rewrites tables without crippling locks.

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: cluster_name

cluster_name looks like a cosmetic label for process listings, but on a standby it silently becomes the name your primary uses to verify synchronous…

0 comments

· 16 min · PostgreSQL

Managed Postgres, Examined: Google AlloyDB for PostgreSQL

Fourth in a series of dispassionate tours of managed PostgreSQL services. Previously: RDS, Aurora, and Cloud SQL. AlloyDB is Google’s distributed-storage Postgr

0 comments

· 3 min · PostgreSQL

What Else Is In There?

A 1990s-vintage PostgreSQL extension shipping a critical buffer overflow in 2026 reveals a larger problem: most teams can't even say what's actually installed…

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: client_min_messages

`client_min_messages` controls what your session sees, not what the server logs—a confusion that spawns most of its trouble.

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: client_connection_check_interval

PostgreSQL 14 added a parameter that detects dead client connections during query execution, stopping wasted work before it's too late.

0 comments

· 2 min · PostgreSQL

A Correction: Snowflake Postgres Is Just Postgres

Snowflake Postgres is community Postgres, not a fork with a proprietary storage layer—a correction to Wednesday's post on table access methods, and a closer…

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: client_encoding

Character encoding conversions happen silently between client and server—until they don't.

0 comments