Session_parameters:_SET,_DISCARD,_RESET

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