One thing that would help is the code?
Dave
On Wed, 2003-12-31 at 15:06, George Lessmann wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
Dave Cramer
519 939 0336
ICQ # 1467551
