GUCs: A Three Hour Tour

Every option, explained

PostgreSQL now has 187 GUCs, most of which are server configuration settings, and begins to rival Oracle in complexity of administrator options. Take a high-speed tour of all of the options with core team member Josh Berkus.

Just sit right back and you'll hear at tale, a tale of some GUCs ...

PostgreSQL now has 187 GUCs, and begins to rival Oracle in complexity of administrator options. Most of these GUCs come from PostgreSQL.conf and session-level settings, and it's a rare PostgreSQL server where you want to accept all defaults.

But with so many options, how do you decide what you want to change, and to what? Josh Berkus will go through every single option and explain it (at least breifly), giving advice and examples on many of the more important ones.

At the end of the talk, we'll see how many options Josh can recite in one breath.