Re: Excessive memory used for INSERT - Mailing list pgsql-performance

From Alessandro Ipe
Subject Re: Excessive memory used for INSERT
Date
Msg-id 6002240.FouBPN158i@snow.oma.be
Whole thread Raw
In response to Re: Excessive memory used for INSERT  (Torsten Förtsch <torsten.foertsch@gmx.net>)
List pgsql-performance

On Thursday 18 December 2014 08:51:47 Torsten Förtsch wrote:

> On 17/12/14 16:14, Alessandro Ipe wrote:

> > 2014-12-15 17:54:07 GMT LOG: server process (PID 21897) was terminated

> > by signal 9: Killed

>

> since it was killed by SIGKILL, maybe it's the kernel's OOM killer?

 

Indeed and this hopefully prevented postgresql to crash my whole system due to RAM exhaustion. But the problem remains : why an INSERT requires that huge amount of memory ?

 

 

Regards,

 

 

A.

pgsql-performance by date:

Previous
From: Alessandro Ipe
Date:
Subject: Re: Excessive memory used for INSERT
Next
From: Alessandro Ipe
Date:
Subject: Re: Excessive memory used for INSERT