PostgreSQL 10 High Performance - Third Edition

Defaults and reset values

The database has two things that you might refer to as a default, depending on your context. The first type of default is what the server will set the value to if you don't ever change it to the setting the server starts with before it has even read the postgresql.conf file. Starting in PostgreSQL 8.4, you can check this value using the pg_settings view by looking at the boot_val column: http://www.postgresql.org/docs/current/static/view-pg-settings.html. Once the server has started, and you make changes to parameters, there's also a default value those parameters will return to, if you use the RESET command documented at http://www.postgresql.org/docs/current/static/sql-reset.html to return them to their starting ...