From: David Gagnon <dgagnon@siunik.com>
To: pgsql-performance@postgresql.org
Subject: Performance problem on delete from for 10k rows. May takes 20 minutes through JDBC interface
Date: Tue, 15 Mar 2005 16:24:17 -0500
Message-ID: <42375281.9090102@siunik.com> (raw)
Hi all,
Il get this strange problem when deleting rows from a Java program.
Sometime (For what I noticed it's not all the time) the server take
almost forever to delete rows from table.
Here It takes 20 minutes to delete the IC table.
Java logs:
INFO [Thread-386] (Dao.java:227) 2005-03-15 15:38:34,754 : Execution
SQL file: resources/ukConfiguration/reset_application.sql
DELETE FROM YR
INFO [Thread-386] (Dao.java:227) 2005-03-15 15:38:34,964 : Execution
SQL file: resources/inventory/item/reset_application.sql
DELETE FROM IC
INFO [Thread-386] (Dao.java:227) 2005-03-15 15:58:45,072 : Execution
SQL file: resources/ukResource/reset_application.sql
DELETE FROM RA
I get this problem on my dev (Windows/7.4/Cygwin) environment. But now
I see that it's also have this problem on my production env. Yes I
tought I was maybe just a cygwin/Windows problem .. apparently not :-((((
On my dev I can see the Postgresql related process running at almost 50%
of CPU usage for all the time. So I suppose it's something inside
Postgresql. I rememeber having tried to delete the content of my table
(IC) from PgAdminIII and I took couples of seconds!!! Not minutes. So
the process don't jam but take time .. any Idea what postgresql is doing
during this time??
If you have any idea on what the problem could be... I really appreciate
it.
Thanks for any help!
/David
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-performance@postgresql.org
Cc: dgagnon@siunik.com
Subject: Re: Performance problem on delete from for 10k rows. May takes 20 minutes through JDBC interface
In-Reply-To: <42375281.9090102@siunik.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