Bug: LSQB Performance

Open adsharma opened this issue 1 year ago • 2 comments

Kuzu version

v0.9.0

What operating system are you using?

Ubuntu 24.04

What happened?

Kuzu is slow on some queries, especially Q3. Comparison to DuckDB and DuckPGQ 1.2.1 SF=0.1 NUM_THREADS=16

Are there known steps to reproduce?

Cc: @andyfengHKU

Apr 02 '25 05:04 adsharma

Q3 should be fixed by #5179.

Others, e.g. Q1 looks like the optimizer picks a sub-optimal plan. We should improve this gradually with a better cost model @ray6080

Apr 02 '25 06:04 andyfengHKU

All these numbers are with SF=0.1 (data size = 30MB). With data size >> DRAM, perhaps a different set of db size related optimization strategies such as #5050 start kicking in.

Apr 02 '25 14:04 adsharma