Due to 39e726819f75e13, a resourc group is not assigned for
SET/SHOW command which means GUC memory_spill_ratio will
stay unchanged even you set current role to another role.

SET/SHOW commands are not meant to use memory_spill_ratio,
so it should be safe to keep memory_spill_ratio until a non
SET/SHOW command is executed.