Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Y1dDv-0007Zc-Gj for pgsql-performance@arkaria.postgresql.org; Thu, 18 Dec 2014 15:42:43 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Y1dDu-0004rb-LV for pgsql-performance@arkaria.postgresql.org; Thu, 18 Dec 2014 15:42:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Y1dDs-0004om-IX for pgsql-performance@postgresql.org; Thu, 18 Dec 2014 15:42:40 +0000 Received: from smtp2.oma.be ([193.190.230.20]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1Y1dDh-0004Rt-7F for pgsql-performance@postgresql.org; Thu, 18 Dec 2014 15:42:39 +0000 Received: from snow.oma.be (snow.oma.be [193.190.249.132]) by smtp2.oma.be (8.14.3/8.14.3/SuSE Linux 0.8) with ESMTP id sBIFgNmu025465 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 18 Dec 2014 15:42:24 GMT From: Alessandro Ipe To: Torsten =?ISO-8859-1?Q?F=F6rtsch?= Cc: pgsql-performance@postgresql.org Subject: Re: Excessive memory used for INSERT Date: Thu, 18 Dec 2014 16:42:23 +0100 Message-ID: <6002240.FouBPN158i@snow.oma.be> Organization: Royal Meteorological Institute of Belgium User-Agent: KMail/4.14.3 (Linux/3.7.10-1.1-desktop; KDE/4.14.3; x86_64; ; ) In-Reply-To: <54928793.5000907@gmx.net> References: <2163931.4eVnXNjHa3@snow.oma.be> <54928793.5000907@gmx.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="nextPart1735146.5tgN78pbTa" Content-Transfer-Encoding: 7Bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org This is a multi-part message in MIME format. --nextPart1735146.5tgN78pbTa Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-15" On Thursday 18 December 2014 08:51:47 Torsten F=F6rtsch wrote: > On 17/12/14 16:14, Alessandro Ipe wrote: > > 2014-12-15 17:54:07 GMT LOG: server process (PID 21897) was=20 terminated > > by signal 9: Killed >=20 > 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=20 RAM exhaustion. But the problem remains : why an INSERT requires that h= uge=20 amount of memory ? Regards, A. --nextPart1735146.5tgN78pbTa Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="iso-8859-15"

On = Thursday 18 December 2014 08:51:47 Torsten F=F6rtsch wrote:

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

>= ; > 2014-12-15 17:54:07 GMT LOG: server process (PID 21897) was term= inated

>= ; > by signal 9: Killed

>= ;

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

Ind= eed and this hopefully prevented postgresql to crash my whole system du= e to RAM exhaustion. But the problem remains : why an INSERT requires t= hat huge amount of memory ?

Reg= ards,

A.<= /p> --nextPart1735146.5tgN78pbTa--