Postgresql background writer and checkpointer memory utilization in Linux server

Поиск
Список
Период
Сортировка
От Mohammed Afsar
Тема Postgresql background writer and checkpointer memory utilization in Linux server
Дата
Msg-id CA+6HduvjhUB_qB2cS2LJ8oN_LBRTnwuvZnAipdphJ_MDuJQygg@mail.gmail.com
обсуждение исходный текст
Ответ на Postgresql background writer and checkpointer memory utilization in Linux server  (Mohammed Afsar <vmdapsar@gmail.com>)
Список pgsql-admin

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 по дате отправления:

Предыдущее
От: Mohammed Afsar
Дата:
Сообщение: Postgresql background writer and checkpointer memory utilization in Linux server
Следующее
От: Don Seiler
Дата:
Сообщение: Re: Recovery from WAL archives not advancing timeline?