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…

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.

California's AI Transparency Act just lost its user threshold.

Inspect the LLVM bitcode PostgreSQL generates with `jit_dump_bitcode`, or wire JIT-compiled functions into GDB and perf with `jit_debugging_support` and…

Every query locks every index on a table, even ones it doesn't use.

PostgreSQL's JIT compiler fires based on estimated query cost, but that estimate measures data volume, not expression complexity.

PostgreSQL's JIT compiler has two jobs: compiling expressions and deforming tuples. Here's how to isolate JIT bugs with two simple boolean toggles.

PostgreSQL's JIT compiler trades upfront compilation time for faster query execution—but it silently does nothing if the LLVM library isn't installed.

Choose your I/O execution engine with `io_method` and size the worker pool with `io_workers`—and yes, you can resize workers without restarting.

PostgreSQL 18's new io_max_concurrency caps per-process I/O operations in flight.