The PostgreSQL settings control different aspects of the PostgreSQL server, including replication, write-ahead logs, resource consumption, query planning, logging, authentication, statistic collection, garbage collection, client connections, lock management, error handling, and debug options.
The following SQL command shows the number of PostgreSQL settings. Note that this number might differ slightly between different installations as well as customized settings:
postgres=# SELECT count(*) FROM pg_settings; count ------- 289(1 row)
The parameters can be as follows:
- Boolean: 0, 1, true, false, on, off, or any case-insensitive form of the previous values. ...