vacuumdb causes memory drain.

From: Sushil Shirodkar <sushilps(at)hotmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: vacuumdb causes memory drain.
Date: 2018-04-26 15:31:01
Message-ID: BL0PR0102MB341015831D5ECBAF95D7966FD48E0@BL0PR0102MB3410.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Gurus,

Looking for some help, and if anybody has come across this type of scenario.

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.

O/S: Ubuntu VERSION="16.04.4 LTS (Xenial Xerus)"
PG : PostgreSQL 9.5.12
CPUs: 2
Memory:4GB
Swap:4GB

max_connections = 10
shared_buffers = 1GB
effective_cache_size = 3GB
maintenance_work_mem = 256MB
min_wal_size = 2GB
max_wal_size = 4GB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 4
effective_io_concurrency = 2
max_worker_processes = 2
work_mem = 104857kB

Thanks,
Sushil...

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Don Seiler 2018-04-26 15:33:27 Re: vacuumdb causes memory drain.
Previous Message Ron 2018-04-23 19:09:33 Re: Health checks after machine crash?