Setting Parameters in a Session
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.
Setting Parameters in a Session
Any session parameter can be set in an active database session using the SET command. For example:
=# SET statement_mem TO '200MB';
The parameter setting is valid for the rest of that session or until you issue a RESET command. For example:
=# RESET statement_mem;
Settings at the session level override those at the role level.