Setting GPDB Parameters in a Session

posted Sep 13, 2012, 1:17 PM by Sachchida Ojha
Any session parameter can also be set in an active database session using the SET command. That parameter setting is then valid for the rest of that session (or until a RESET command is issued). Settings at the session level override those at the role level. For example:

=# SET work_mem TO '200MB';
=# RESET work_mem;