Re: vacuumdb causes memory drain.
| От | Sushil Shirodkar |
|---|---|
| Тема | Re: vacuumdb causes memory drain. |
| Дата | |
| Msg-id | BL0PR0102MB3410F730EA8CE5F0C2A19CACD48E0@BL0PR0102MB3410.prod.exchangelabs.com обсуждение исходный текст |
| Ответ на | Re: vacuumdb causes memory drain. (Don Seiler <don@seiler.us>) |
| Ответы |
Re: vacuumdb causes memory drain.
|
| Список | pgsql-admin |
I have put some small script which runs in a loop with "free -h" command,
while I am running "vacuumdb". Once I clear by "sync" or bounce PG,
everything runs normal afterward.
From: Don Seiler <don@seiler.us>
Sent: Thursday, April 26, 2018 11:33 AM
To: Sushil Shirodkar
Cc: pgsql-admin@postgresql.org
Subject: Re: vacuumdb causes memory drain.
Sent: Thursday, April 26, 2018 11:33 AM
To: Sushil Shirodkar
Cc: pgsql-admin@postgresql.org
Subject: Re: vacuumdb causes memory drain.
On Thu, Apr 26, 2018 at 10:31 AM, Sushil Shirodkar <sushilps@hotmail.com> wrote:
Running "vacuumdb -a -z -v" from the cron on one of our test environment, andnoticed that memory of the server goes down from 3.4GB free to 150MB. Oncethe process is over, memory is not released, is it normal or something needs to bechanged ? also other processes start running slow afterwards due to low memory.
Don Seiler
www.seiler.us
www.seiler.us
В списке pgsql-admin по дате отправления: