Menu

Session_parameters:_SET,_DISCARD,_RESET

Michael Paquier
There is a newer version of this page. You can find it here.

Synopsis Enters in this spec the following SQL commands:

* SET [LOCAL/ROLE/SESSION/etc.]
* DISCARD
* RESET

Session parameters are necessary in PostgreSQL to be able to configure the session user is on. For example, search_patch helps to define on which schema to refer when looking for relations. Other parameters permit to customize the server time-line or connection timeout.

Spec details Postgres-XC, being a shared nothing cluster, makes its connections interact with each other thanks to a connection pooling located at Coordinator. This connection pooling is in charge of Coordinator