maintenance_work_mem - Mailing list pgsql-general

From Atul Kumar
Subject maintenance_work_mem
Date
Msg-id CA+ONtZ6b2rGfKUnRcQVtg7DMPX7QGPfB=-eYUjJcBpDcp=vSDg@mail.gmail.com
Whole thread Raw
Responses Re: maintenance_work_mem
Re: maintenance_work_mem
List 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



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: \COPY command and indexes in tables
Next
From: Andreas Schmitz
Date:
Subject: Re: maintenance_work_mem