maintenance_work_mem

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: maintenance_work_mem
Date: 2020-11-19 08:05:22
Message-ID: CA+ONtZ6b2rGfKUnRcQVtg7DMPX7QGPfB=-eYUjJcBpDcp=vSDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Schmitz 2020-11-19 08:13:35 Re: maintenance_work_mem
Previous Message Laurenz Albe 2020-11-19 07:57:33 Re: \COPY command and indexes in tables