Re: Performance question.

> 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?

Do you run postgresql on Windows? If you do you will definitely get better
performance from Linux.

http://www.pgexplorer.com

----- Original Message -----
From: "pgsql-gen Newsgroup" <@Basebeans(dot)compgsql-gen(at)basebeans(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, March 27, 2002 9:40 PM
Subject: [GENERAL] Performance question.

> Subject: Performance question.
> From: "Wei Gao" <weigao(at)hotmail(dot)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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org