Dear Tom,
Thanks for response,the exact issue which am facing is when there is no transaction queries are happening in database checkpointer and background writer is continuously utilizing memory from server.
Please guide me how fix this issue.
Regards,
Mohammed Afsar
Phone:+91 9676536225
On Tue, Aug 11, 2020, 8:58 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Mohammed Afsar <mohammed.afsar7799@xxxxxxxxx> 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
