> On Dec 11, 2020, at 06:34, Atul Kumar wrote:
>
> What do you mean by “how much wal is created”
> How total Wal files in size or how much total wal files in numbers.
Since WAL segment files are a fixed size (almost always 16MB), those numbers
are directly related.
--
-- Christophe Pettus
>> > On Fri, 2020-12-11 at 13:42 +0530, Atul Kumar wrote:
>> >> We are getting this alert frequently "Required checkpoints occurs too
>> >> frequently" on postgres version 11.8
>> >>
>> >> The RAM of the server is 16 GB.
&g
13:42 +0530, Atul Kumar wrote:
> >> We are getting this alert frequently "Required checkpoints occurs too
> >> frequently" on postgres version 11.8
> >>
> >> The RAM of the server is 16 GB.
> >>
> >> and we have already set the m
how much size should I increase in "max_wal_size".
Do we need to change any other parameter's value also ?
Regards,
Atul
On 12/11/20, Laurenz Albe wrote:
> On Fri, 2020-12-11 at 13:42 +0530, Atul Kumar wrote:
>> We are getting this alert frequently "Re
On Fri, 2020-12-11 at 13:42 +0530, Atul Kumar wrote:
> We are getting this alert frequently "Required checkpoints occurs too
> frequently" on postgres version 11.8
>
> The RAM of the server is 16 GB.
>
> and we have already set the max_wal_size= 4096 MB
> mi
Hi,
We are getting this alert frequently "Required checkpoints occurs too
frequently" on postgres version 11.8
The RAM of the server is 16 GB.
and we have already set the max_wal_size= 4096 MB
min_wal_size= 192 MB.
Please help me in optimizing the same to avoid this alert.
Regards,
Atul
