Re: Reg: connection is getting closed when doing select count(*)

Hi Tom,

Your guess is correct. I did installation using EDB's installer. *After
turning off JIT, the query works as expected,* attached the screenshot.
Can I expect same issue if I run on Linux server or with other installation
methods? Any suggestions would be great.

Thanks for troubleshooting.

Thanks ,
Raj

On Tue, Mar 3, 2020 at 8:13 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Raj kumar <rajkumar820999(at)gmail(dot)com> writes:
> > *I have installed Postgres12 in my Macbook. I have loaded data into the
> > database using pgbench. When I try to execute the command below, I am not
> > getting the output. Instead, connection is getting closed. Command and
> > errors are written below.*
>
> > 2020-03-03 14:59:20.868 IST [51374] STATEMENT: select count(*) from
> > pgbench_accounts;
> > 2020-03-03 14:59:25.852 IST [51363] LOG: server process (PID 51386) was
> > terminated by signal 9: Killed: 9
>
> Signal 9 is pretty unusual. I'm going to guess that you used EDB's
> installer and the problem is with JIT compilation ... does
> "set jit = off" fix it? If so, that's a known bug that's being
> worked on, see
>
>
> https://www.postgresql.org/message-id/CA%2BOCxoz0bWi%2BR2WpocfkD20Lgrg69z1jQ_SZd-zmdzHW0zt%2Bbg%40mail.gmail.com
>
> regards, tom lane
>