Skip site navigation (1) Skip section navigation (2)

Re: Performance question.

From: "PG Explorer" <pgmail(at)pgexplorer(dot)com>
To: "pgsql-gen Newsgroup" <(at)Basebeans(dot)compgsql-gen(at)basebeans(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: Performance question.
Date: 2002-03-27 19:59:16
Message-ID: 000b01c1d5c9$e1726d40$c80ba8c0@sabex.com (view raw or flat)
Thread:
Lists: pgsql-general
> 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


In response to

pgsql-general by date

Next:From: pgsql-gen Newsgroup (@Basebeans.com)Date: 2002-03-27 20:40:02
Subject: Re: Performance question.
Previous:From: pgsql-gen Newsgroup (@Basebeans.com)Date: 2002-03-27 19:40:01
Subject: Performance question.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group