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 6B5D1CBACB for ; Sun, 13 Jul 2003 20:30:55 +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 85324-05 for ; Sun, 13 Jul 2003 20:31:15 +0000 (GMT) Received: from joeconway.com (66-146-172-86.skyriver.net [66.146.172.86]) by svr1.postgresql.org (Postfix) with ESMTP id CB733CBAC4 for ; Sun, 13 Jul 2003 17:30:52 -0300 (ADT) Received: from [192.168.5.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.0.6) with ESMTP-TLS id 1823566; Sun, 13 Jul 2003 12:58:15 -0700 Message-ID: <3F11C037.3070008@joeconway.com> Date: Sun, 13 Jul 2003 13:25:27 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Balazs Wellisch Cc: pgsql-performance@postgresql.org Subject: Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL References: <001001c34908$fc98bc60$0600a8c0@home01> <3F119743.2050803@joeconway.com> <009d01c3497a$039b8f30$0600a8c0@home01> In-Reply-To: <009d01c3497a$039b8f30$0600a8c0@home01> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/204 X-Sequence-Number: 2497 Balazs Wellisch wrote: >>I would *not* use the default version of Postgres shipped with any >>particular distribution. Use 7.3.3 because that is the latest released >>version. Or, as Shridhar mentioned in his post, the are a number of >>pretty significant performance improvements in 7.4 (which is in feature >>freeze and scheduled to go into beta on 21 July). If you are in an >>exploratory/test phase rather than production right now, I'd say use the >>7.4 beta for your comparisons. > > Well, I could start by testing 7.4, however I'd have to go back to the > stable version once we're ready to use it a production environment. So, I > might as well stick with eveluating the production version. How soon do you think you'll be in production? PostgreSQL beta testing usually seems to run about 2 months or so -- if you won't be in production before October, it is a good bet that Postgres 7.4 will be out or at least in release candidate by then. But it really depends on your specific application. If you use lots of "WHERE foo IN (SELECT ...)" type queries, you'll need to rewrite them in 7.3.3 or earlier, but in 7.4 they will probably work fine. Also, if you do much in the way of aggregate queries for reporting, 7.4 will likely give you a significant performance boost. >>If money is truly not a problem, but time is, my advice is to hire a >>consultant. There are probably several people on this list that can fill >>that role for you. Otherwise read the archives and ask lots of specific >>questions. > > Once we're ready to go with postgresql in a production environment we may > indeed need to hire a consultant. Any suggestions whom I should contact? > (We're in the San Diego area) > Um, actually, I live in the San Diego area ;-) Joe