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