> > > I'm worried about having this dependency in RI check, because the > > > planner > > may allow parallel INSERT in these cases in the future. > > > > If we support parallel insert that can have other modifications in the > > future, I think we will also be able to share or increment command ID > > in parallel wokers in that time. > > And it seems we can remove this dependency in that time. > > How about add some more comments about this to remind future > developer. > > /* > > * If extra parallel modification is support in the future, this > > dependency should be removed. > > */ > > Agreed. > > I'm excited to see PostgreSQL's parallel DML work in wider use cases and > satisfy users' expectations.
Thanks ! Attaching the first version patch which avoid CCI in RI trigger when insert into referencing table. Best regards, houzj
0001-Avoid-CCI-in-RI-trigger-when-INSERT-fk-relation.patch
Description: 0001-Avoid-CCI-in-RI-trigger-when-INSERT-fk-relation.patch
