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

Поиск
Список
Период
Сортировка
От Nick Renders
Тема Re: Postgres 12.1 : UPPER() in WHERE clause restarts server
Дата
Msg-id 43FFA5E7-3090-4D09-B801-C73A595635F9@arcict.com
обсуждение исходный текст
Ответ на Re: Postgres 12.1 : UPPER() in WHERE clause restarts server  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Postgres 12.1 : UPPER() in WHERE clause restarts server  (Marc <postgres@arcict.com>)
Список pgsql-general
Hi Tom,

1. we used the EDB installer.

2. turning JIT off did make the problem go away. So I guess this was 
causing the Postgres process to crash all along.

Thanks for the help,

Nick


On 24 Feb 2020, at 16:24, Tom Lane wrote:

> "Nick Renders" <postgres@arcict.com> writes:
>> We have set up a new test environment running PostgreSQL v12.2 on 
>> macOS
>> 10.14 and the issue is still there.
>
> Some nearby threads prompt these two questions:
>
> 1. Are you using your own build, or is this from EDB's installer?
>
> 2. If the latter, does turning JIT off ("set jit = off") make the
> problem go away?
>
> There is as yet no "native" support for --with-llvm on macOS,
> ie Apple themselves don't provide sufficient support for that.
> EDB seem to have hacked up something that sort of works, but
> only sort of.
>
>             regards, tom lane



В списке pgsql-general по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: LDAP with TLS is taking more time in Postgresql 11.5
Следующее
От: Jehan-Guillaume de Rorthais
Дата:
Сообщение: Re: Replication: slave server has 3x size of production server?