From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mohammed Afsar <mohammed.afsar7799@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Postgresql background writer and checkpointer memory utilization in Linux server
Date: Tue, 11 Aug 2020 11:28:05 -0400
Message-ID: <3398104.1597159685@sss.pgh.pa.us> (raw)
In-Reply-To: <CA+s2FCOB-HKRf9G2KeB66arqTUQjKbKfJLa7D3P8wPoxwXd00Q@mail.gmail.com>
References: <CA+s2FCOB-HKRf9G2KeB66arqTUQjKbKfJLa7D3P8wPoxwXd00Q@mail.gmail.com>
Mohammed Afsar <mohammed.afsar7799@gmail.com> writes:
> How to reduce to take less memory checkpointer and background writer with
> faster database performance?
What makes you think that either of them is a problem?
> This two components parameters disable is recommended on production
> environments?
There is no way to disable them, and you would not like the results if
you could.
Neither one (especially not the bgwriter) should have any significant
amount of private memory. Tools such as "top" will probably tell you
they are using 32GB plus, but that's just reflecting the fact that
they've scanned all of shared_buffers. If your system is actually
under too much memory pressure, you might want to dial shared_buffers
down to a smaller fraction of RAM ... but you've not shown us any reason
to think that you have a problem to solve, much less that that'd be a
solution.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, mohammed.afsar7799@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Postgresql background writer and checkpointer memory utilization in Linux server
In-Reply-To: <3398104.1597159685@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox