X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3F9C3D1D52E for ; Thu, 26 Feb 2004 22:11:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 15819-10 for ; Thu, 26 Feb 2004 18:11:10 -0400 (AST) Received: from main.gmane.org (main.gmane.org [80.91.224.249]) by svr1.postgresql.org (Postfix) with ESMTP id 53C0CD1CA67 for ; Thu, 26 Feb 2004 18:11:07 -0400 (AST) Received: from root by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 1AwTim-0006nh-00 for ; Thu, 26 Feb 2004 23:11:08 +0100 Received: from 62.79.119.132.adsl.vbr.tiscali.dk ([62.79.119.132]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu Feb 26 22:11:08 2004 Received: from troels by 62.79.119.132.adsl.vbr.tiscali.dk with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu Feb 26 22:11:08 2004 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Troels Arvin Subject: Re: Database Server Tuning Date: Thu, 26 Feb 2004 23:01:13 +0100 Lines: 17 Message-ID: References: <200402262128.i1QLS4VD023380@mxsf20.cluster1.charter.net> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: 62.79.119.132.adsl.vbr.tiscali.dk User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/329 X-Sequence-Number: 5853 On Thu, 26 Feb 2004 16:28:07 -0500, John Allgood wrote: > I am planning on separating the OS, Data, WAL on to separate drives > which will be mirrored. Have you considered RAID-10 in stead of RAID-1? > I am looking for input on setting kernel > parameters, and Postgres server runtime parameters and other settings > relating to tuning. http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php (See the "Performance" section.) -- Greetings from Troels Arvin, Copenhagen, Denmark