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