vacuumdb causes memory drain.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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...


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux