Out of memory in pg_bulkload

From: Job <Job(at)colliniconsulting(dot)it>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Out of memory in pg_bulkload
Date: 2016-09-29 09:14:06
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A08054C14984A@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

sometimes, in pg_bulkload log, i see an "out of memory" error.
We use Postgresql 8.4.8 with Pg_bulkload 3.1 but we have at least 2 Gb of free memory space and system machine does not use swap.

We notice that it happens only sometimes; in other launch it works fine, with an higher number of record to be loaded into DB.

What could happen?
Thank you,
Francesco

Browse pgsql-general by date

  From Date Subject
Next Message Nguyễn Trần Quốc Vinh 2016-09-29 12:10:37 Re: Incrementally refreshed materialized view
Previous Message Michael Paquier 2016-09-29 05:36:04 Re: Large pg_xlog