The Sixth Execution
Prepared statements switch from custom plans to generic plans on the sixth execution, and that switch can make your queries mysteriously slow.
All Your GUCs in a Row: listen_addresses
Listen_addresses decides which TCP sockets exist on your server—but it says nothing about who can use them.
All Your GUCs in a Row: lo_compat_privileges
Turn off `lo_compat_privileges` unless you enjoy large objects being world-writable and nobody noticing.
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…