memory_limit=40G
ob_vector_memory_limit_percentage=30
– Create table
create table vector_bench_test(id, c_vector(vector(256));
– insert data;
create vector index angular_idx on vector_bench_test(c_vector) with (distance=cosine, type=hnsw, m=16, ef_construction=64);
– select;
– drop table
drop table vector_bench_test;
– Create table again
create table vector_bench_test(id, c_vector(vector(256));
– insert data;
create vector index angular_idx on vector_bench_test(c_vector) with (distance=cosine, type=hnsw, m=16, ef_construction=200);
– 报错:7603 ‘Vector index memory usage exceeds user defined limit.’
数据集: ann-benchmarks 下的nytimes-256-angular