Use a lower max allocation size than default to allow scanning more tuples for iterative search before exceeding work_mem [skip ci]

ankane · ankane · commit 8e88b481a66b · 2024-10-10T20:57:57.000-07:00
diff --git a/src/hnswscan.c b/src/hnswscan.c
@@ -118,9 +118,14 @@ hnswbeginscan(Relation index, int nkeys, int norderbys)
 	so->first = true;
 	so->v.tids = NULL;
 	so->discarded = NULL;
+
+	/*
+	 * Use a lower max allocation size than default to allow scanning more
+	 * tuples for iterative search before exceeding work_mem
+	 */
 	so->tmpCtx = AllocSetContextCreate(CurrentMemoryContext,
 									   "Hnsw scan temporary context",
-									   ALLOCSET_DEFAULT_SIZES);
+									   0, 8 * 1024, 512 * 1024);
 
 	/* Set support functions */
 	HnswInitSupport(&so->support, index);
