| From: | Tang, Haiying/唐 海英 <tanghy(dot)fnst(at)fujitsu(dot)com> |
|---|---|
| To: | Fabrice Chapuis <fabrice636861(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | RE: Logical replication timeout problem |
| Date: | 2021-09-30 01:15:18 |
| Message-ID: | OS0PR01MB6113B93996BBA24F3B066474FBAA9@OS0PR01MB6113.jpnprd01.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Friday, September 24, 2021 12:04 AM, Fabrice Chapuis <fabrice636861(at)gmail(dot)com<mailto:fabrice636861(at)gmail(dot)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 | Content-Type | Size |
|---|---|---|
| run.sh | application/octet-stream | 821 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2021-09-30 02:12:21 | Re: Add some tests for pg_stat_statements compatibility verification under contrib |
| Previous Message | Justin Pryzby | 2021-09-30 00:43:41 | should frontend tools use syncfs() ? |