On Wednesday, May 9, 2018, Niles Oien <
noien@nso.edu> wrote:
I have what I think is a bug in postgres. I'd like to help track it down, if that
is indeed what's going on.
I am running a reasonably recent version of postgres :
data=# select version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 9.5.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-17), 64-bit
(1 row)
9.5.12 is reasonably recent. 9.5.5 is not. Even if you found a live bug you'd have to upgrade to fix it so you should just do that now and see if that works. You can scan the release notes for 9.5.6 and newer to see whether any vacuum related fixes seem to apply.
David J.
