TOAST table repeatedly corrupted

On Wednesday, May 9, 2018, Niles Oien <noien(at)nso(dot)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.