Re: Postgres 12.1 : UPPER() in WHERE clause restarts server

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

Re: Query returns no results until REINDEX

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

Re: Postgres 12.1 : UPPER() in WHERE clause restarts server

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

Re: Unable to startup postgres: Could not read from file "pg_clog/00EC"

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