Re: Excessive memory used for INSERT

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

Tree view

Excessive memory used for INSERT  (Alessandro Ipe, )
 Re: Excessive memory used for INSERT  (Torsten Zuehlsdorff, )
  Re: Excessive memory used for INSERT  (Tom Lane, )
   Re: Excessive memory used for INSERT  (Alessandro Ipe, )
    Re: Excessive memory used for INSERT  (Tom Lane, )
     Re: Excessive memory used for INSERT  (Alessandro Ipe, )
      Re: Excessive memory used for INSERT  (Alessandro Ipe, )
       Re: Excessive memory used for INSERT  (Tom Lane, )
        Re: Excessive memory used for INSERT  (Alessandro Ipe, )
        Re: Excessive memory used for INSERT  (Alessandro Ipe, )
         Re: Excessive memory used for INSERT  (Tom Lane, )
          Re: Excessive memory used for INSERT  (Alessandro Ipe, )
  Re: Excessive memory used for INSERT  (Alessandro Ipe, )
 Re: Excessive memory used for INSERT  (Torsten Förtsch, )
  Re: Excessive memory used for INSERT  (Alessandro Ipe, )

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:

From: Kevin Grittner
Date:
Subject: Re: Question about trigram GIST index
From: Robert DiFalco
Date:
Subject: Number of Columns and Update