Received: from post.webmailer.de (natpost.webmailer.de [192.67.198.65]) by postgresql.org (Postfix) with ESMTP id 2E4D4474E61 for ; Wed, 6 Mar 2002 19:44:49 -0500 (EST) Received: from there (pD9E0EACF.dip.t-dialin.net [217.224.234.207]) by post.webmailer.de (8.9.3/8.8.7) with SMTP id BAA02543; Thu, 7 Mar 2002 01:44:33 +0100 (MET) Message-Id: <200203070044.BAA02543@post.webmailer.de> Content-Type: text/plain; charset="iso-2022-jp" From: Ian Barwick To: "Peter Darley" , "Pgsql-Admin" Subject: Re: Linux Distributions Date: Thu, 7 Mar 2002 01:44:31 +0100 X-Mailer: KMail [version 1.3.1] References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200203/83 X-Sequence-Number: 3617 On Thursday 07 March 2002 01:02, Peter Darley wrote: > Ian, > By better I guess I mean faster. I'm looking to get the most speed out of > my database without having to invest in new hardware. > Thanks, > Peter Darley Then I don't think the PostgreSQL binaries provided in any given distribution will have any significant bearing on the matter; what will play a role is 1) how well does the distribution support your hardware; 2) whether your hardware is tuned optimally (BIOS, HD parameters etc.); 3) how PostgreSQL is built and configured 1 and 2 are beyond the scope of this list. How the PostgreSQL binaries were built (self-built or distribution-supplied) will probably have less of an effect on speed than the configuration (although as mentioned distributions often lag behind a version or two; the newer the version, the better the support), which very much depends on you and your hardware. HTH Ian Barwick