· 2 min read · PostgreSQL

All Your GUCs in a Row: authentication_timeout

A photorealistic image of a duck pouting in a corner of a living room, with a felt line on the carpet cordoning off the corner. Unauthenticated TCP connections consume backend slots until they log in or hit authentication_timeout.

0 comments

· 12 min read · PostgreSQL

On pgvectorscale, and Hybrid Search Without an Elasticsearch Sidecar

pgvectorscale brings DiskANN's memory-efficient graph design to PostgreSQL, cutting vector search latency 9× versus HNSW when your index doesn't fit in RAM.

0 comments

· 4 min read · FOSSLaw, PostgreSQL

PHP Goes BSD

PHP 9.0 is ditching its dual custom licenses for the standard 3-clause BSD license.

0 comments

· 8 min read · PostgreSQL

After pgBackRest

pgBackRest is unmaintained. Here's what to do next: an honest evaluation of Barman, WAL-G, and the realistic alternatives for production PostgreSQL backups.

0 comments

· 2 min read · PostgreSQL

All Your GUCs in a Row: array_nulls

A Rouen duck is considering the holes in a sidewalk. Control whether unquoted NULL in array literals becomes a SQL null or the string "NULL".

0 comments

· 7 min read · PostgreSQL

AIO Grows Up

PostgreSQL 18 shipped async I/O but left operators with a single static knob.

0 comments

· 2 min read · PostgreSQL

REPACK Moves In

PostgreSQL 19 ships a built-in REPACK command that defrags bloated tables without exclusive locks. We measure the real cost and survey the caveats.

0 comments

· 2 min read · FOSSLaw

Thaler Is Dead. The AI Copyright Argument Isn’t.

The Supreme Court let stand a narrow ruling: machines alone cannot be copyright authors.

0 comments

· 2 min read · PostgreSQL

All Your GUCs in a Row: archive_timeout

A photorealistic 35mm photograph on Fuji Velvia film. A flock of male and female mallard ducks is being chased out of the front door a large, stately library by an Indian runner duck. The Indian runner duck is wearing librarian's spectacles. An old fashioned round clock is above the door archive_timeout forces WAL segment rotations on quiet databases to prevent hours of unarchived writes.

0 comments

· 13 min read · PostgreSQL

Managed Postgres, Examined: Amazon RDS for PostgreSQL

A photorealistic image of a blue elephant wearing a tabord with the large letters "RDS" on the side. AWS runs unmodified PostgreSQL on EC2 instances, handling backups and failover via storage-layer replication. Learn what RDS actually is—and what it isn't.

0 comments