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

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Mohammed Afsar <mohammed(dot)afsar7799(at)gmail(dot)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
>