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 75D3ACBAAF for ; Sun, 13 Jul 2003 19:42:11 +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 80384-02 for ; Sun, 13 Jul 2003 19:42:32 +0000 (GMT) Received: from v2.intertune.com (unknown [209.75.26.20]) by svr1.postgresql.org (Postfix) with ESMTP id 2C012CBAAE for ; Sun, 13 Jul 2003 16:42:09 -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 h6DK5Gi04031 for ; Sun, 13 Jul 2003 13:05:16 -0700 Message-ID: <008801c34976$e58a4ac0$0600a8c0@home01> From: "Balazs Wellisch" To: References: <001001c34908$fc98bc60$0600a8c0@home01> <1058100557.19798.20.camel@haggis> Subject: Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Date: Sun, 13 Jul 2003 12:42:29 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-13" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/200 X-Sequence-Number: 2493 > On Sun, 2003-07-13 at 01:35, Balazs Wellisch wrote: > > 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.) > > Note that I've read a couple of times from Tom Lane (one of the > core team) that FKs are a serous performance drag, so I'd drop > them after the s/w has been in production long enough to work > out the kinks. > That's interesting, I didn't know that. Any idea how much of a performance drag we're talking about? > > 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. > > http://www.varlena.com/GeneralBits/ > http://www.varlena.com/GeneralBits/Tidbits/perf.html > http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html > Those links are great!!! Thank you for bringing them to my attantion. And a BIG thank you to the authors (Josh Berkus & Shridhar Daithankar) for making this available. I've been looking for an authoritative and comprehensive source for performance tuning tips but haven't found much except for little tidbits here and there. This is very nice. > Me, I'd install Debian, but I understand the comfort level created > by RH. > Don't know much about Debian, but we've been working with RH for years. I've had nothing but good experiences with them. (Except maybe for RH8) The new Enterprise direction they're going in is exectly what we need. Longer testing cycles and better tuned distributions are good for businesses like us. We don't necessarily need the latest and greates we need the latest and most stable to guarantee the highest return on our investment. But, this discussion is for another list... :) Thanks for your advice. This list has proved to be a great asset so far. Balazs