This page in other versions: 9.2 / 9.3 / 9.4 / 9.5 / current (9.6)  |  Development versions: devel  |  Unsupported versions: 7.3 / 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4 / 9.0 / 9.1

5.4. Database Configuration

Recall from Section 3.4 that the PostgreSQL server provides a large number of run-time configuration variables. You can set database-specific default values for many of these settings.

For example, if for some reason you want to disable the GEQO optimizer for a given database, you'd ordinarily have to either disable it for all databases or make sure that every connecting client is careful to issue SET geqo TO off;. To make this setting the default you can execute the command

ALTER DATABASE mydb SET geqo TO off;

This will save the setting (but not set it immediately) and in subsequent connections it will appear as though SET geqo TO off; had been called right before the session started. Note that users can still alter this setting during the session; it will only be the default. To undo any such setting, use ALTER DATABASE dbname RESET varname;.

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group