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
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
> min_wal_size= 192 MB.
You should increas
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 "Required checkpoints occurs too
>> frequent
it depends on your cluster environment. you need to know how much wal is
created in checkpoint_timeout duration. for example your
checkpoint_timeout = 30 min, you need to measure how much wal is created in
30 minute. and then you can increase max_wal_size according to this size.
Atul Kumar , 1
What do you mean by “how much wal is created”
How total Wal files in size or how much total wal files in numbers.
Please let me know.
Regards
Atul
On Friday, December 11, 2020, Amine Tengilimoglu <
aminetengilimo...@gmail.com> wrote:
> it depends on your cluster environment. you need to kn
> 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
