Hi,
The feed_posts table has over 50 Million rows.
When I m deleting all rows of a certain type that are over 60 days old.
When I try to do a delete like this: it hangs for an entire day, so I
need to kill it with pg_terminate_backend(pid).
DELETE FROM feed_posts
WHERE feed_definition_id = 'bf
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
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
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 , 11 Ara 2020 Cum
Hi Haseeb,
I had configured replication on windows and made a document in an easy way.
I am not expert but I hope it will help you.
Regards
Atul
On Tuesday, June 15, 2021, Haseeb Khan wrote:
> Hello Rory,
>
> Yes , I have followed the document and configured each and everything. But
> I
