| From: | RECHTÉ Marc <marc(dot)rechte(at)meteo(dot)fr> |
|---|---|
| To: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> |
| Cc: | Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Logical replication timeout |
| Date: | 2024-12-27 09:30:30 |
| Message-ID: | 386338158.218606011.1735291830165.JavaMail.zimbra@meteo.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Right, because of the reason I posted [1].
>
> I updated the patch which did the same approach. It could pass my CI.
> Could you please apply on 17.2 and test it?
>
> [1]:
> https://www.postgresql.org/message-id/OSCPR01MB14966B646506E0C9B81B3A4CFF5022%40OSCPR01MB14966.jpnprd01.prod.outlook.com
This is a considerable improvement, the cleanup phase took less than 30s (compared to the former 200s).
However, we are talking of a 12s transaction, that takes an overall 64s to be replicated.
In this particular case, the replication system spends most of its time creating / deleting small files.
Would not be possible to create just one spill file for the main transaction ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hayato Kuroda (Fujitsu) | 2024-12-27 09:48:33 | RE: Logical Replication of sequences |
| Previous Message | Heikki Linnakangas | 2024-12-27 09:19:27 | Re: pure parsers and reentrant scanners |