Thread

1. maintenance_work_mem

   Atul Kumar <akumar14871@gmail.com> — 2020-11-19T08:05:22Z

   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
   
   
   
   

2. Re: maintenance_work_mem

   Andreas Schmitz <mailinglist@longimanus.net> — 2020-11-19T08:13:35Z

   https://www.postgresql.org/docs/13/sql-show.html
   
   https://www.postgresql.org/docs/13/sql-set.html
   
   
   Regards
   
   Andreas
   
   
   Am 11/19/2020 um 9:05 AM schrieb Atul Kumar:
   > 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
   >
   >
   
   
   
   

3. Re: maintenance_work_mem

   Philip Semanchuk <philip@americanefficient.com> — 2020-11-19T16:43:18Z

   
   > On Nov 19, 2020, at 3:05 AM, Atul Kumar <akumar14871@gmail.com> wrote:
   > 
   > 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.
   
   In addition to Andreas’ helpful references to SHOW and SET, there’s also pg_settings --
   
   https://www.postgresql.org/docs/13/view-pg-settings.html
   
   
   Cheers
   Philip