Re: checkpoint and recovering process use too much memory

From: lazaro garcia <lazaro3487(at)gmail(dot)com>
To: Ashok Kumar Tiwari <ashokt(at)ohumhealthcare(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: checkpoint and recovering process use too much memory
Date: 2020-10-07 21:16:56
Message-ID: CAM+GE8cJYdTw49oKStD6X+FRCG4hpV-cNrE2oqeWm-50ZLoArA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

How are these parameters configured on your server,
*checkpoint_timeout, * *max_wal_size
and * *checkpoint_completion_target?*

*Regards.*

El mar., 6 oct. 2020 a las 12:28, Ashok Kumar Tiwari (<
ashokt(at)ohumhealthcare(dot)com>) escribió:

> Dear community Team,
>
> i am using streaming replication my standby db checkpoint and recovering
> process use too much memory .
> how can i reduce it please help me it's very urgent.
>
> --
> Ashok Kumar Tiwari,
> Senior Technical Consultant,
> ashokt(at)ohumhealthcare(dot)com,
> *M*:+91-9657628833
>
>
> [image: http://www.blystreecare.com/images/tree-clipart-4.gif] Save a
> tree. Please avoid printing this email unless necessary.
>
> ***** Email confidentiality notice *****
>
> This message is private and confidential. If you have received this
> message in error, please notify us and remove it from your system.
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message lennam 2020-10-08 12:31:32 Re: How to return multiple rows by stored procedure in postgresql
Previous Message Henry Francisco Garcia Cortez 2020-10-07 14:18:32 Re: pgagent