Received: from qmail-a.directi.com ([203.199.89.139])
	by postgresql.org (8.11.3/8.11.4) with SMTP id f937C8n88678
	for <pgsql-interfaces@postgresql.org>;
	Wed, 3 Oct 2001 03:12:11 -0400 (EDT)
	(envelope-from azaidi@directi.com)
Received: (qmail 2845 invoked by uid 0); 3 Oct 2001 07:12:05 -0000
Received: from unknown (HELO default) (203.197.51.84)
	by 203.199.89.139 with SMTP; 3 Oct 2001 07:12:05 -0000
Message-ID: <005701c14bda$dedf1480$4301a8c0@directi.com>
From: "Arsalan Zaidi" <azaidi@directi.com>
To: "PostgreSQL" <pgsql-interfaces@postgresql.org>
Cc: "PostgreSQL jdbc list" <pgsql-jdbc@postgresql.org>
Subject: java.lang.OutOfMemory Exception with a large number of inserts
Date: Wed, 3 Oct 2001 12:43:12 +0530
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
X-Archive-Number: 200110/4
X-Sequence-Number: 1972

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