no unpinned buffers available in test_pg_regress

[jcsp]

Appears to be intermittent, don't know how frequent.

https://neon-github-public-dev.s3.amazonaws.com/reports/pr-9952/12089734169/index.html#/testresult/25043b524b83a7d9

--- /__w/neon/neon/vendor/postgres-v17/src/test/regress/expected/box.out	2024-11-29 19:35:59.843130233 +0000
+++ /tmp/test_output/test_pg_regress[release-pg17-4]-1/regress/results/box.out	2024-11-29 19:40:57.502895717 +0000
@@ -497,6 +497,7 @@
   (11004, '((-infinity,100),(-infinity,500))'),
   (11005, '((-infinity,-infinity),(700,infinity))');
 CREATE INDEX quad_box_tbl_idx ON quad_box_tbl USING spgist(b);
+ERROR:  no unpinned buffers available

[jcsp]

@ololobus maybe a result of how we run with very few shared buffers in tests?

[knizhnik]

For LFC runs we reduce size of shared buffers from 1Mb to 512kB.
I have suggested boot to do it.

[ololobus]

For LFC runs we reduce size of shared buffers from 1Mb to 512kB.
I have suggested boot to do it.

@knizhnik what's the value you would recommend for this test? What should be the default?

[knizhnik]

For LFC runs we reduce size of shared buffers from 1Mb to 512kB.
I have suggested boot to do it.

@knizhnik what's the value you would recommend for this test? What should be the default?

1Mb - as we have used before and using now for configuration without LFC.