public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tang, Haiying/唐 海英 <[email protected]>
To: Fabrice Chapuis <[email protected]>
To: Amit Kapila <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: RE: Logical replication timeout problem
Date: Thu, 30 Sep 2021 01:15:18 +0000
Message-ID: <OS0PR01MB6113B93996BBA24F3B066474FBAA9@OS0PR01MB6113.jpnprd01.prod.outlook.com> (raw)
In-Reply-To: <CAA5-nLCw26ih437yHnwg7NJxQ5LULVCXzF7_PwF3a0E2OYz58Q@mail.gmail.com>
References: <CAA5-nLARN7-3SLU_QUxfy510pmrYK6JJb=bk3hcgemAM_pAv+w@mail.gmail.com>
<CAA4eK1JLerufRV4Zr4h-vW4Fjz6LJjd-QZxVywpFrtfvZhXVWg@mail.gmail.com>
<CAA5-nLC0NKo1VsKgf+jEEH=5jGAN2pyCivyG59yX3bQcLSL4tg@mail.gmail.com>
<CAA4eK1KHQfnhmdnLZQrRoAW3dYOPqXKtT5C54HoBno3MCtH4wA@mail.gmail.com>
<CAA5-nLCH-XbCknSx2nVMtCByj8pv3jyRFQxL0qj4FLwby4TyNg@mail.gmail.com>
<CAA4eK1KrJP=oMOu5VJKn1uZjn+Xq110AGUxJpBrp3jN7vWXVPg@mail.gmail.com>
<CAA5-nLA8C0LZdVDdPDNeWcJYGzGVV3nJ7Ni0PdSyHJNxi628ww@mail.gmail.com>
<CAA4eK1LeN1V85i2ZfU2cOj5vJjpEVSvJ6LOfAu-u7mfQrW=v1Q@mail.gmail.com>
<CAA5-nLDhnKRwsPF8z5+ej4D9P9WTfVuMeVsigxuO=+sjf0ruyQ@mail.gmail.com>
<CAA4eK1JYB2eLNTs48szQ8oJXW9GLcrxT0yWETQS0gF2sVBxMYA@mail.gmail.com>
<CAA5-nLCs+XwLma7KPo_GJTKnhXU2YcTD9igMC8uDJV76xk72zQ@mail.gmail.com>
<CAA4eK1JxqfG3v3+E3i=iO5eNK9R8qH_XjZe=POEnW1pRkJ287Q@mail.gmail.com>
<CAA5-nLBPuCJuzAFWnp9ogLT769GsZgH4zTdnXaiUXZh4E3LHSg@mail.gmail.com>
<CAA4eK1Ji-1xCBhwK_obYNmsp5Jv0eCyzeuOqPbOMmkm0Y4K4fw@mail.gmail.com>
<CAA5-nLCw26ih437yHnwg7NJxQ5LULVCXzF7_PwF3a0E2OYz58Q@mail.gmail.com>
On Friday, September 24, 2021 12:04 AM, Fabrice Chapuis <[email protected]<mailto:[email protected]>> 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
Attachments:
[application/octet-stream] run.sh (821B, ../OS0PR01MB6113B93996BBA24F3B066474FBAA9@OS0PR01MB6113.jpnprd01.prod.outlook.com/3-run.sh)
download
view thread (56+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: RE: Logical replication timeout problem
In-Reply-To: <OS0PR01MB6113B93996BBA24F3B066474FBAA9@OS0PR01MB6113.jpnprd01.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox