From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Sushil Shirodkar <sushilps@hotmail.com>
Cc: Don Seiler <don@seiler.us>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: vacuumdb causes memory drain.
Date: Fri, 27 Apr 2018 14:39:47 +0200
Message-ID: <1524832787.2467.23.camel@cybertec.at> (raw)
In-Reply-To: <BL0PR0102MB34107A22DE7B824C8CBDBF4DD48D0@BL0PR0102MB3410.prod.exchangelabs.com>
References: <BL0PR0102MB341015831D5ECBAF95D7966FD48E0@BL0PR0102MB3410.prod.exchangelabs.com>
<CAHJZqBCr0Xyp_58iXpknrTrXQFoYc3BPCqY8G0h-STzaMWLsqQ@mail.gmail.com>
<BL0PR0102MB3410F730EA8CE5F0C2A19CACD48E0@BL0PR0102MB3410.prod.exchangelabs.com>
<1524809191.2382.4.camel@cybertec.at>
<BL0PR0102MB34107A22DE7B824C8CBDBF4DD48D0@BL0PR0102MB3410.prod.exchangelabs.com>
Sushil Shirodkar wrote:
> > > > > 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.
> > >
> > > 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?
> >
> Performance issue.
>
> Can I restrict memory usage at session level in the script where I run
> Vacuum DB ?
Could you please bottom-post?
Once vacuumdb is done, the associated backend process is gone too, so
it cannot consume any memory.
Try to figure out which process consumes your memory.
What do you get for free -h?
How did you configure shared_buffers and maintenance_work_mem?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, sushilps@hotmail.com, don@seiler.us
Subject: Re: vacuumdb causes memory drain.
In-Reply-To: <1524832787.2467.23.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox