Re: database crash during pgbench run

2018-12-21 Thread Merlin Moncure
On Tue, Dec 11, 2018 at 10:01 AM Tom Lane wrote: > > Greg Clough writes: > >>> 2018-12-10 19:11:56 IST 23647 LOG: received fast shutdown request > >>> any idea what can cause it ? > > >> Something sent SIGINT to the postmaster. > > > My money is on the OoM (Out of Memory) killer. > > That usua

RE: database crash during pgbench run

2018-12-11 Thread Greg Clough
> > 2018-12-10 19:11:56 IST 23647 LOG: received fast shutdown request > > any idea what can cause it ? > >Something sent SIGINT to the postmaster. My money is on the OoM (Out of Memory) killer. The standard PDGD install on CentOS should disable that, but I'm not sure what OS you're on or how

Re: database crash during pgbench run

2018-12-11 Thread Tom Lane
Greg Clough writes: >>> 2018-12-10 19:11:56 IST 23647 LOG: received fast shutdown request >>> any idea what can cause it ? >> Something sent SIGINT to the postmaster. > My money is on the OoM (Out of Memory) killer. That usually uses SIGKILL. If I had to guess, I'd wonder whether the postma

Re: database crash during pgbench run

2018-12-10 Thread Tom Lane
Mariel Cherkassky writes: > 2018-12-10 19:11:56 IST 23647 LOG: received fast shutdown request > any idea what can cause it ? Something sent SIGINT to the postmaster. regards, tom lane

database crash during pgbench run

2018-12-10 Thread Mariel Cherkassky
Hi, I have a very strong machine with 64GB of ram and 19 cpu but it seems that when I'm running the next benchmark test with pg_bench the database is crashing : createdb -U postgres bench pgbench -i -s 50 -U postgres -d bench pgbench -U postgres -d bench -c 10 -t 1 output : client 8 receivin