Re: Postgresql background writer and checkpointer memory utilization in Linux server

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