Postgresql background writer and checkpointer memory utilization in Linux server

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

 




Dear Team, 

How to reduce to take less memory checkpointer and background writer with faster database performance?

This two components parameters disable is recommended on production environments?

How to reduce pg_dum memory utilization and pg_dump is going take reserved database memory or differently it will take(including shared buffer memory or).

Server/database current configuration:
RAM:128gb
CPU:24
Database size:5TB
Max_wal_size=7Gb
Checkpoint_completion_target=0.9
Wal_buffers=-1
Shared_buffers=32GB
Temp_buffers=8mb
Work_mem=5GB
Effective io concurrency=300
Max worker process=24
Max parallel worker per gather =12
Max parallel  worker =24

Regards,
Mohammed Afsar 
Phone:+91 9676536225


[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