Alvaro, Thomas,
Putting a 256kb file full of 0x55 that's 01010101 and represents 4
commits
It did the job in being able to restart the server.
According to our data a “better” way, with less garbage.
The “Toast” issues how ever are still present.
To spend our weekend well we setup a new serve
Adrian, Christoph, Tom,
We identified as the problem being persistent on all tables with many
records ( +600K ) and they all had a JSONB column ( we feel that might
be related )
Luckily we were able to downgraded to version 11.6 with the same system
MacOS 10.14.6 so that the OS impact can ru
Peter,
Thanks for taking the time to respond and hope you're having a good
weekend. My
apologies for not noting the Postgres version. I thought about it after I
sent
the email but I didn't want to spam the thread.
$ psql --version
psql (PostgreSQL) 11.6
One interesting thing you mention is that
On Sun, Feb 9, 2020 at 11:46 AM Tom Lane wrote:
> "Nick Renders" writes:
> > When we do the following statement:
> > SELECT * FROM f_gsxws_schedule WHERE UPPER(gwsc_dossier) = 'TEST'
> > the Postgres service restarts.
>
> Hm.
>
> > Here is what is logged:
> > 2020-02-08 20:21:19.942 CET [83
