X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A00C452862 for ; Mon, 6 Jun 2005 12:19:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07686-05 for ; Mon, 6 Jun 2005 15:19:16 +0000 (GMT) Received: from vms046pub.verizon.net (vms046pub.verizon.net [206.46.252.46]) by svr1.postgresql.org (Postfix) with ESMTP id 0FAAD528E0 for ; Mon, 6 Jun 2005 12:19:14 -0300 (ADT) Received: from osgiliath.mathom.us ([70.108.94.185]) by vms046.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IHO009DQ580LLI6@vms046.mailsrvcs.net> for pgsql-performance@postgresql.org; Mon, 06 Jun 2005 10:19:13 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id 1DA076000B2 for ; Mon, 06 Jun 2005 11:19:12 -0400 (EDT) Received: from osgiliath.mathom.us ([127.0.0.1]) by localhost (osgiliath [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 25210-01-9 for ; Mon, 06 Jun 2005 11:19:12 -0400 (EDT) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id 05A116000A8; Mon, 06 Jun 2005 11:19:12 -0400 (EDT) Date: Mon, 06 Jun 2005 11:19:11 -0400 From: Michael Stone Subject: Re: Performance nightmare with dspam (urgent) (resolved) In-reply-to: <42A466E7.4080808@arbash-meinel.com> To: Postgresql Performance Mail-Followup-To: Postgresql Performance Message-id: <20050606151911.GB19670@mathom.us> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-disposition: inline X-Pgp-Fingerprint: 53 FF 38 00 E7 DD 0A 9C 84 52 84 C5 EE DF 7C 88 X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at mathom.us References: <200506012019.13218.cshobe@seattleserver.com> <200506061454.48018.lists@seattleserver.com> <42A466E7.4080808@arbash-meinel.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.038 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/112 X-Sequence-Number: 12749 On Mon, Jun 06, 2005 at 10:08:23AM -0500, John A Meinel wrote: >I don't know if you can do it, but it would be nice to see this be 1 >RAID1 for OS, 1 RAID10 for pg_xlog, That's probably overkill--it's a relatively small sequential-write partition with really small writes; I don't see how pg_xlog would benefit from raid10 as opposed to raid1. Mike Stone