· 6 min · PostgreSQL

All Your GUCs in a Row: max_prepared_transactions

Vintage bank interior with anthropomorphic ducks: one in a dark suit holding papers at the counter, the other in a white shirt and green bow tie operating a vintage typewriter behind the desk, a sign above reading "Only five transactions per customer" Prepared transactions are orphaned sessions that hold locks and block vacuum indefinitely.

0 comments

· 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