| From: | cca5507 <2624345507(at)qq(dot)com> |
|---|---|
| To: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: could sent_lsn be lower than write/flush/replay_lsn? |
| Date: | 2025-12-27 07:47:32 |
| Message-ID: | tencent_4A291FF4D8E985EA1622D742A410C814E00A@qq.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Jaime,
The $subject can happen during logical replication start, it's just fine.
> 2025-12-26 12:17:41.861 -05 [pid=2667517;l=1;tx=0] LOG: 38B7/CEBC9330
> has been already streamed, forwarding to 38B7/D2C9C038
The logical replica requests starting at 38B7/CEBC9330, but the slot's confirmed_flush_lsn
is at 38B7/D2C9C038, so forwarding to it.
> 2025-12-26 12:17:41.867 -05 [pid=2667517;l=4;tx=0] DETAIL: Streaming
> transactions committing after 38B7/D2C9C038, reading WAL from
> 38B0/2261B890.
The publisher must read WAL from the slot's restart_lsn (38B0/2261B890), but only
transactions committed after 38B7/D2C9C038 will be sent to the logical replica.
The sent_lsn is just where the wal sender currently reading, so it could be lower than
write/flush/replay_lsn.
Hope this can answer your question.
--
Regards,
ChangAo Chen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2025-12-27 07:52:28 | Re: proposal: schema variables |
| Previous Message | zengman | 2025-12-27 04:58:43 | Re:Question about partial index WHERE clause predicate ordering |