pgvector
diff --git a/Collapse file
‎test/t/047_hnsw_vacuum_write.pl‎
Copy file name to clipboardExpand all lines: test/t/047_hnsw_vacuum_write.pl
+4-10Lines changed: 4 additions & 10 deletions b/Collapse file
‎test/t/047_hnsw_vacuum_write.pl‎
Copy file name to clipboardExpand all lines: test/t/047_hnsw_vacuum_write.pl
+4-10Lines changed: 4 additions & 10 deletions
@@ -21,21 +21,15 @@
 $node->safe_psql("postgres", "CREATE INDEX ON tst USING hnsw (v vector_l2_ops);");
 
 $node->pgbench(
-    "--no-vacuum --client=5 --time=1",
+    "--no-vacuum --client=5 --transactions=1000",
     0,
     [qr{actually processed}],
     [qr{^$}],
     "VACUUM write",
     {
-        "047_hnsw_vacuum_write_insert" => "INSERT INTO tst (v) VALUES (ARRAY[$array_sql]);",
-        "047_hnsw_vacuum_write_delete" => "DELETE FROM tst WHERE i = (SELECT i FROM tst ORDER BY i LIMIT 1 FOR UPDATE SKIP LOCKED);",
-        "047_hnsw_vacuum_write_vacuum" => q(
-            SELECT pg_try_advisory_lock(42)::integer AS gotlock \gset
-            \if :gotlock
-                VACUUM tst;
-                SELECT pg_advisory_unlock(42);
-            \endif
-        )
+        "047_hnsw_vacuum_write_insert\@500" => "INSERT INTO tst (v) VALUES (ARRAY[$array_sql]);",
+        "047_hnsw_vacuum_write_delete\@500" => "DELETE FROM tst WHERE i = (SELECT i FROM tst ORDER BY i LIMIT 1 FOR UPDATE SKIP LOCKED);",
+        "047_hnsw_vacuum_write_vacuum\@1" => "VACUUM tst;"
     }
 );