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 8B5DDD1E253 for ; Wed, 12 May 2004 16:05:28 -0300 (ADT) 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 41127-06 for ; Wed, 12 May 2004 16:05:09 -0300 (ADT) Received: from lorax.kcilink.com (lorax.kcilink.com [206.112.95.1]) by svr1.postgresql.org (Postfix) with ESMTP id 1B1CFD1E2C8 for ; Wed, 12 May 2004 16:05:07 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by lorax.kcilink.com (Postfix) with ESMTP id 59A2A3FAE for ; Wed, 12 May 2004 15:05:06 -0400 (EDT) Received: from lorax.kcilink.com ([127.0.0.1]) by localhost (lorax.kcilink.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 91451-01-4 for ; Wed, 12 May 2004 15:05:05 -0400 (EDT) Received: by lorax.kcilink.com (Postfix, from userid 8) id D9C353EB7; Wed, 12 May 2004 15:05:05 -0400 (EDT) To: pgsql-performance@postgresql.org Path: not-for-mail From: Vivek Khera Newsgroups: ml.postgres.performance Subject: Re: Configuring PostgreSQL to minimize impact of Date: Wed, 12 May 2004 15:05:05 -0400 Organization: Khera Communications, Inc., Rockville, MD Lines: 18 Message-ID: References: <905B43ED-A395-11D8-A34F-000393BD6C3E@tuckfield.com> <1084314760.4100.53.camel@localhost.localdomain> NNTP-Posting-Host: yertle.kcilink.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: lorax.kcilink.com 1084388705 14464 65.205.34.180 (12 May 2004 19:05:05 GMT) X-Complaints-To: daemon@kciLink.com NNTP-Posting-Date: Wed, 12 May 2004 19:05:05 +0000 (UTC) User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, berkeley-unix) Cancel-Lock: sha1:vTsaLsWps91VsdnZ44+ELyitKGE= X-Virus-Scanned: by amavisd-new at kcilink.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/114 X-Sequence-Number: 6945 >>>>> "JAR" == J Andrew Rogers writes: JAR> The LSI MegaRAID reading/writing/caching behavior is user configurable. JAR> It will support both write-back and write-through, and IIRC, three JAR> different algorithms for reading (none, read-ahead, adaptive). Plenty JAR> of configuration options. For PG max performance, you want to set it for write-back and read-ahead (adaptive has been claimed to be bad, but I got similar performace from read-ahead and adaptive, so YMMV). -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/