matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.79k stars 277 forks source link

[Bug]: fulltext index performance is slow #20175

Open tom-csf opened 2 days ago

tom-csf commented 2 days ago

Is there an existing issue for the same bug?

Branch Name

2.0-dev

Commit ID

3fced2dccf3763254979dd9f196e3896d97aa322

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

企业微信截图_76ffe69b-044d-4ded-a420-d1b7d1757ec8

Expected Behavior

No response

Steps to Reproduce

1、load 1g tpch to database
2、set experimental_fulltext_index=1;
   create fulltext index fdx1 on lineitem(L_COMMENT);
3、select * from lineitem where match(l_comment) against ('"e the furiously express accounts are at the"' in boolean mode);
4、select * from lineitem where l_comment = 'e the furiously express accounts are at the';

Additional information

image