Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements
6 patchsets tracked - current t48907_126
v126t48907_126posted about 9 hours agosuccessappliesrecent 0dpg 20
base5ffb8c740 about 12 hours ago on master
applyapplied about 9 hours ago
rebaselast tried about 9 hours ago on 5ffb8c740
pushabout 9 hours ago -> 314882010branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1053 / 1053 | 2m 02s / 4m 41s | docker run ... :t48907 | about 9 hours ago |
run 39770580298executed 1053 - ccache 78 hit / 6545 miss - head 314882010 - digest sha256:7ba013e4c671fe... - run 39770580298 | ||||||
v125t48907_125posted 5 days agosuccesssupersededstale 3mopg 20
base011bbdb42 Aug 05, 02:29 - 78 days / 780 commits behind master (from history)
applyapplied 5 days ago
rebaselast tried 5 days ago on 45fc51fcb
Applying: Track and drop auxiliary indexes in DROP/REINDEX Using index info to reconstruct a base tree... M src/backend/catalog/dependency.c M src/backend/catalog/index.c M src/backend/catalog/toasting.c M src/backend/commands/indexcmds.c M src/backend/commands/tablecmds.c M src/include/catalog/dependency.h M src/include/nodes/execnodes.h M src/test/recovery/meson.build Falling back to patching base and 3-way merge... Auto-merging src/test/recovery/meson.build CONFLICT (content): Merge conflict in src/test/recovery/meson.build Auto-merging src/include/nodes/execnodes.h Auto-merging src/include/catalog/dependency.h Auto-merging src/backend/commands/tablecmds.c Auto-merging src/backend/commands/indexcmds.c Auto-merging src/backend/catalog/toasting.c Auto-merging src/backend/catalog/index.c Auto-merging src/backend/catalog/dependency.c Patch failed at 0001 Track and drop auxiliary indexes in DROP/REINDEX 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/test/recovery/meson.build
push5 days ago -> 620bb8526branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1021 / 1021 | 2m 59s / 5m 38s | docker run ... @sha256:fdeefa8... | 5 days ago |
run 39056284665executed 1021 - ccache 166 hit / 6453 miss - head 620bb8526 - digest sha256:fdeefa88496c38... - run 39056284665 | ||||||
v124t48907_124posted Aug 08, 15:03successsupersededstale 57dpg 20
baseedc095a26 Aug 26, 09:59 on master
applyapplied Aug 26, 13:01
rebaselast tried Sep 24, 19:01 on 7a7f60616
Applying: Track and drop auxiliary indexes in DROP/REINDEX Using index info to reconstruct a base tree... M src/backend/catalog/dependency.c M src/backend/catalog/index.c M src/backend/catalog/toasting.c M src/backend/commands/indexcmds.c M src/backend/commands/tablecmds.c M src/include/catalog/dependency.h M src/include/nodes/execnodes.h M src/test/recovery/meson.build Falling back to patching base and 3-way merge... Auto-merging src/test/recovery/meson.build CONFLICT (content): Merge conflict in src/test/recovery/meson.build Auto-merging src/include/nodes/execnodes.h Auto-merging src/include/catalog/dependency.h Auto-merging src/backend/commands/tablecmds.c Auto-merging src/backend/commands/indexcmds.c Auto-merging src/backend/catalog/toasting.c Auto-merging src/backend/catalog/index.c Auto-merging src/backend/catalog/dependency.c Patch failed at 0001 Track and drop auxiliary indexes in DROP/REINDEX 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/test/recovery/meson.build
pushAug 26, 13:01 -> ded31efe0branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1027 / 1027 | 2m 59s / 5m 24s | docker run ... @sha256:4346be0... | Aug 26, 13:14 |
run 32971815919executed 1027 - ccache 98 hit / 6526 miss - head ded31efe0 - digest sha256:4346be0c9727ba... - run 32971815919 | ||||||
| success | 1 | 20 | 1027 / 1027 | 2m 54s / 5m 47s | docker run ... @sha256:813cbc6... | Aug 25, 13:04 |
run 32849945440executed 1027 - ccache 98 hit / 6526 miss - head 705b2e2d7 - digest sha256:813cbc614d075f... - run 32849945440 | ||||||
| success | 1 | 20 | 1026 / 1026 | 2m 15s / 4m 39s | docker run ... @sha256:9451b02... | Aug 24, 12:58 |
run 32729164270executed 1026 - ccache 98 hit / 6526 miss - head ceb8e89e3 - digest sha256:9451b023035afc... - run 32729164270 | ||||||
| success | 1 | 20 | 1026 / 1026 | 2m 54s / 5m 22s | docker run ... @sha256:b9d6dcb... | Aug 23, 12:58 |
run 32640421829executed 1026 - ccache 98 hit / 6526 miss - head 3347aa02d - digest sha256:b9d6dcba411a40... - run 32640421829 | ||||||
| success | 1 | 20 | 1026 / 1026 | 2m 10s / 4m 51s | docker run ... @sha256:1c2abfc... | Aug 22, 12:55 |
run 32573894924executed 1026 - ccache 98 hit / 6526 miss - head ab6b8eacf - digest sha256:1c2abfc58acfc2... - run 32573894924 | ||||||
| success | 1 | 20 | 1026 / 1026 | 2m 12s / 4m 26s | docker run ... @sha256:bcbbb2e... | Aug 21, 12:53 |
run 32483299560executed 1026 - ccache 98 hit / 6526 miss - head bf3d4e714 - digest sha256:bcbbb2e98c4723... - run 32483299560 | ||||||
| success | 1 | 20 | 1026 / 1026 | 2m 46s / 5m 04s | docker run ... @sha256:32d41fc... | Aug 20, 12:53 |
run 32370249672executed 1026 - ccache 98 hit / 6526 miss - head 37516f8e8 - digest sha256:32d41fc5917d7b... - run 32370249672 | ||||||
| success | 1 | 20 | 1026 / 1026 | 2m 48s / 5m 39s | docker run ... @sha256:7018344... | Aug 19, 12:52 |
run 32253974670executed 1026 - ccache 98 hit / 6526 miss - head 4c3670649 - digest sha256:7018344dc8bb3c... - run 32253974670 | ||||||
| success | 1 | 20 | 1024 / 1024 | 1m 58s / 4m 09s | docker run ... @sha256:0f85d39... | Aug 18, 12:34 |
run 32136690166executed 1024 - ccache 98 hit / 6526 miss - head 607bf2105 - digest sha256:0f85d3943d8b30... - run 32136690166 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 45s / 5m 01s | docker run ... @sha256:48c3a34... | Aug 17, 12:37 |
run 32029669716executed 1022 - ccache 98 hit / 6525 miss - head 4ca29bc0c - digest sha256:48c3a34ac8c8b9... - run 32029669716 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 47s / 5m 32s | docker run ... @sha256:0fc7a52... | Aug 16, 12:33 |
run 31946813868executed 1022 - ccache 98 hit / 6525 miss - head 1c825745a - digest sha256:0fc7a52eb32bf8... - run 31946813868 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 54s / 5m 38s | docker run ... @sha256:08e8b0b... | Aug 15, 12:33 |
run 31884312416executed 1022 - ccache 98 hit / 6525 miss - head 61985a9bf - digest sha256:08e8b0b87f1d28... - run 31884312416 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 51s / 5m 33s | docker run ... @sha256:4ec6831... | Aug 14, 12:30 |
run 31799714143executed 1022 - ccache 165 hit / 6458 miss - head 173a5bfb9 - digest sha256:4ec683134f060f... - run 31799714143 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 57s / 5m 23s | docker run ... @sha256:3f29f26... | Aug 13, 12:29 |
run 31699300775executed 1022 - ccache 165 hit / 6458 miss - head ba9796475 - digest sha256:3f29f260e36477... - run 31699300775 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 55s / 5m 37s | docker run ... @sha256:b65a638... | Aug 12, 12:27 |
run 31595604176executed 1022 - ccache 165 hit / 6458 miss - head c644e69b1 - digest sha256:b65a63837689fa... - run 31595604176 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 52s / 5m 26s | docker run ... @sha256:6267b67... | Aug 11, 12:26 |
run 31490294420executed 1022 - ccache 165 hit / 6454 miss - head fb78178c1 - digest sha256:6267b67d5b337e... - run 31490294420 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 46s / 5m 08s | docker run ... @sha256:62e4462... | Aug 10, 12:22 |
run 31386255656executed 1022 - ccache 166 hit / 6453 miss - head b0c43ed8c - digest sha256:62e4462d44cd1f... - run 31386255656 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 53s / 5m 25s | docker run ... @sha256:4409067... | Aug 08, 15:16 |
run 31263575150executed 1022 - ccache 166 hit / 6453 miss - head 50531ecae - digest sha256:440906774ef35d... - run 31263575150 | ||||||
v123t48907_123posted Aug 06, 10:08successsupersededstale 3mopg 20
baseb59783502 Aug 07, 15:09 on master
applyapplied Aug 08, 10:11
rebaselast tried Aug 08, 10:11 on b59783502
pushAug 08, 10:11 -> 95b67d825branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1021 / 1021 | 2m 55s / 5m 43s | docker run ... @sha256:8e972c5... | Aug 08, 10:22 |
run 31252248362executed 1021 - ccache 166 hit / 6453 miss - head 95b67d825 - digest sha256:8e972c51fffaa4... - run 31252248362 | ||||||
| success | 1 | 20 | 1021 / 1021 | 2m 50s / 5m 28s | docker run ... @sha256:d715213... | Aug 07, 10:22 |
run 31169037746executed 1021 - ccache 166 hit / 6453 miss - head 4150b5d48 - digest sha256:d7152138cecfb8... - run 31169037746 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 49s / 5m 17s | docker run ... @sha256:a5948a5... | Aug 06, 10:21 |
run 31092175937executed 1020 - ccache 166 hit / 6453 miss - head 3c64ed465 - digest sha256:a5948a5bbe93ab... - run 31092175937 | ||||||
v121t48907_121posted Jun 29, 21:48successsupersededstale 4mopg 19
basea7f59b252 Jun 24, 13:07 - 120 days / 1174 commits behind master (from history)
applyapplied Jul 28, 23:33
rebaselast tried Jul 28, 23:33 on 239eabda4
Applying: Use auxiliary indexes for concurrent index operations Patch failed at 0001 Use auxiliary indexes for concurrent index operations error: sha1 information is lacking or useless (src/backend/nodes/makefuncs.c). error: could not build fake ancestor 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"
pushJul 28, 23:33 -> b53bbe397branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 19 | 1006 / 1006 | 2m 52s / 5m 22s | docker run ... @sha256:69501a0... | Jul 28, 23:55 |
run 30408384609executed 1006 - ccache 145 hit / 6475 miss - head b53bbe397 - digest sha256:69501a08d422b2... - run 30408384609 | ||||||
v119t48907_119posted Apr 11, 16:56successsupersededstale 7mopg 19
basef8eec1ced Apr 08, 13:49 - 197 days / 1714 commits behind master (from history)
applyapplied Jul 26, 07:19
pushJul 27, 01:43 -> c3568f826branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 19 | 998 / 998 | 2m 53s / 5m 16s | docker run ... @sha256:9c7e507... | Jul 27, 01:53 |
run 30230455959executed 998 - ccache 78 hit / 6541 miss - head c3568f826 - digest sha256:9c7e5077b3f695... - run 30230455959 | ||||||