All Your GUCs in a Row: local_preload_libraries
Load shared libraries per-session from a single curated directory, no superuser needed.
The AGPL: Radioactive by Design
Google maintains a dedicated policy page banning one specific open source license in capital letters.
All Your GUCs in a Row: lock_timeout
Prevent your migration from starving behind long-running queries.
All Your GUCs in a Row: krb_caseins_users and krb_server_keyfile
PostgreSQL's GSSAPI authentication relies on two server-wide settings: `krb_server_keyfile` points to a dedicated keytab file (never share the system one), and…
All Your GUCs in a Row: join_collapse_limit
PostgreSQL's one join-order hint isn't spelled like one: set `join_collapse_limit` to 1 and the planner joins tables in exactly the order you wrote them.
SB 1000: Everyone Is a Covered Provider Now
California's AI Transparency Act just lost its user threshold.
All Your GUCs in a Row: jit_debugging_support, jit_dump_bitcode, and jit_profiling_support
Inspect the LLVM bitcode PostgreSQL generates with `jit_dump_bitcode`, or wire JIT-compiled functions into GDB and perf with `jit_debugging_support` and…
Sixteen Locks Ought to Be Enough for Anybody
Every query locks every index on a table, even ones it doesn't use.
All Your GUCs in a Row: jit_above_cost, jit_inline_above_cost, and jit_optimize_above_cost
PostgreSQL's JIT compiler fires based on estimated query cost, but that estimate measures data volume, not expression complexity.
All Your GUCs in a Row: jit_expressions and jit_tuple_deforming
PostgreSQL's JIT compiler has two jobs: compiling expressions and deforming tuples. Here's how to isolate JIT bugs with two simple boolean toggles.