X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id 330B6CBAA8 for ; Sun, 13 Jul 2003 19:50:48 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 94227-09 for ; Sun, 13 Jul 2003 19:51:08 +0000 (GMT) Received: from v2.intertune.com (unknown [209.75.26.20]) by svr1.postgresql.org (Postfix) with ESMTP id C08CFCB539 for ; Sun, 13 Jul 2003 16:50:45 -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 h6DKDri04055 for ; Sun, 13 Jul 2003 13:13:53 -0700 Message-ID: <009901c34978$19697270$0600a8c0@home01> From: "Balazs Wellisch" To: References: <20030713110341.A16172@bacon> <20030713143721.A18011@bacon> Subject: Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Date: Sun, 13 Jul 2003 12:51:02 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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/201 X-Sequence-Number: 2494 > The most important thing seems to be to increase shared_buffers. On my > RH7.3 machine here, Linux is configured with shmmax = 32MB which allows me > a value of just under 4000 for shared_buffers (3900 works, 3950 doesn't). > If your selects return large amounts of data, you'll probably also need to > increase sort_mem (I use a value of 1024 so a query would have to return > more that 1MB of data before the sort (assuming there is a order by clause > to cause a sort) starts paging stuff out disk. > > > > 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) > > > Alternatively, you simply compile 7.3.3 from source. I've upgraded most my > machines that way. > Unfortunatelly, compiling from source is not really an option for us. We use RPMs only to ease the installation and upgrade process. We have over a hundred servers to maintaine and having to compile and recompile software everytime a new release comes out would be waaaaay too much work. > > > > So, does anyone here have any experience using RH AS and DB 2.1? > > Are RH still selling DB 2.1? I can't find it listed on their web site. > -- Yes, it's available for free download. The documentation is here: http://www.redhat.com/docs/manuals/database/. I'd welcome your oppinions on this product. Thank you for your comments. Balazs