Thread: Performance question.

Performance question.

From
pgsql-gen Newsgroup (@Basebeans.com)
Date:
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



Re: Performance question.

From
"PG Explorer"
Date:
> 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.compgsql-gen@basebeans.com>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, March 27, 2002 9:40 PM
Subject: [GENERAL] 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


Re: Performance question.

From
pgsql-gen Newsgroup (@Basebeans.com)
Date:
Subject: Re: [GENERAL] Performance question.
From: "Jack Gao" <weigao@hotmail.com>
 ===
Yes, actually, I found that out.

Since I'm developing platform independent application, I run PostgreSQL on
both Linux and Windows. I found that PostgreSQL running on Linux has better
performance than Windows. But how about PostgreSQL on Linux compare to MS
SQL Server on Windows?

Thanks for your reply

Jack

"PG Explorer" <pgmail@pgexplorer.com> wrote in message
news:mailman.1017259380.16240.pgsql-gen@basebeans.com...
> > 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.compgsql-gen@basebeans.com>
> To: <pgsql-general@postgresql.org>
> Sent: Wednesday, March 27, 2002 9:40 PM
> Subject: [GENERAL] 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
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org



Re: Performance question.

From
Martijn van Oosterhout
Date:
On Wed, Mar 27, 2002 at 11:40:01AM -0800, pgsql-gen Newsgroup wrote:
> 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.

Interesting figures but any measurements under 1 second are more than likely
swamped by incidental disk activity. If you do 1000 inserts, is the result
still the same?

Also it makes a really big difference whether they are all in the same
transaction or in individual transactions.

Other than that, you have given absolutly no information about your "test".

> So, my question is:
> 1. Is this a knowing issue that PostgreSQL has a poor performance?

Your "test" above indicates no such thing. We use it exclusivly here and
it's easily fast enough.

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

No idea.

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

Probably. But they're hard to get around or even measure. Simply include the
time there as part of your testing.

--
Martijn van Oosterhout <kleptog@svana.org>   http://svana.org/kleptog/
> Ignorance continues to thrive when intelligent people choose to do
> nothing.  Speaking out against censorship and ignorance is the imperative
> of all intelligent people.