Any session parameter can be set in an active database session using the SET command. For example:

    1. =# 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:

    1. =# RESET statement_mem;

    Settings at the session level override those at the role level.

    Parent topic: Setting a Master Configuration Parameter