gist_trgm_ops '=' operator: planner picks it over btree, ~300x slower

back to CI dashboard

3 patchsets tracked - current t253643_10

v10t253643_10posted Oct 10, 05:42successappliesrecent 0dpg 20
base9b5d4e333 1 day ago on master
applyapplied about 2 hours ago
rebaselast tried about 2 hours ago on 9b5d4e333
pushabout 2 hours ago -> 893821449branchdiff vs base
ResultAttPGTestsBuild / testImageWhen
success1201071 / 10712m 38s / 4m 43sdocker run ... :t253643about 2 hours ago
run 45054230120
executed 1071 - ccache 78 hit / 6547 miss - head 893821449 - digest sha256:f34e968855ef49... - run 45054230120
success1201071 / 10713m 06s / 5m 43sdocker run ... @sha256:3738459...1 day ago
run 44934448039
executed 1071 - ccache 78 hit / 6547 miss - head 88feaf7a8 - digest sha256:373845929c266c... - run 44934448039
success1201070 / 10702m 47s / 5m 04sdocker run ... @sha256:53b000b...2 days ago
run 44790672565
executed 1070 - ccache 78 hit / 6547 miss - head db34b98d6 - digest sha256:53b000b8d98e93... - run 44790672565
success1201069 / 10692m 54s / 5m 27sdocker run ... @sha256:6caaca8...3 days ago
run 44585244815
executed 1069 - ccache 78 hit / 6547 miss - head 2a669682b - digest sha256:6caaca870efa32... - run 44585244815
success1201068 / 10681m 57s / 3m 44sdocker run ... @sha256:66e1e82...4 days ago
run 44366404237
executed 1068 - ccache 78 hit / 6547 miss - head 24c65d4ea - digest sha256:66e1e8228e066f... - run 44366404237
success1201068 / 10683m 08s / 5m 46sdocker run ... @sha256:3f095ac...5 days ago
run 44142360441
executed 1068 - ccache 78 hit / 6547 miss - head 97d40181b - digest sha256:3f095aca9fc8d0... - run 44142360441
success1201068 / 10682m 56s / 5m 10sdocker run ... @sha256:557e3a1...6 days ago
run 43923060920
executed 1068 - ccache 78 hit / 6547 miss - head 1e7b2779c - digest sha256:557e3a1f20f752... - run 43923060920
success1201068 / 10682m 16s / 4m 54sdocker run ... @sha256:a5c8068...Nov 15, 17:44
run 43741962684
executed 1068 - ccache 78 hit / 6547 miss - head 9761aceb3 - digest sha256:a5c80683b5721f... - run 43741962684
success1201068 / 10681m 48s / 4m 31sdocker run ... @sha256:89960ca...Nov 14, 17:43
run 43621825447
executed 1068 - ccache 78 hit / 6547 miss - head 9fe8547a6 - digest sha256:89960cad616042... - run 43621825447
success1201068 / 10683m 07s / 6m 02sdocker run ... @sha256:3b91950...Nov 13, 17:44
run 43473918750
executed 1068 - ccache 78 hit / 6547 miss - head 126ba775b - digest sha256:3b919501bb2460... - run 43473918750
success1201068 / 10681m 56s / 4m 18sdocker run ... @sha256:1287ce4...Nov 12, 17:40
run 43270372280
executed 1068 - ccache 78 hit / 6547 miss - head 0ae3de178 - digest sha256:1287ce4b09aa5d... - run 43270372280
success1201068 / 10682m 51s / 4m 52sdocker run ... @sha256:0cca859...Nov 11, 17:39
run 43068614804
executed 1068 - ccache 78 hit / 6547 miss - head 4ae2083e3 - digest sha256:0cca85962aa90d... - run 43068614804
success1201068 / 10682m 19s / 4m 44sdocker run ... @sha256:e602a7b...Nov 10, 17:37
run 42865307197
executed 1068 - ccache 78 hit / 6547 miss - head 2a5722e15 - digest sha256:e602a7b818caec... - run 42865307197
success1201068 / 10683m 03s / 5m 28sdocker run ... @sha256:4761a44...Nov 09, 17:38
run 42664774060
executed 1068 - ccache 78 hit / 6547 miss - head af77f72c0 - digest sha256:4761a445408aea... - run 42664774060
success1201054 / 10541m 55s / 4m 15sdocker run ... @sha256:3b50036...Nov 08, 17:34
run 42504971376
executed 1054 - ccache 78 hit / 6546 miss - head 14490bf98 - digest sha256:3b50036ef467b5... - run 42504971376
success1201054 / 10542m 21s / 4m 54sdocker run ... @sha256:739bd33...Nov 07, 17:35
run 42396282585
executed 1054 - ccache 78 hit / 6546 miss - head efdc80bdc - digest sha256:739bd3378f9b6d... - run 42396282585
success1201054 / 10543m 02s / 5m 38sdocker run ... @sha256:6e8fa02...Nov 06, 17:35
run 42261372943
executed 1054 - ccache 78 hit / 6546 miss - head fef29625d - digest sha256:6e8fa02290f42e... - run 42261372943
success1201054 / 10543m 04s / 5m 41sdocker run ... @sha256:232ef98...Nov 05, 17:33
run 42073908378
executed 1054 - ccache 78 hit / 6546 miss - head 9be5f76ea - digest sha256:232ef980b574f6... - run 42073908378
success1201053 / 10533m 04s / 5m 37sdocker run ... @sha256:4dcf97d...Nov 04, 17:45
run 41876706413
executed 1053 - ccache 78 hit / 6546 miss - head ce66835e9 - digest sha256:4dcf97d9b6570f... - run 41876706413
success1201053 / 10532m 19s / 4m 48sdocker run ... @sha256:3992227...Nov 03, 17:10
run 41679920143
executed 1053 - ccache 78 hit / 6544 miss - head 68ead47be - digest sha256:39922276659905... - run 41679920143
success1201053 / 10533m 08s / 5m 51sdocker run ... @sha256:f9ca81b...Nov 02, 17:09
run 41486479273
executed 1053 - ccache 78 hit / 6544 miss - head 4a9dd8a46 - digest sha256:f9ca81be974226... - run 41486479273
success1201053 / 10533m 04s / 5m 37sdocker run ... @sha256:080bbbb...Nov 01, 17:00
run 41328302169
executed 1053 - ccache 78 hit / 6544 miss - head 0a747921f - digest sha256:080bbbb80e2959... - run 41328302169
success1201052 / 10523m 05s / 5m 37sdocker run ... @sha256:53180b8...Oct 31, 13:01
run 41202885026
executed 1052 - ccache 78 hit / 6544 miss - head 5e24442ee - digest sha256:53180b81081617... - run 41202885026
success1201052 / 10522m 14s / 4m 55sdocker run ... @sha256:0b69fdc...Oct 30, 12:58
run 41058198347
executed 1052 - ccache 78 hit / 6544 miss - head cfc34d0d2 - digest sha256:0b69fdcefb5e32... - run 41058198347
success1201052 / 10522m 44s / 4m 29sdocker run ... @sha256:e92e4ab...Oct 29, 12:56
run 40876004342
executed 1052 - ccache 78 hit / 6544 miss - head fa1ec8a92 - digest sha256:e92e4ab3401361... - run 40876004342
success1201052 / 10522m 56s / 5m 43sdocker run ... @sha256:e62fff6...Oct 28, 12:52
run 40689913362
executed 1052 - ccache 78 hit / 6544 miss - head 6e48395d4 - digest sha256:e62fff6819634f... - run 40689913362
success1201051 / 10512m 53s / 5m 23sdocker run ... @sha256:254dcac...Oct 27, 12:48
run 40505236732
executed 1051 - ccache 78 hit / 6544 miss - head 8d80caea5 - digest sha256:254dcacb351cae... - run 40505236732
success1201051 / 10512m 15s / 5m 07sdocker run ... @sha256:539fdc3...Oct 26, 12:44
run 40323599269
executed 1051 - ccache 78 hit / 6544 miss - head 7d95a23b5 - digest sha256:539fdc39b45574... - run 40323599269
success1201051 / 10512m 41s / 4m 37sdocker run ... @sha256:558f0fd...Oct 25, 12:39
run 40193323332
executed 1051 - ccache 78 hit / 6544 miss - head ed0322bd4 - digest sha256:558f0fdb1a6da1... - run 40193323332
success1201051 / 10512m 48s / 4m 58sdocker run ... @sha256:77d6c86...Oct 24, 12:36
run 40093926190
executed 1051 - ccache 78 hit / 6544 miss - head 6dd413d47 - digest sha256:77d6c868e43bc3... - run 40093926190
success1201051 / 10512m 44s / 5m 10sdocker run ... @sha256:2b9d80d...Oct 23, 12:35
run 39953191377
executed 1051 - ccache 78 hit / 6544 miss - head fd8d0bd49 - digest sha256:2b9d80d77cf437... - run 39953191377
success1201051 / 10512m 35s / 4m 24sdocker run ... @sha256:0feae18...Oct 22, 12:24
run 39776789115
executed 1051 - ccache 78 hit / 6544 miss - head 9c2688e76 - digest sha256:0feae182615787... - run 39776789115
success1201050 / 10501m 50s / 4m 06sdocker run ... @sha256:99e9aa4...Oct 21, 12:17
run 39597378187
executed 1050 - ccache 78 hit / 6544 miss - head 31ea5eb6c - digest sha256:99e9aa4169e53f... - run 39597378187
success1201050 / 10503m 04s / 5m 40sdocker run ... @sha256:65e7673...Oct 20, 12:10
run 39418849131
executed 1050 - ccache 78 hit / 6544 miss - head 9d0fafb6f - digest sha256:65e7673fa0303e... - run 39418849131
success1201050 / 10502m 51s / 5m 31sdocker run ... @sha256:485cc20...Oct 19, 12:08
run 39248332122
executed 1050 - ccache 78 hit / 6544 miss - head 54884f723 - digest sha256:485cc201acf37a... - run 39248332122
success1201050 / 10502m 51s / 5m 27sdocker run ... @sha256:39d2ef3...Oct 18, 12:03
run 39124986879
executed 1050 - ccache 78 hit / 6544 miss - head 54fde9372 - digest sha256:39d2ef3f033fac... - run 39124986879
success1201050 / 10502m 52s / 5m 26sdocker run ... @sha256:b51496d...Oct 17, 12:01
run 39030240647
executed 1050 - ccache 78 hit / 6544 miss - head 07bef6226 - digest sha256:b51496d9c6b100... - run 39030240647
success1201050 / 10502m 56s / 5m 18sdocker run ... @sha256:4e62977...Oct 16, 11:59
run 38896246782
executed 1050 - ccache 78 hit / 6544 miss - head 6e4505d2b - digest sha256:4e62977a6ee61b... - run 38896246782
success1201050 / 10502m 51s / 5m 15sdocker run ... @sha256:c9cba9a...Oct 15, 11:55
run 38729559531
executed 1050 - ccache 78 hit / 6544 miss - head a5959a74e - digest sha256:c9cba9a0a81706... - run 38729559531
success1201046 / 10461m 47s / 4m 32sdocker run ... @sha256:7a806c3...Oct 14, 11:52
run 38558651559
executed 1046 - ccache 78 hit / 6544 miss - head 1443bcd8e - digest sha256:7a806c317bb58d... - run 38558651559
success1201045 / 10452m 54s / 5m 18sdocker run ... @sha256:c2c2653...Oct 13, 11:48
run 38391305685
executed 1045 - ccache 78 hit / 6544 miss - head 7b57ca506 - digest sha256:c2c26539ad1430... - run 38391305685
success1201045 / 10452m 37s / 4m 47sdocker run ... @sha256:1a41b26...Oct 12, 11:41
run 38243172698
executed 1045 - ccache 78 hit / 6544 miss - head 29d4cc908 - digest sha256:1a41b2692ba048... - run 38243172698
success1201045 / 10452m 52s / 5m 41sdocker run ... @sha256:6396cc4...Oct 11, 05:56
run 38115849687
executed 1045 - ccache 78 hit / 6544 miss - head 164f44504 - digest sha256:6396cc40b97af9... - run 38115849687
success1201044 / 10442m 41s / 5m 00sdocker run ... @sha256:95d57f4...Oct 10, 05:54
run 38028531777
executed 1044 - ccache 78 hit / 6544 miss - head 3f77b781f - digest sha256:95d57f43bf0866... - run 38028531777
v9t253643_9posted Oct 06, 11:02infra errorsupersededstale 43dpg 20
base412848dac Oct 09, 04:59 on master
applyapplied Oct 09, 11:08
rebaselast tried Oct 09, 11:08 on 412848dac
pushOct 09, 11:08 -> dcfa55f67branchdiff vs base
skippedno CI verdict 48h after push
ResultAttPGTestsBuild / testImageWhen
success1201043 / 10432m 53s / 5m 35sdocker run ... @sha256:7d65e9c...Oct 08, 11:19
run 37768076454
executed 1043 - ccache 78 hit / 6544 miss - head d45bc023b - digest sha256:7d65e9c1c07754... - run 37768076454
success1201043 / 10432m 11s / 4m 40sdocker run ... @sha256:48a3d9b...Oct 07, 11:17
run 37611979685
executed 1043 - ccache 78 hit / 6544 miss - head 8e0aa33f7 - digest sha256:48a3d9b1f81547... - run 37611979685
success1201041 / 10412m 56s / 5m 35sdocker run ... @sha256:55200d4...Oct 06, 11:17
run 37454161831
executed 1041 - ccache 78 hit / 6544 miss - head 5e63af27e - digest sha256:55200d4e658234... - run 37454161831
v1t253643_1posted Sep 02, 11:11supersededunknownpatch extract failed