| From: | "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com> |
|---|---|
| To: | shveta malik <shveta(dot)malik(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Nisha Moond <nisha(dot)moond412(at)gmail(dot)com> |
| Subject: | RE: Follow-up review items for update_deleted |
| Date: | 2026-09-04 02:12:07 |
| Message-ID: | TY4PR01MB177181ED86AA94890175051ED94B52@TY4PR01MB17718.jpnprd01.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thursday, September 3, 2026 9:57 PM shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
>
> The patch 001 looks good to me. I had just one comment which I noticed
> Kuroda-San has already covered.
Thanks for the comments.
>
> ReplicationSlotMarkDirty();
> ReplicationSlotSave();
> These calls are only needed if xmin is adjusted.
Changed.
> --
>
> Now, the better names for 'init_conflict_slot_xmin' could be:
> adjust_conflict_slot_xmin, refresh_conflict_slot_xmin.
>
I chose Kuroda-San's version in this version.
> --
>
> Also would it be better if we change elog to:
>
> if (!TransactionIdIsValid(old_xmin))
> elog(DEBUG1, "initialized conflict detection slot's xmin to %u", xmin_horizon);
> else elog(DEBUG1, "adjusted conflict detection slot's xmin from %u to %u",
> old_xmin, xmin_horizon);
I added a single elog(DEBUG without an if condition to keep it simple.
Users can already see the history from the log anyway.
Apart from above comments, I also addressed comments from Kuroda-San[1] and
Nisha[2].
[1] https://www.postgresql.org/message-id/OS9PR01MB1214975F154718013E1B82D4AF5B62%40OS9PR01MB12149.jpnprd01.prod.outlook.com
[2] https://www.postgresql.org/message-id/CABdArM7nwKpoVQ5v42xz6D-qAVrNGdb%2ByMUGmSR8Tapv%3DmFzDw%40mail.gmail.com
Best Regards,
Zhijie Hou
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Re-initialize-conflict-slot-xmin-when-a-database-new.patch | application/octet-stream | 11.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ewan Young | 2026-09-04 02:38:00 | Re: FOR PORTION OF silently ignored on views with DO INSTEAD rules |
| Previous Message | Richard Guo | 2026-09-04 01:50:18 | Re: Assert failure in try_nestloop_path() |