maintenance_work_mem

Atul Kumar <akumar14871@gmail.com>

From: Atul Kumar <akumar14871@gmail.com>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 2020-11-19T08:05:22Z
Lists: pgsql-general
Hi,

I have below queries:

1. How do i check the maintenance_work_mem for current session, before
setting some other value for this parameter for the same session.

2. and How do I set maintenance_work_mem for a session only, and how
will it be "rollback" once my maintainance work is done, Do I need to
execute any command for that or just closing the session will rollback
what I set for the session.


Please respond me query wise.



Regards,
Atul