odd jdbc driver synchronization issue

From: "George Lessmann" <glessmann(at)hotmail(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: odd jdbc driver synchronization issue
Date: 2003-12-31 20:06:46
Message-ID: 006901c3cfd9$9e0d7200$85342fa5@elvis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I'm trying to move my database platform from MSSQL Server to PostgreSQL.
I have a load simulation program I wrote which I'm running against a
test PostgreSQL instance. The application creates a number of client
threads, each with their own database connection, and turns them loose
on a workload. Currently, it's lagging the SQLServer test. I'm still
tuning the postgresql.conf file, but I also noticed something very odd
wrt the postmaster process. I see something like the following:

3 threads started, 0 done,
pid 1 99%
pid 2 0%
pid 3 0%

2 threads started, 1 done,
pid 1 0%
pid 2 99%
pid 3 0%

1 threads started, 2 done,
pid 1 0%
pid 2 0%
pid 3 99%

Even though all the treads are runnable, with their own connection, and
their own postmaster process on the DB, they are still serializing their
writes. If I look in the table where the data is being generated, I see
rows inserted in order similar to what top is showing (Client3's data,
then Client6's data, then Client1's data, etc).

As this application is written in java and using the PostgreSQL jdbc
driver I'm starting here, if you feel I should post elsewhere, let me
know.

Thanks,

George

--Details--

Client machine:
Windows XP, Java 1.4.2 (build 1.4.2-b28)
PostgreSQL JDBC driver 7.4, 7.4.1 (no difference)

Database machine:
Debian Linux 2.6.0-test11 #4 SMP i686 GNU/Linux
2x 2.4GHz Xeon w/HT, 1GB RAM
PostgreSQL 7.4

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jan Wieck 2003-12-31 20:27:15 PL/Java issues
Previous Message George Lessmann 2003-12-31 19:57:40 odd jdbc driver synchronization issue