RE: Logical replication timeout problem - Mailing list pgsql-hackers

From Tang, Haiying/唐 海英
Subject RE: Logical replication timeout problem
Date
Msg-id OS0PR01MB6113B93996BBA24F3B066474FBAA9@OS0PR01MB6113.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Logical replication timeout problem  (Fabrice Chapuis <fabrice636861@gmail.com>)
Responses Re: Logical replication timeout problem  (Fabrice Chapuis <fabrice636861@gmail.com>)
List pgsql-hackers

On Friday, September 24, 2021 12:04 AM, Fabrice Chapuis <fabrice636861@gmail.com> wrote:

>

> Thanks for your patch, we are going to set up a lab in order to debug the function.

 

Hi

 

I tried to reproduce this timeout problem on version10.18 but failed.

In my trial, I inserted large amounts of data at publisher, which took more than 1 minute to replicate.

And with the patch provided by Amit, I saw that the frequency of invoking

WalSndKeepaliveIfNecessary function is raised after I inserted data.

 

The test script is attached. Maybe you can try it on your machine and check if this problem could happen.

If I miss something in the script, please let me know.

Of course, it will be better if you can provide your script to reproduce the problem.

 

Regards

Tang

Attachment

pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: should frontend tools use syncfs() ?
Next
From: Michael Paquier
Date:
Subject: Re: Add some tests for pg_stat_statements compatibility verification under contrib