Skip site navigation (1) Skip section navigation (2)

java.lang.OutOfMemory Exception with a large number of inserts

From: "Arsalan Zaidi" <azaidi(at)directi(dot)com>
To: "PostgreSQL" <pgsql-interfaces(at)postgresql(dot)org>
Cc: "PostgreSQL jdbc list" <pgsql-jdbc(at)postgresql(dot)org>
Subject: java.lang.OutOfMemory Exception with a large number of inserts
Date: 2001-10-03 07:13:12
Message-ID: 005701c14bda$dedf1480$4301a8c0@directi.com (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-jdbc
Hi.

At one point in my program, I was inserting a large number of rows
(~600,000) using a prepared statement. Here are some things I noticed.

1. It's very slow! :-)
2. Initially, the cpu monitor shows a high level of cpu utilisation, but
this slowly drops off with a blip every second or so. Basically, things slow
down as the process chugs along.
3. I eventually get a java.Lang.OutOfMemory exception after approx 1:00 -
1:30 hrs.

I tried running the JVM with heap size set to 50 Mbytes. I still get the out
of mem error.

I can't use the 'load' command instead of individual inserts.

Is there a faster/better way? Any ideas on how I can get rid of the out of
mem errors?

Thanks in advance

--Arsalan
-------------------------------------------------
WAR IS PEACE
FREEDOM IS SLAVERY
IGNORANCE IS STRENGTH
--1984




Responses

pgsql-interfaces by date

Next:From: Arsalan ZaidiDate: 2001-10-03 07:40:43
Subject: select in a LIKE?
Previous:From: wiss jiDate: 2001-10-02 17:15:23
Subject: inquiry

pgsql-jdbc by date

Next:From: Ricardo MaiaDate: 2001-10-03 14:49:54
Subject: How to set a connection timeout
Previous:From: SwatiDate: 2001-10-03 06:26:48
Subject: org.postgresql package

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group