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 size 1T but unclear why

2018-12-11 Thread Justin Pryzby
On Sun, Dec 09, 2018 at 10:01:08AM -0600, Justin Pryzby wrote: > On Sun, Dec 09, 2018 at 05:18:55PM +0200, Mariel Cherkassky wrote: > > I'm trying to understand why my database consume so much space. I checked > > the space it consume on disk : To find single relations which are using more than 10

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