Re: vacuumdb causes memory drain. - Mailing list pgsql-admin

From Don Seiler
Subject Re: vacuumdb causes memory drain.
Date
Msg-id CAHJZqBCr0Xyp_58iXpknrTrXQFoYc3BPCqY8G0h-STzaMWLsqQ@mail.gmail.com
Whole thread Raw
In response to vacuumdb causes memory drain.  (Sushil Shirodkar <sushilps@hotmail.com>)
Responses Re: vacuumdb causes memory drain.  (Sushil Shirodkar <sushilps@hotmail.com>)
List pgsql-admin
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, and 
noticed that memory of the server goes down from 3.4GB free to 150MB.  Once 
the process is over, memory is not released, is it normal or something needs to be 
changed ? also other processes start running slow afterwards due to low memory.  

How are you measuring free memory? Memory might be listed in cached/buffers instead of free but is still available. Although that wouldn't then explain other processes being slow.

--
Don Seiler
www.seiler.us

pgsql-admin by date:

Previous
From: Sushil Shirodkar
Date:
Subject: vacuumdb causes memory drain.
Next
From: Sushil Shirodkar
Date:
Subject: Re: vacuumdb causes memory drain.