alamb commented on issue #6278: URL: https://github.com/apache/arrow-datafusion/issues/6278#issuecomment-1538861768
I agree the tpch queries got much worse here are the results comparing 23.0.0 to `main` at 2e9beeba01b85afb6d4f6557201e673008ea9edd ``` ┏━━━━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓ ┃ Query ┃ tpch_mem ┃ tpch_mem ┃ Change ┃ ┡━━━━━━━━━━━━━━╇━━━━━━━━━━━╇━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩ │ QQuery 1 │ 855.34ms │ 2974.32ms │ 3.48x slower │ │ QQuery 2 │ 236.64ms │ 227.33ms │ no change │ │ QQuery 3 │ 146.80ms │ 156.11ms │ 1.06x slower │ │ QQuery 4 │ 96.49ms │ 92.63ms │ no change │ │ QQuery 5 │ 376.97ms │ 389.73ms │ no change │ │ QQuery 6 │ 35.81ms │ 35.52ms │ no change │ │ QQuery 7 │ 870.67ms │ 863.31ms │ no change │ │ QQuery 8 │ 225.08ms │ 212.54ms │ +1.06x faster │ │ QQuery 9 │ 492.54ms │ 499.20ms │ no change │ │ QQuery 10 │ 274.24ms │ 249.58ms │ +1.10x faster │ │ QQuery 11 │ 243.34ms │ 250.72ms │ no change │ │ QQuery 12 │ 145.80ms │ 154.45ms │ 1.06x slower │ │ QQuery 13 │ 611.00ms │ 650.75ms │ 1.07x slower │ │ QQuery 14 │ 43.63ms │ 40.05ms │ +1.09x faster │ │ QQuery 15 │ 83.76ms │ 81.30ms │ no change │ │ QQuery 16 │ 174.79ms │ 177.44ms │ no change │ │ QQuery 17 │ 2500.32ms │ 2412.97ms │ no change │ │ QQuery 18 │ 2643.99ms │ 2450.26ms │ +1.08x faster │ │ QQuery 19 │ 142.35ms │ 155.07ms │ 1.09x slower │ │ QQuery 20 │ 844.41ms │ 761.31ms │ +1.11x faster │ │ QQuery 21 │ 1275.64ms │ 1229.27ms │ no change │ │ QQuery 22 │ 134.58ms │ 127.93ms │ no change │ └──────────────┴───────────┴───────────┴───────────────┘ ``` I'll try and run some profiling and figure out what is going on -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
