· 11 min · PostgreSQL

The International Ice Patrol

Animated characters dressed as naval officers scanning the ocean from a ship's bridge with binoculars at dusk. On September 30, AWS announced that Aurora PostgreSQL can now query Apache Iceberg and Parquet data directly. That brings the number of things a vendor might me

0 comments

· 6 min

All Your GUCs in a Row: oauth_validator_libraries

Illustration of three anthropomorphic ducks in tuxedos juggling keys on a circus stage with striped tent backdrop and spotlight lighting. PostgreSQL 18's OAuth support delegates token validation to third-party libraries.

0 comments

· 13 min · FOSSLaw

The Garden of Forking Paths

Most projects inherit their license like a default shell and never reconsider it.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: num_os_semaphores

Five cartoon birds with halos and wings standing in a row on sand, with colored directional signs spelling "QUACK" above them and a white picket fence in the background. PostgreSQL 18's new `num_os_semaphores` preset reports how many OS semaphores the server needs—a formula that drifted wrong for twelve years until the…

0 comments

· 13 min · PostgreSQL

The Deep End

Loch Ness Monster emerging from a swimming pool surrounded by ducks, with pool ladder and facilities visible in the background. Dive deeper into connection pooling with five more PostgreSQL poolers: Odyssey, pgagroal, Supavisor, PgDoorman, and ProxySQL, plus where your cloud already…

0 comments

· 6 min · PostgreSQL

All Your GUCs in a Row: notify_buffers

A mallard duck holds a smartphone displaying a list of "Quack" entries, looking at the screen. The `notify_buffers` GUC tunes a 128kB cache for PostgreSQL's LISTEN/NOTIFY queue—and almost never matters.

0 comments

· 14 min · PostgreSQL

Everyone into the Pool

Elephant diving into a public swimming pool filled with water and birds, with a diving board and spectators in the background. PostgreSQL's simple one-process-per-connection model is expensive.

0 comments

· 4 min · Alerts, PostgreSQL

The Vector That Lied About Its Dimensions

A vector index build in pgvector 0.8.6 and earlier trusted a vector's header over the column's dimension count, allowing out-of-bounds writes.

0 comments

· 7 min · PostgreSQL

All Your GUCs in a Row: multixact_member_buffers and multixact_offset_buffers

Three ducks stand in front of a large chalkboard covered with a grid of handwritten numbers. When one long transaction holds row locks on thousands of parents, multixact cache misses can tank insert throughput.

0 comments

· 7 min · PostgreSQL

All Your GUCs in a Row: min_wal_size

Duck standing on a brick irrigation channel in a flat agricultural field with rows of green crops stretching to the horizon. `min_wal_size` sets a floor under WAL recycling, not a retention policy—confusing many operators who lose standbys when the floor causes segments to be…

0 comments