Re: Performance question.

Subject: Re: [GENERAL] Performance question.
From: "Jack Gao" <weigao(at)hotmail(dot)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(at)pgexplorer(dot)com> wrote in message
news:mailman(dot)1017259380(dot)16240(dot)pgsql-gen(at)basebeans(dot)com(dot)(dot)(dot)
> > 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org