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