Performance question.

Subject: Performance question.
From: "Wei Gao" <weigao@hotmail.com>
 ===
Hi, List

I have a question about PostgreSQL performance.

I did a test on both postgresql 7.2 and MS SQL Server 2000 by using JAVA,
both on Windows 2000 platform. JDBC driver for postgresql come with
postgresql, Opta2000 as MS SQL Server 2000 driver.

Exact same insert operation (prepared statment), MS SQL Server with Opta2000
use about 381 ms, and PostgreSQL use 581ms.

That's about 50% performance down from MS SQL Server to PostgreSQL.

So, my question is:
1. Is this a knowing issue that PostgreSQL has a poor performance?
2. If same hardward platform, does PostgreSQL running on Linux has a better
performance than Windows? And how about PostgreSQL running on Linux compare
to MS SQL Server running on Windows?
3. Does JDBC Driver effect database perforce? I tried to use Microsoft JDBC
Driver for MS SQL Server 2000, of cause, beta version. But unfortunately, I
even can not get my program running on it.


Thanks a lot.

Jack