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; |