Thebuild

PostgreSQL 18's new io_max_concurrency caps per-process I/O operations in flight.

PostgreSQL 17 introduced read streams that combine adjacent disk blocks into larger I/O requests.

IntervalStyle changes how PostgreSQL parses interval input, not just formats output-and in one case, it silently flips the sign of your data.

Every PostgreSQL connection since 8.0 has heard the server announce integer_datetimes-a parameter that's had only one possible value since PostgreSQL 10.

Discover how in_hot_standby lets clients automatically detect whether they're connected to a primary or standby-and why the timing of that notification…

Recover from catalog index corruption by sequentially scanning system tables instead of using indexes.

When a standby refuses to replay WAL that references pages that don't exist, ignore_invalid_pages converts the PANIC into a WARNING-but only as a last resort…

When data checksums catch corruption, restore from backup or fail over-unless you have neither.

Jacob Jackson at ByteofDev built something I can only describe as admirably irresponsible (and something I wish I had thought of first): claudegres, a "PostgreSQL" in which Claude is the entire backend. Not Claude tuning the database, and not Claude writi

Idle sessions consume connection slots and backend memory-not locks or xmin. Learn when and how to reap them without sabotaging your connection pooler.