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
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
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
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
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
