Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 2ECF11337BBA for ; Fri, 10 Dec 2010 09:58:37 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 58640-02 for ; Fri, 10 Dec 2010 13:58:26 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm10-vm0.bullet.mail.sp2.yahoo.com (nm10-vm0.bullet.mail.sp2.yahoo.com [98.139.91.198]) by mail.postgresql.org (Postfix) with SMTP id 9416813364DE for ; Fri, 10 Dec 2010 09:58:25 -0400 (AST) Received: from [98.139.91.62] by nm10.bullet.mail.sp2.yahoo.com with NNFMP; 10 Dec 2010 13:58:25 -0000 Received: from [98.139.91.25] by tm2.bullet.mail.sp2.yahoo.com with NNFMP; 10 Dec 2010 13:58:25 -0000 Received: from [127.0.0.1] by omp1025.mail.sp2.yahoo.com with NNFMP; 10 Dec 2010 13:58:25 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 200656.26363.bm@omp1025.mail.sp2.yahoo.com Received: (qmail 4595 invoked by uid 60001); 10 Dec 2010 13:58:24 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1291989504; bh=bMy4Yf68DAH+EThvPV7cCU39A1TqEC9C7+IGzN0v5Qk=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=MpmVh1Bd0qkfo9CyTKChprPXpBYeTAlRf3Ta2lU5QmmSgJVRujoKbA0MxANQEz2RItc02ZjdFB1UClMz8A1W2gnk9QA4bJW8iYvs1B4PRt2QnALNc51j69FM8dr5/X1mFp+t2a9sA8JwnKT3gYe7eXYO0G/wsDpMrawwVWB9pvQ= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=pNSFcZotcB/d/A34g6+sYClYPXEt9fqhDU4EdGMozL0hHTcPRdHomr7hOhEW9kD51zjtVR6tuSOmpbA+aw3rcGdEkaEo+RAD464dRLVEYZIZ51pOIP2U+etfg8W8mCE4y1hrzLVMQLli4BgpF4ZDWTF8kyCfU/qCIA6NoSBmt+o=; Message-ID: <685022.3525.qm@web111301.mail.gq1.yahoo.com> X-YMail-OSG: .KzTz.8VM1lt9GyccqhGOtMmvxeAy.q56tFKVGLZWW9wcIl 2rWU.H9BciLC2tVpHmv7.9uP6N0PnyV0Hq2fqG7wZcfZIhYKOJdbZfoz1rH8 36dcBASBnyHmBKoX7mPZtdENAzzRyrRE3Ah8JpvAK0n9cATt0rFhXZiWoGb3 WCdZ4sHykNpxKWjBdW87.pkUvnIrKhPllca1oOeOWaZKZ4J1qQ1ePT2KkZFV DUTVqYWzzpSIXtPgm2zYaRz1DEvb.0YoIQGA0_dJqmRxTm9DseAlKJli4uxA INu9Jv7tfDGV5jLWJLfkYRDwtj7vML2p0g0Hue6rgl.WsoxPbbGiZzxyqHE_ 2JrVR_SzGNuKS2H7968D.fXXB4ydyUa6qWIJqdw4Z7HBdfFfxSrcyTyziTu8 wTtU8yNDoVA-- Received: from [24.34.116.197] by web111301.mail.gq1.yahoo.com via HTTP; Fri, 10 Dec 2010 05:58:24 PST X-Mailer: YahooMailClassic/11.4.20 YahooMailWebService/0.8.107.285259 Date: Fri, 10 Dec 2010 05:58:24 -0800 (PST) From: Andy Subject: Re: Hardware recommendations To: Benjamin Krajmalnik , alan bryan Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.908 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/147 X-Sequence-Number: 41599 =0A=0A> We use ZFS and use SSDs for both the log device and=0A> L2ARC.=A0 A= ll disks=0A> and SSDs are behind a 3ware with BBU in single disk=0A> mode.= =A0 =0A=0AOut of curiosity why do you put your log on SSD? Log is all seque= ntial IOs, an area in which SSD is not any faster than HDD. So I'd think pu= tting log on SSD wouldn't give you any performance boost.=0A=0A=0A