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
Message-ID: <005701c14bda$dedf1480$4301a8c0@directi.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: azaidi@directi.com, pgsql-jdbc@postgresql.org
Subject: Re: java.lang.OutOfMemory Exception with a large number of inserts
In-Reply-To: <005701c14bda$dedf1480$4301a8c0@directi.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox