|
28 | 28 | SET enable_seqscan = off; |
29 | 29 | SET hnsw.iterative_scan = relaxed_order; |
30 | 30 | SET hnsw.max_scan_tuples = 100000; |
| 31 | +SET hnsw.scan_mem_multiplier = 2; |
31 | 32 | SELECT COUNT(*) FROM (SELECT v FROM tst WHERE i % 10000 = 0 ORDER BY v <-> (SELECT v FROM tst LIMIT 1) LIMIT 11) t; |
32 | 33 | )); |
33 | 34 | is($count, 10); |
|
44 | 45 | SET enable_seqscan = off; |
45 | 46 | SET hnsw.iterative_scan = relaxed_order; |
46 | 47 | SET hnsw.max_scan_tuples =$max_tuples; |
| 48 | +SET hnsw.scan_mem_multiplier = 2; |
47 | 49 | SELECT COUNT(*) FROM (SELECT v FROM tst WHERE i % 10000 = 0 ORDER BY v <-> (SELECT v FROM tst WHERE i =$i) LIMIT 11) t; |
48 | 50 | )); |
49 | 51 | $sum +=$count; |
|
59 | 61 | SET hnsw.iterative_scan = relaxed_order; |
60 | 62 | SET client_min_messages = debug1; |
61 | 63 | SET work_mem = '1MB'; |
62 | | -SET hnsw.scan_mem_multiplier = 1; |
63 | 64 | SELECT COUNT(*) FROM (SELECT v FROM tst WHERE i % 10000 = 0 ORDER BY v <-> (SELECT v FROM tst LIMIT 1) LIMIT 11) t; |
64 | 65 | )); |
65 | 66 | like($stderr,qr/hnsw index scan reached memory limit after\d+ tuples/); |
|