From: | Poul Møller Hansen <freebsd(at)pbnet(dot)dk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Unable to get a database connection while deleting rows |
Date: | 2007-04-09 08:54:47 |
Message-ID: | 4619FF57.8080403@pbnet.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a java application receiving data from a thousand devices on
periodic basis.
When receiving data the application gets a database connection, inserts
a row and closes the connection again.
If this process takes more than 15 seconds, the device assumes the
connection dead and makes a new one.
Sometimes a device is taken out of production and the data from it is
deleted.
Deleting ex. 30000 rows of a total of around 30 mill. takes about 45
seconds.
I expect this to be a row locking process and there is also no problem
with inserting rows while this process is running.
The problem is that getting the database connection can take from 1 to
the full 45 seconds.
There is nothing in the log telling me what's going on except from a lot
of "unexpected EOF on client connection"
Can anyone bring a light on what resource that can be the bottleneck ?
The system is "PostgreSQL 8.1.8 on x86_64-pc-linux-gnu, compiled by GCC
gcc-4.0.gcc-opt (GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)"
Thanks in advance,
Poul
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey Nalbat | 2007-04-09 09:24:04 | deadlock |
Previous Message | David Fetter | 2007-04-09 03:28:17 | == PostgreSQL Weekly News - April 08 2007 == |