Postgres Pro
Downloads
Home   >   mailing lists

Postgresql background writer and checkpointer memory utilization in Linux server - Mailing list pgsql-admin

From Mohammed Afsar
Subject Postgresql background writer and checkpointer memory utilization in Linux server
Date
Msg-id CA+6HduvjhUB_qB2cS2LJ8oN_LBRTnwuvZnAipdphJ_MDuJQygg@mail.gmail.com
Whole thread Raw
In response to Postgresql background writer and checkpointer memory utilization in Linux server  (Mohammed Afsar <vmdapsar@gmail.com>)
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Mohammed Afsar
Date:
Subject: Postgresql background writer and checkpointer memory utilization in Linux server
Next
From: Don Seiler
Date:
Subject: Re: Recovery from WAL archives not advancing timeline?