matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: The performance of the optimized ivf create index has significantly decreased

Open heni02 opened this issue 9 months ago • 2 comments

Is there an existing issue for the same bug?

  • [x] I have checked the existing issues.

Branch Name

2.1-dev

Commit ID

b44d810e479

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

sift128 /gist960 1 million vector create index cost time Image

and vs pgvector create index cost time Image

data: https://doc.weixin.qq.com/sheet/e3_AYYAgwazACsB4L72hnoQ1eAEU31N6?scode=AJsA6gc3AA8QPAY9JuAYYAgwazACs&tab=o01hkj

Expected Behavior

No response

Steps to Reproduce

CREATE INDEX ivf_%d USING ivfflat on items (embedding) op_type 'vector_l2_ops'  lists=%d;

Additional information

No response

heni02 avatar Mar 20 '25 09:03 heni02

please verify after the code merged to 2.1-dev

cpegeric avatar May 12 '25 09:05 cpegeric

下一版本测试验证

heni02 avatar May 30 '25 06:05 heni02

main分支fcbc898e63已修复,sift128的create index较之前有一定下降,gist960 create index较之前性能有所提升,继续观察,先关闭issue Image

heni02 avatar Aug 06 '25 03:08 heni02