Commit656b059

committed

Added tests for iterative index scan with empty index -resolvespgvector#679 [skip ci]

1 parent7cf9980 commit656b059Copy full SHA for 656b059

File tree

+21

-0

lines changed

+21

-0

lines changed

Lines changed: 6 additions & 0 deletions

Lines changed: 9 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -110,6 +110,15 @@ SELECT * FROM t ORDER BY val <-> '[3,3,3]';`
`110`	`110`	`[1,1,1]`
`111`	`111`	`(2 rows)`
`112`	`112`
	`113`	`+TRUNCATE t;`
	`114`	`+NOTICE: ivfflat index created with little data`
	`115`	`+DETAIL: This will cause low recall.`
	`116`	`+HINT: Drop the index until the table has more data.`
	`117`	`+SELECT * FROM t ORDER BY val <-> '[3,3,3]';`
	`118`	`+ val`
	`119`	`+-----`
	`120`	`+(0 rows)`
	`121`	`+`
`113`	`122`	`RESET ivfflat.iterative_scan;`
`114`	`123`	`RESET ivfflat.max_probes;`
`115`	`124`	`DROP TABLE t;`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -70,6 +70,9 @@ SELECT * FROM t ORDER BY val <-> '[3,3,3]';`
`70`	`70`	`SEThnsw.iterative_scan= relaxed_order;`
`71`	`71`	`SELECT*FROM tORDER BY val<->'[3,3,3]';`
`72`	`72`
	`73`	`+TRUNCATE t;`
	`74`	`+SELECT*FROM tORDER BY val<->'[3,3,3]';`
	`75`	`+`
`73`	`76`	`RESEThnsw.iterative_scan;`
`74`	`77`	`RESEThnsw.ef_search;`
`75`	`78`	`DROPTABLE t;`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -59,6 +59,9 @@ SELECT * FROM t ORDER BY val <-> '[3,3,3]';`
`59`	`59`	`SETivfflat.max_probes=2;`
`60`	`60`	`SELECT*FROM tORDER BY val<->'[3,3,3]';`
`61`	`61`
	`62`	`+TRUNCATE t;`
	`63`	`+SELECT*FROM tORDER BY val<->'[3,3,3]';`
	`64`	`+`
`62`	`65`	`RESETivfflat.iterative_scan;`
`63`	`66`	`RESETivfflat.max_probes;`
`64`	`67`	`DROPTABLE t;`

Comments

(0)