postgresql/contrib/pg_visibility
Andres Freund 3a4837fc80 Avoid edge case in pg_visibility test with small shared_buffers
Since 82a4edabd2 we can bulk extend relations. The bulk relation extension
logic has a heuristic component. Normally the heurstic does not trigger in the
occasionally-failing test case, as the relation is only extended once. But
with very small shared_buffers the limits for the number of buffers pinned at
once prevent the extension from happening at once. With the second "bulk"
extension, the heuristic kicks in, and the relation ends up one block bigger.
That's ok from a correctness perspective, but changes the results of the test
query due to one additional block.

We discussed a few more expansive fixes, but for now have decided to avoid
this by making the table a bit smaller.

Author: Heikki Linnakangas <hlinnaka@iki.fi>
Reported-by:
Discussion: https://postgr.es/m/29c74104-210b-ef39-2522-27a6aa7a704f@iki.fi
Discussion: https://postgr.es/m/20230916000011.2ugpkkkp7bpp4cfh@awork3.anarazel.de
Backpatch: 16-, where the new relation extension logic was added
2024-03-25 20:19:43 -07:00
..
expected Avoid edge case in pg_visibility test with small shared_buffers 2024-03-25 20:19:43 -07:00
sql Avoid edge case in pg_visibility test with small shared_buffers 2024-03-25 20:19:43 -07:00
t Fix false reports in pg_visibility 2024-03-14 13:12:05 +02:00
.gitignore Add relkind checks to certain contrib modules 2017-03-09 16:34:25 -05:00
Makefile Fix false reports in pg_visibility 2024-03-14 13:12:05 +02:00
meson.build Fix contrib/pg_visibility/meson.build 2024-03-14 13:38:44 +02:00
pg_visibility--1.0--1.1.sql pg_visibility: Add pg_truncate_visibility_map function. 2016-06-17 17:37:30 -04:00
pg_visibility--1.1--1.2.sql Default monitoring roles 2017-03-30 14:18:53 -04:00
pg_visibility--1.1.sql pg_visibility: Add pg_truncate_visibility_map function. 2016-06-17 17:37:30 -04:00
pg_visibility.c Fix false reports in pg_visibility 2024-03-14 13:12:05 +02:00
pg_visibility.control Default monitoring roles 2017-03-30 14:18:53 -04:00