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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Arsalan Zaidi | 2001-10-03 07:40:43 | select in a LIKE? |
Previous Message | wiss ji | 2001-10-02 17:15:23 | inquiry |
From | Date | Subject | |
---|---|---|---|
Next Message | Ricardo Maia | 2001-10-03 14:49:54 | How to set a connection timeout |
Previous Message | Swati | 2001-10-03 06:26:48 | org.postgresql package |