mirror of
https://github.com/pgvector/pgvector.git
synced 2026-06-28 16:51:18 +08:00
16 lines
543 B
SQL
16 lines
543 B
SQL
-- SET force_parallel_mode = on;
|
|
SET parallel_setup_cost = 10;
|
|
SET parallel_tuple_cost = 0.001;
|
|
SET min_parallel_table_scan_size = 1;
|
|
SET min_parallel_index_scan_size = 1;
|
|
|
|
CREATE TABLE t (id integer, val vector(3));
|
|
INSERT INTO t (id, val) SELECT n, ARRAY[random(), random(), random()] FROM generate_series(1,1000000) n;
|
|
CREATE INDEX ON t USING ivfflat (val) WITH (lists = 10);
|
|
SET ivfflat.probes = 2;
|
|
|
|
EXPLAIN SELECT * FROM t ORDER BY val <-> '[0.5,0.5,0.5]' LIMIT 5;
|
|
SELECT * FROM t ORDER BY val <-> '[0.5,0.5,0.5]' LIMIT 5;
|
|
|
|
DROP TABLE t;
|