X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id B772ED1C92D for ; Wed, 6 Aug 2003 21:33:10 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 85552-01 for ; Wed, 6 Aug 2003 18:31:50 -0300 (ADT) Received: from home.samurai.com (home.samurai.com [205.207.28.66]) by svr1.postgresql.org (Postfix) with ESMTP id C5018D1C91E for ; Wed, 6 Aug 2003 18:32:59 -0300 (ADT) Received: by home.samurai.com (Postfix, from userid 1014) id B66F026219; Wed, 6 Aug 2003 17:33:01 -0400 (EDT) Date: Wed, 6 Aug 2003 17:33:01 -0400 From: Neil Conway To: "Wilson A. Galafassi Jr." Cc: pgsql-performance@postgresql.org Subject: Re: PostgreSql under Linux Message-ID: <20030806213301.GA28017@home.samurai.com> References: <01dd01c35c45$141a42b0$70c0b4c8@notebook> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <01dd01c35c45$141a42b0$70c0b4c8@notebook> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/121 X-Sequence-Number: 2938 On Wed, Aug 06, 2003 at 03:03:41PM -0300, Wilson A. Galafassi Jr. wrote: > I'm installing Postgresql under linux for better performance and i want to know how is the best configuration. > 1. What is the best linux distribuition for better performance? The Linux distribution itself isn't that important, IMHO. Spend some time selecting the right filesystem (check the archives for threads on this topic), the right kernel (and perhaps compiling your own from scratch), perhaps some kernel tuning (I/O scheduler, etc.), and so forth. > 2. Does exists any compilation options to better performance on this machine? Not compilation options, but there are plenty of configuration settings you should be tweaking to ensure good performance. You can find a list of configuration options here: http://www.postgresql.org/docs/7.3/static/runtime-config.html -Neil