X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id C4971CB56E for ; Sun, 13 Jul 2003 06:36:13 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 37973-03 for ; Sun, 13 Jul 2003 06:36:03 +0000 (GMT) Received: from v2.intertune.com (unknown [209.75.26.20]) by svr1.postgresql.org (Postfix) with ESMTP id 4336ACB56A for ; Sun, 13 Jul 2003 03:35:41 -0300 (ADT) Received: from home01 (66-75-1-38.san.rr.com [66.75.1.38]) (authenticated) by v2.intertune.com (8.11.6/8.11.6) with ESMTP id h6D6wXi29850 for ; Sat, 12 Jul 2003 23:58:33 -0700 From: "Balazs Wellisch" To: Subject: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Date: Sat, 12 Jul 2003 23:35:38 -0700 Message-ID: <001001c34908$fc98bc60$0600a8c0@home01> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0011_01C348CE.5039E460" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200307/192 X-Sequence-Number: 2485 This is a multi-part message in MIME format. ------=_NextPart_000_0011_01C348CE.5039E460 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi all, I'm in the process of initiating a movement in our company to move towards open source software use. As part of this movement I will be recommending PostgreSQL as an alternative to the currently used MSSQL. I'm going with PostgreSQL over MySQL because of the much more complete feature set it provides. (After having used MSSQL for quite some time not having triggers, foreign keys, sub selects, etc. is not an option.) However, to be able to justify the move I will have to demonstrate that PostgreSQL is up to par with MSSQL and MySQL when it comes to performance. After having read through the docs and the lists it seems obvious that PostgreSQL is not configured for high performance out of the box. I don't have months to learn the ins and outs of PostgreSQL performance tuning so I looked around to see if there are any preconfigured solutions out there. I found that Red Hat Database 2.1 comes with PostgreSQL installed. However, as far as I can tell it comes with postgreSQL 7.2 and it requires Red Hat 8.0 or Red Hat Advanced Server which is based on Red Hat 7.2. Would I be better off installing Red Hat 9.0 and PostgreSQL 7.3 and try to performance tune the installation myself, or should I buy Red Hat Advanced Server and install Red Hat Database 2.1? (Let's say money is no object) So, does anyone here have any experience using RH AS and DB 2.1? Any advice would be much appreciated. TIA Balazs ------=_NextPart_000_0011_01C348CE.5039E460 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi all,

 

I’m in the process of initiating a movement in our company to move towards open source software use. As part of this movement I will be recommending PostgreSQL as an alternati= ve to the currently used MSSQL. I’m going with Postgre= SQL over MySQL because of the much more complete fe= ature set it provides. (After having used MSSQL for quite some time not having triggers, foreign keys, sub selects, etc. is not an option.)

 

However, to be able to justify the move I will have to demonstrate that PostgreSQL is up to par with M= SSQL and MySQL when it comes to performance. After h= aving read through the docs and the lists it seems obvious that PostgreSQL is not configured for high performance out of the box. I don’t have months to learn the ins and outs of PostgreSQL performance tuning so I looked around to see if there are any preconfigured solutions out there.

 

I found that Red Hat Database 2.1 comes with PostgreSQL installed. However, as far as I can tell it comes with postgreSQL 7.2 and it requires Red H= at 8.0 or Red Hat Advanced Server which is based on Red Hat 7.2. Would I be better= off installing Red Hat 9.0 and PostgreSQL 7.3 and t= ry to performance tune the installation myself, or sho= uld I buy Red Hat Advanced Server and install Red Hat Database 2.1? (Let’s = say money is no object)

 

So, does anyone here have any experience using = RH = = AS a= nd DB 2.1?

 

Any advice would be much appreciated.<= /font>

 

TIA

 

Balazs

 

------=_NextPart_000_0011_01C348CE.5039E460--