· 5 min · PostgreSQL

All Your GUCs in a Row: max_pred_locks_per_transaction

Anthropomorphic ducks in a steampunk workshop: one in plain dress on the left, one wearing a bowler hat, suspenders, and vest on the right, surrounded by metal gears and machine parts on a workbench. Predicate locks outlive their transactions in PostgreSQL's serializable isolation, so the default `max_pred_locks_per_transaction` of 64 sizes a table holding…

0 comments

· 14 min · PostgreSQL

The Shadow Knows

WalShadow replicates PostgreSQL to ClickHouse by decoding the physical WAL stream itself, not logical decoding.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: max_pred_locks_per_page and max_pred_locks_per_relation

White duck wearing a flat cap and leather apron, holding a wrench at a workbench in a locksmith shop lined with tool pegboards. PostgreSQL's serializable isolation remembers what each transaction reads with limited shared memory, so it trades tuple locks for page locks, then page locks…

0 comments

· 5 min · FOSSLaw

GitHub Won a Case You Weren’t In

Last Wednesday the Ninth Circuit affirmed the dismissal of the DMCA claims in Doe v. GitHub, Inc., No. 24-7700 (9th Cir. Sept. 16, 2026). The headlines said Git

0 comments

· 6 min · PostgreSQL

All Your GUCs in a Row: max_parallel_apply_workers_per_subscription

Surreal photograph of a flock of ducks seated around a wooden table with open books, scattered papers, and craft supplies in a sunlit room. Parallel apply workers speed up logical replication of large transactions—but only if you have enough of them.

0 comments

· 6 min · PostgreSQL

All Your GUCs in a Row: max_parallel_workers and max_parallel_workers_per_gather

Photograph of a mid-century office filled with ducks seated at school desks with papers and notebooks, while suited men work in the background. PostgreSQL's parallel worker parameters don't mean what their names suggest: one caps per-node requests, the other enforces a shared limit that any session can…

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: max_parallel_maintenance_workers

Surreal illustration of five ducks in work clothes and hats holding pickaxes on a construction site, with human workers and wooden scaffolding in the background. Raising `max_parallel_maintenance_workers` doesn't guarantee parallel builds use it.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: max_notify_queue_pages

Row of ducks holding newspapers while waiting at a nighttime bus stop on a city street. The `LISTEN`/`NOTIFY` queue grew from 8GB to unlimited in PostgreSQL 17.

0 comments

· 7 min · PostgreSQL

The Call Is Coming From Inside the Session

Role-level timeouts and read-only flags sound safe until you realize the session can change them in one statement.

0 comments

· 6 min · PostgreSQL

All Your GUCs in a Row: max_logical_replication_workers

Black and white photograph of ducks wearing nurse caps in a crowded indoor pen with dozens of ducklings, circa mid-20th century. When a logical replication worker pool runs dry, subscriptions don't fail—they just stop making progress, filling your logs with warnings every five seconds…

0 comments