Обсуждение: Postgresql background writer and checkpointer memory utilization in Linux server
Postgresql background writer and checkpointer memory utilization in Linux server
От
Mohammed Afsar
Дата:
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
Postgresql background writer and checkpointer memory utilization in Linux server
От
Mohammed Afsar
Дата:
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:128gbCPU:24Database size:5TBMax_wal_size=7GbCheckpoint_completion_target=0.9Wal_buffers=-1Shared_buffers=32GBTemp_buffers=8mbWork_mem=5GBEffective io concurrency=300Max worker process=24Max parallel worker per gather =12Max parallel worker =24Regards,Mohammed AfsarPhone:+91 9676536225