| From: | Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> |
|---|---|
| To: | Alexander Lakhin <exclusion(at)gmail(dot)com> |
| Cc: | Álvaro Herrera <alvherre(at)kurilemu(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>, Noah Misch <noah(at)leadboat(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY |
| Date: | 2026-01-25 18:39:00 |
| Message-ID: | CADzfLwWZjWqeX6fF5=iKq_PJiw7G+k01CBu5xB8X_Z+nN1gqqA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello, Álvaro!
Fixes are in attachment. I think the comment message and comments are good
enough to explain the changes.
Also, the second commit adds syscache for pg_inherites. I am not very
confident with it, but it feels correct to me.
Another approach - put information about parents into - I can rebuild the
patch that way.
Also, for the first commit it is possible to create a batched version of
get_partition_ancestors (with the same snapshot for multiple indexes).
Best regards,
Mikhail.
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0002-Add-syscache-for-pg_inherits-lookups.patch | application/octet-stream | 6.6 KB |
| v1-0001-Fix-duplicate-arbiter-detection-during-REINDEX-CO.patch | application/octet-stream | 5.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2026-01-25 20:06:12 | Re: Make copyObject work in C++ |
| Previous Message | Jelte Fennema-Nio | 2026-01-25 17:52:37 | Re: Make copyObject work in C++ |