· 6 min · PostgreSQL

All Your GUCs in a Row: log_destination and logging_collector

Duck standing on ground next to weathered wooden shed filled with stacked firewood logs. PostgreSQL's logging collector is a small pipe-based daemon that prevents message loss and garbling—but turning it on requires a restart, which you'll want on…

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: log_connections, log_disconnections, and log_hostname

Wood duck standing among felled logs and blue and purple cables on a forest floor. PostgreSQL 18 adds granular connection logging.

0 comments

· 6 min · PostgreSQL

All Your GUCs in a Row: log_checkpoints, log_autovacuum_min_duration, and log_temp_files

Duck holding a stopwatch stands on a wooden flume carrying felled logs at a timber mill. Watch PostgreSQL's housekeeping in action: three logging parameters that reveal checkpoint costs, autovacuum trouble, and work_mem problems—and why two of them…

0 comments

· 18 min · PostgreSQL

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.

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: listen_addresses

Duck holding a wooden horn at a window of a rustic cottage with weathered white walls and green shutters. Listen_addresses decides which TCP sockets exist on your server—but it says nothing about who can use them.

0 comments

· 3 min · PostgreSQL

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.

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: local_preload_libraries

Photograph of a mobile library van labeled "Preloaded Libraries" with books stacked in its open doorway and a rooster standing in front, a white church visible in the background. Load shared libraries per-session from a single curated directory, no superuser needed.

0 comments

· 8 min · FOSSLaw

The AGPL: Radioactive by Design

Google maintains a dedicated policy page banning one specific open source license in capital letters.

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: lock_timeout

Prevent your migration from starving behind long-running queries.

0 comments

· 3 min · PostgreSQL

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…

0 comments