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.
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.
