Andres Freund 408209d6a9 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:20:34 -07:00
..
expected	Avoid edge case in pg_visibility test with small shared_buffers	2024-03-25 20:20:34 -07:00
sql	Avoid edge case in pg_visibility test with small shared_buffers	2024-03-25 20:20:34 -07:00
.gitignore	Add relkind checks to certain contrib modules	2017-03-09 16:34:25 -05:00
Makefile	Split all OBJS style lines in makefiles into one-line-per-entry style.	2019-11-05 14:41:07 -08:00
meson.build	Update copyright for 2023	2023-01-02 15:00:37 -05: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	Update copyright for 2023	2023-01-02 15:00:37 -05:00
pg_visibility.control	Default monitoring roles	2017-03-30 14:18:53 -04:00