From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Sushil Shirodkar <sushilps(at)hotmail(dot)com>, Don Seiler <don(at)seiler(dot)us> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: vacuumdb causes memory drain. |
Date: | 2018-04-27 06:06:31 |
Message-ID: | 1524809191.2382.4.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Sushil Shirodkar wrote:
> > On Thu, Apr 26, 2018 at 10:31 AM, Sushil Shirodkar <sushilps(at)hotmail(dot)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.
>
> 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.
Then I would say everything is fine.
It is normal for a Linux system to have almost no free memory; the memory is used
for the file system cache.
Do you experience any problems, like reduced performance or high I/O?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
From | Date | Subject | |
---|---|---|---|
Next Message | Sushil Shirodkar | 2018-04-27 10:40:35 | Re: vacuumdb causes memory drain. |
Previous Message | David G. Johnston | 2018-04-27 03:50:07 | Re: pg_restore dumps all data to the terminal |