heni02

date 5.3 tke regression https://github.com/matrixorigin/mo-nightly-regression/actions/runs/8940629660/job/24569679599 mo log： https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22Qq4%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-nightly-regression-20240503%5C%22%7D%20%7C%3D%20%60%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221714768123000%22,%22to%22:%221714771808000%22%7D%7D%7D&schemaVersion=1&orgId=1 五一期间出现的问题，非必现，profile自动清理掉了，等下次复现在定位

date 5.16 regression 复现，报了dup后现象mo hung住了 job:https://github.com/matrixorigin/mo-nightly-regression/actions/runs/9114235510/job/25069419376 mo log: https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22C5l%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-nightly-regression-20240516%5C%22%7D%20%7C%3D%20%60%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221715890350000%22,%22to%22:%221715892044000%22%7D%7D%7D&schemaVersion=1&orgId=1 profile: [etl_profile.zip](https://github.com/matrixorigin/matrixone/files/15343030/etl_profile.zip)

after vector index improvement test main commit:ad5d8c6c43a021760896df846fcf35dff93cfd8f performance results： 1. good news: Compared to previous versions, there has been a significant improvement in index creation and QPS, about more than...

For GIST960, the performance is bad. Arjun have created an issue for tracking the same: https://github.com/matrixorigin/matrixone/issues/16001

Performance is optimizating， move to the next version

pgvector version update to 0.7.2(postgres server version 14.4) ,retest pgvector benchmark performance, the newest version is better performance than previous 0.4.2 version ，see the results : https://doc.weixin.qq.com/sheet/e3_AYYAgwazACsB4L72hnoQ1eAEU31N6?scode=AJsA6gc3AA8QPAY9JuAYYAgwazACs&tab=jcbr8o  pgvector 0.7.2...

commit：4d44f7247 还有这个问题 job： https://github.com/matrixorigin/mo-nightly-regression/actions/runs/9044408439/job/24857841681

修改max-active-ages ='20min'复现再定位

先降级

1.2分支也有相同的问题：https://github.com/matrixorigin/mo-nightly-regression/actions/runs/9762284776/job/26945922535 commit：330ac12