pgvector.git / summary / log / commit / refs

commit    d164fd35a8ba490552986aa670daa4e4d6f470dd
Author:   Andrew Kane <andrew@ankane.org>
Date:     Tue Jan 10 11:14:49 2023 +0000

    Made dimensions configurable for vacuum test


 test/t/002_vacuum.pl | 15 ++++++++++++---
 1 file changed, 12 insertions(+), 3 deletions(-)

diff --git a/test/t/002_vacuum.pl b/test/t/002_vacuum.pl
index f4a2e8d6..1c3d7184 100644
--- a/test/t/002_vacuum.pl
+++ b/test/t/002_vacuum.pl
@@ -4,6 +4,15 @@ use PostgresNode;
 use TestLib;
 use Test::More tests => 1;
 
+my $dim = 3;
+
+my @r = ();
+for (1 .. $dim) {
+	my $v = int(rand(1000)) + 1;
+	push(@r, "i % $v");
+}
+my $array_sql = join(", ", @r);
+
 # Initialize node
 my $node = get_new_node('node');
 $node->init;
@@ -11,9 +20,9 @@ $node->start;
 
 # Create table and index
 $node->safe_psql("postgres", "CREATE EXTENSION vector;");
-$node->safe_psql("postgres", "CREATE TABLE tst (i int4, v vector(3));");
+$node->safe_psql("postgres", "CREATE TABLE tst (i int4, v vector($dim));");
 $node->safe_psql("postgres",
-	"INSERT INTO tst SELECT i % 10, ARRAY[i % 1000, i % 333, i % 55] FROM generate_series(1, 100000) i;"
+	"INSERT INTO tst SELECT i % 10, ARRAY[$array_sql] FROM generate_series(1, 100000) i;"
 );
 $node->safe_psql("postgres", "CREATE INDEX ON tst USING ivfflat (v);");
 
@@ -24,7 +33,7 @@ my $size = $node->safe_psql("postgres", "SELECT pg_total_relation_size('tst_v_id
 $node->safe_psql("postgres", "DELETE FROM tst;");
 $node->safe_psql("postgres", "VACUUM tst;");
 $node->safe_psql("postgres",
-	"INSERT INTO tst SELECT i % 10, ARRAY[i % 1000, i % 333, i % 55] FROM generate_series(1, 100000) i;"
+	"INSERT INTO tst SELECT i % 10, ARRAY[$array_sql] FROM generate_series(1, 100000) i;"
 );
 
 # Check size


[parent: 13e0fa24feee]