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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Raj kumar <rajkumar820999(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Reg: connection is getting closed when doing select count(*)
Date: 2020-03-03 14:43:49
Message-ID: 32701.1583246629@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Raj kumar 2020-03-03 19:37:55 Re: Reg: connection is getting closed when doing select count(*)
Previous Message Raj kumar 2020-03-03 09:49:29 Reg: connection is getting closed when doing select count(*)