Canfor
25-Minute Talk
Although PostgreSQL has hundreds of configuration options, only a tiny percentage are regularly modified in real-world installations, and some defaults are overridden significantly more frequently than the documentation may indicate.
In order to comprehend how configuration functions in practice rather than only in theory, we offer a comprehensive examination of PostgreSQL GUC usage across thousands of production servers in this session.
We'll investigate queries such as: Which settings differ from their default values the most? Which GUCs are hardly ever touched? What effects do workload type and hardware size have on configuration patterns? What may we infer from the fact that some settings are routinely overridden? Along the way, we'll explain to novices how PostgreSQL configuration actually functions (scope, reload vs. restart, precedence), and then we'll utilize actual data to show common trends, surprises, and hazards.
Developers and operators who wish to comprehend not just how PostgreSQL can be configured, but also how it is really configured in production and what that means for future PostgreSQL defaults, performance, and reliability are the target audience for this session.
