ATTACH PARTITION cost grows linearly with pg_constraint size (seqscan in CloneFkReferenced), much worse since not-null constraints are in pg_constraint (PG 18)
3 patchsets tracked - current t253993_10
v10t253993_10posted Oct 02, 20:03successappliesrecent 0dpg 20
basef2edf5dd0 about 18 hours ago on master
applyapplied about 16 hours ago
rebaselast tried about 16 hours ago on f2edf5dd0
pushabout 16 hours ago -> 2e23cb2b3branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1049 / 1049 | 2m 49s / 4m 52s | docker run ... :t253993 | about 15 hours ago |
run 39723185067executed 1049 - ccache 78 hit / 6544 miss - head 2e23cb2b3 - digest sha256:742b28a9b3c3ae... - run 39723185067 | ||||||
| success | 1 | 20 | 1049 / 1049 | 3m 01s / 5m 34s | docker run ... @sha256:59b6b8b... | 1 day ago |
run 39544736306executed 1049 - ccache 78 hit / 6544 miss - head be418599b - digest sha256:59b6b8b2a91274... - run 39544736306 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 33s / 4m 29s | docker run ... @sha256:73f37f2... | 3 days ago |
run 39368656905executed 1049 - ccache 78 hit / 6544 miss - head d873dae0a - digest sha256:73f37f2f1fdd31... - run 39368656905 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 55s / 5m 28s | docker run ... @sha256:a3efd2b... | 4 days ago |
run 39197820219executed 1049 - ccache 78 hit / 6544 miss - head d83852209 - digest sha256:a3efd2b7fd20f5... - run 39197820219 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 43s / 5m 01s | docker run ... @sha256:d809db7... | 5 days ago |
run 39070076398executed 1049 - ccache 78 hit / 6544 miss - head 38ba058bb - digest sha256:d809db7780d346... - run 39070076398 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 53s / 5m 34s | docker run ... @sha256:ebba3ca... | 6 days ago |
run 38967817058executed 1049 - ccache 78 hit / 6544 miss - head 36a316d9b - digest sha256:ebba3ca6668eaa... - run 38967817058 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 52s / 5m 14s | docker run ... @sha256:8325b8a... | 7 days ago |
run 38808054077executed 1049 - ccache 78 hit / 6544 miss - head ac0976bac - digest sha256:8325b8a4e4cb61... - run 38808054077 | ||||||
| success | 1 | 20 | 1047 / 1047 | 2m 53s / 5m 28s | docker run ... @sha256:93db18c... | Oct 14, 21:16 |
run 38637469563executed 1047 - ccache 78 hit / 6544 miss - head 02eb36c07 - digest sha256:93db18c07e15dd... - run 38637469563 | ||||||
| success | 1 | 20 | 1044 / 1044 | 2m 52s / 5m 23s | docker run ... @sha256:d390673... | Oct 13, 21:05 |
run 38466518259executed 1044 - ccache 78 hit / 6544 miss - head 1a23f3df9 - digest sha256:d390673568f4a6... - run 38466518259 | ||||||
| success | 1 | 20 | 1044 / 1044 | 1m 50s / 4m 01s | docker run ... @sha256:8e25944... | Oct 12, 20:54 |
run 38306360816executed 1044 - ccache 78 hit / 6544 miss - head 5d50c4570 - digest sha256:8e2594429da76b... - run 38306360816 | ||||||
| success | 1 | 20 | 1044 / 1044 | 2m 54s / 5m 34s | docker run ... @sha256:c8a1081... | Oct 11, 20:22 |
run 38171147801executed 1044 - ccache 78 hit / 6544 miss - head bb4fbd4f4 - digest sha256:c8a10811802df2... - run 38171147801 | ||||||
| success | 1 | 20 | 1044 / 1044 | 2m 54s / 5m 32s | docker run ... @sha256:46cd687... | Oct 10, 20:21 |
run 38082722465executed 1044 - ccache 78 hit / 6544 miss - head 50b726843 - digest sha256:46cd687b96c54a... - run 38082722465 | ||||||
| success | 1 | 20 | 1043 / 1043 | 2m 55s / 5m 23s | docker run ... @sha256:13c022e... | Oct 09, 20:21 |
run 37985201258executed 1043 - ccache 78 hit / 6544 miss - head 945fe65d6 - digest sha256:13c022ed00ebe3... - run 37985201258 | ||||||
| success | 1 | 20 | 1042 / 1042 | 2m 44s / 5m 25s | docker run ... @sha256:0f4b79d... | Oct 08, 20:20 |
run 37837379861executed 1042 - ccache 78 hit / 6544 miss - head 7c959e88b - digest sha256:0f4b79d8da5179... - run 37837379861 | ||||||
| success | 1 | 20 | 1042 / 1042 | 2m 49s / 5m 26s | docker run ... @sha256:8cbcc5c... | Oct 07, 20:19 |
run 37679837398executed 1042 - ccache 78 hit / 6544 miss - head 82195260f - digest sha256:8cbcc5c3134ceb... - run 37679837398 | ||||||
| success | 1 | 20 | 1040 / 1040 | 2m 52s / 5m 07s | docker run ... @sha256:629d024... | Oct 06, 20:19 |
run 37524201274executed 1040 - ccache 78 hit / 6544 miss - head da5f66435 - digest sha256:629d02460f041a... - run 37524201274 | ||||||
| infra error | 1 | - | - | - | - | Oct 05, 20:37 |
run 37367732012head f56cf577d - run 37367732012 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 12s / 4m 31s | docker run ... @sha256:77cf685... | Oct 04, 20:15 |
run 37230830013executed 1039 - ccache 78 hit / 6544 miss - head 99559801b - digest sha256:77cf68537ff807... - run 37230830013 | ||||||
| success | 1 | 20 | 1039 / 1039 | 1m 46s / 4m 03s | docker run ... @sha256:cd44282... | Oct 03, 20:12 |
run 37150244690executed 1039 - ccache 78 hit / 6544 miss - head c092b05cf - digest sha256:cd44282631ed57... - run 37150244690 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 53s / 5m 16s | docker run ... @sha256:cb5d87f... | Oct 02, 20:14 |
run 37058163033executed 1039 - ccache 78 hit / 6544 miss - head ce40839a0 - digest sha256:cb5d87f0eb1c30... - run 37058163033 | ||||||
v6t253993_6posted Sep 29, 18:02successsupersededrecent 21dpg 20
base42e96cf2f Oct 01, 13:19 on master
applyapplied Oct 01, 18:05
rebaselast tried Oct 02, 18:05 on 6f3bdadaa
Applying: Index pg_constraint.confrelid to avoid seqscans in partition DDL Using index info to reconstruct a base tree... M src/include/catalog/catversion.h Falling back to patching base and 3-way merge... Auto-merging src/include/catalog/catversion.h CONFLICT (content): Merge conflict in src/include/catalog/catversion.h Patch failed at 0001 Index pg_constraint.confrelid to avoid seqscans in partition DDL error: Failed to merge in the changes. hint: Use 'git am --show-current-patch=diff' to see the failed patch hint: When you have resolved this problem, run "git am --continue". hint: If you prefer to skip this patch, run "git am --skip" instead. hint: To restore the original branch and stop patching, run "git am --abort". hint: Disable this message with "git config advice.mergeConflict false"
conflicts on master: src/include/catalog/catversion.h
pushOct 01, 18:05 -> 2b8f16315branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1039 / 1039 | 2m 16s / 4m 41s | docker run ... @sha256:5ef2005... | Oct 01, 18:15 |
run 36904211302executed 1039 - ccache 78 hit / 6544 miss - head 2b8f16315 - digest sha256:5ef2005cf57598... - run 36904211302 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 46s / 4m 40s | docker run ... @sha256:f1c95d9... | Sep 30, 18:14 |
run 36755938586executed 1039 - ccache 78 hit / 6544 miss - head f2553d851 - digest sha256:f1c95d906eecc6... - run 36755938586 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 48s / 5m 22s | docker run ... @sha256:d307f74... | Sep 29, 18:14 |
run 36609321647executed 1039 - ccache 78 hit / 6544 miss - head 0a2001f42 - digest sha256:d307f74fe8fa30... - run 36609321647 | ||||||
v4t253993_4posted Sep 29, 16:08successsupersededrecent 23dpg 20
basedca6a9e32 Sep 29, 15:11 on master
applyapplied Sep 29, 16:10
rebaselast tried Sep 29, 16:10 on dca6a9e32
pushSep 29, 16:10 -> dfb0a5930branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1039 / 1039 | 2m 22s / 4m 15s | docker run ... @sha256:67dd0b3... | Sep 29, 16:20 |
run 36595823798executed 1039 - ccache 78 hit / 6544 miss - head dfb0a5930 - digest sha256:67dd0b30abdc72... - run 36595823798 | ||||||