· 3 min · PostgreSQL

Stop Using AI to Report PostgreSQL Bugs

AI-generated bug reports are flooding PostgreSQL's mailing list, wasting triagers' time with low-quality submissions.

0 comments

· 9 min · PostgreSQL

All Your GUCs in a Row: scram_iterations

Three anthropomorphic ducks dressed in formal attire stand in an elegant dining room; the leftmost wears a black tuxedo, the center wears a black suit, and the right wears a gold beaded gown with a pearl necklace and feathered fascinator. `scram_iterations` embeds itself in each password when set and stays there forever, making it a per-password property masquerading as a server setting.

0 comments

· 7 min · PostgreSQL

All Your GUCs in a Row: row_security

`row_security = off` doesn't disable row-level security—it triggers an error when a policy would apply.

0 comments

· 7 min · PostgreSQL

All Your GUCs in a Row: restrict_nonsystem_relation_kind

PostgreSQL 16.4, 15.8, 14.13, 13.16 and 12.20 added a security parameter that only pg_dump uses.

0 comments

· 8 min · PostgreSQL

All Your GUCs in a Row: restore_command

PostgreSQL's `restore_command` asks for WAL segments one at a time until the command fails—and that failure marks the archive's end, whether it's real or not.

0 comments

· 7 min · PostgreSQL

All Your GUCs in a Row: restart_after_crash

NASCAR pit crew member in red and white suit sprays water on damaged race car during pit stop, with yellow-clad crew members and another car visible in the background. When a PostgreSQL backend crashes, the postmaster can restart itself automatically or exit and wait for external intervention.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: reserved_connections

Three anthropomorphic ducks dressed in formal attire stand in an elegant dining room; the leftmost wears a black tuxedo, the center wears a black suit, and the right wears a gold beaded gown with a pearl necklace and feathered fascinator. PostgreSQL 16's `reserved_connections` reserves slots for your monitoring and backup roles when the application exhausts the pool.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: remove_temp_files_after_crash

Anthropomorphic duck wearing a yellow hard hat and blue work shirt sweeps scattered papers from a highway while an overturned truck labeled "American Freight" spills its cargo nearby. Protect your disk from orphaned temporary files after a backend crash.

0 comments

· 8 min · PostgreSQL

All Your GUCs in a Row: recursive_worktable_factor

A duck stands on a classroom floor next to a stack of wooden and metal chairs, with a green chalkboard and wooden furniture visible in the background. PostgreSQL 15's `recursive_worktable_factor` helps you fix slow recursive CTEs by tuning a single estimate.

0 comments

· 13 min · PostgreSQL

All Your GUCs in a Row: the recovery_target parameters

Duck with iridescent green head and brown body perched on a hospital bed, looking up at a January calendar hanging on the wall with dates circled in red. Restore to the moment before the disaster using eight parameters that answer where replay stops, which timeline to follow, and what to do when you get there.

0 comments