pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Sushil Shirodkar <sushilps@hotmail.com>
Cc: don@seiler.us <don@seiler.us>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: vacuumdb causes memory drain.
Date: Mon, 30 Apr 2018 07:43:03 +0200
Message-ID: <1525066983.2466.5.camel@cybertec.at> (raw)
In-Reply-To: <55DDA52C-9FA1-47FF-9E96-264A8522E7A1@hotmail.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>
	<1524832787.2467.23.camel@cybertec.at>
	<55DDA52C-9FA1-47FF-9E96-264A8522E7A1@hotmail.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.  
>
> Process which was running close to 99% memory was
>  "/usr/lib/postgresql/9.5/bin/postgres -D /var/lib/postgresql/9.5/main -c config_file=/etc/postgresql/9.5/main/postgresql.conf"
> 
> free -h - was showing between 100-150 mb free. 
> 
> shared_buffers = 1GB
> maintenance_work_mem = 256MB

Can you share the "free -h" output?

What do you get for
ps -p <postmaster PID> -o rss,trs,drs,vsz,%mem
if you substitute the postmaster's process ID?

If you say that "sync" restored normal behavior, are you implying that there
was a high I/O load?

Still trying to figure out what exactly you are experiencing.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




view thread (9+ messages)  latest in thread

Message-ID: <1525066983.2466.5.camel@cybertec.at>
Permalink:  ../1525066983.2466.5.camel@cybertec.at/
Also on:    postgresql.org/message-id/1525066983.2466.5.camel@cybertec.at

 · 

reply
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: <1525066983.2466.5.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