Re: Excessive memory used for INSERT

From: Alessandro Ipe <Alessandro(dot)Ipe(at)meteo(dot)be>
To: Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Excessive memory used for INSERT
Date: 2014-12-18 15:42:23
Message-ID: 6002240.FouBPN158i@snow.oma.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alessandro Ipe 2014-12-18 16:31:46 Re: Excessive memory used for INSERT
Previous Message Alessandro Ipe 2014-12-18 11:16:49 Re: Excessive memory used for INSERT