Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vu1uB-0002Dw-4y for pgsql-performance@arkaria.postgresql.org; Fri, 20 Dec 2013 15:22:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vu1uA-0002WN-25 for pgsql-performance@arkaria.postgresql.org; Fri, 20 Dec 2013 15:22:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vu1u8-0002WG-T5 for pgsql-performance@postgresql.org; Fri, 20 Dec 2013 15:22:20 +0000 Received: from nm27-vm1.bullet.mail.bf1.yahoo.com ([98.139.213.148]) by magus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vu1u1-0003PT-Ga for pgsql-performance@postgresql.org; Fri, 20 Dec 2013 15:22:20 +0000 Received: from [98.139.215.141] by nm27.bullet.mail.bf1.yahoo.com with NNFMP; 20 Dec 2013 15:22:10 -0000 Received: from [98.139.212.242] by tm12.bullet.mail.bf1.yahoo.com with NNFMP; 20 Dec 2013 15:22:10 -0000 Received: from [127.0.0.1] by omp1051.mail.bf1.yahoo.com with NNFMP; 20 Dec 2013 15:22:10 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 801798.76970.bm@omp1051.mail.bf1.yahoo.com Received: (qmail 3560 invoked by uid 60001); 20 Dec 2013 15:22:10 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1387552930; bh=wOBL3rsa8r+sjnljsBtdmOxrGcwqclUHpWzI19h6Ll0=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=rmidgpW2/gMvBEYtU4FFrcFJKJg3MFTqH1TmJrwEve3ddUI6yh9laerBHYFlg7S8Z9M3w2XK8KK21TuZJ7vx7e2D4swIPYtBUk6DgjEuACMlYrSwhye/hQb4XBJGkzR1c+S1do5RdDl0LX7GWhu6pB82mEWwemzkhwGZQgrTZrs= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=u9rgub89IpFyf7Ho0xTFTJsYO6aUwT75h7+BowBVh++9eo6I3u/jWdmDijLvO2hYm1agQjyoT2fUuuKDP37TuNsTHD4xIs28QcEakRomXlhjECZmiR4mlBnPSqQXn9D4leEM4oG1oI9isxZhXJDekRvK7VHcYQuCJbgZkrxBsSg=; X-YMail-OSG: 8Nh8seQVM1lthtbKH9hI_TL2FRYHoPl_157JaqMNoY5AxFN bh6Uhjydow2pFZ08E1OAmP6I8Fh36_BqxaeC5QDtdCmeJzPrlbzF2JexAgMz Mad42uEq.Al4E.haGgdHoAE3zEZ7nqAxKvxJdIIe78r_I9fWS.IP6zCEUzU8 X_cSEcnuyD3YnRJmemDCWicj_AOQjk11v_5alNZ8rYIonqSPy5fNE_gZ1x0j tGL0d3AmDtK3gRFsxVPu1fjpPB0wNBg28tEl2dFE6LfvM065s_NhZn7m4CHp m4vMNq43_TJOUsM1rYx5oGPDQ67z8rmURVvMzQ291k0uTkt5ybMWx52.nD4N gk00ksi9xD1d1IuMFuxav67I0Ux465ajA2zfIPb9gCxtYTHywEvDmNviCHKJ fZkqFo4IXErtfpLnUwgCvYs1LOALymexD09KgzPpyZiLAX2PPOT5YdvC0.Jp psbsrnGEMPnTUuNnAoB6mI2N9ybZS5QU9cIoy9LdPC2BqCPnphJEKXvMQToh y7bR0VgGGKGwP6JSdIBNivFe64TVnk4vNH.8yiCXSkxxKmug_hK_FZrQ66i9 u6UdBHiskTWRpunHbdZnY4dfldKBdpSv6GQGQR8s09KyHSt.uFYgxO5P2.PF VKeslbvCEpXg4V2D6ooGwSQtnrP4TwAd5JMKZf.NzqDDlFp4cDSuvx1AW8DI l_Wi4ipCnkClS81JeT4mnRGt0AFDsL3kVuAERF1K6Lc0- Received: from [76.255.18.237] by web162903.mail.bf1.yahoo.com via HTTP; Fri, 20 Dec 2013 07:22:10 PST X-Rocket-MIMEInfo: 002.001, RGF2ZSBKb2hhbnNlbiA8ZGF2ZWpvaGFuc2VuQGdtYWlsLmNvbT4gd3JvdGU6Cgo.IElzIHRoZXJlIGEgYmVuZWZpdCB0byBoYXZpbmcgdGhlIFdBTCBhbmQgbG9ncyBvbiB0aGUgc2VwYXJhdGUKPiBSQUlEIDE_IE9yIGlzIGp1c3QgaGF2aW5nIHRoZW0gYmUgcGFydCBvZiB0aGUgbGFyZ2VyIFJBSUQgMSswCj4ganVzdCBhcyBnb29kPwoKSSBvbmNlIGFjY2lkZW50YWxseSBsZWZ0IHRoZSBwZ194bG9nIGRpcmVjdG9yeSBvbiB0aGUgNDAtc3BpbmRsZQpSQUlEIHdpdGggbW9zdCBvZiB0aGUgZGF0YSBpbnN0ZWEBMAEBAQE- X-Mailer: YahooMailWebService/0.8.172.614 References: <52B33069.1060203@optionshouse.com> <52B44FD8.2030105@optionshouse.com> Message-ID: <1387552930.9150.YahooMailNeo@web162903.mail.bf1.yahoo.com> Date: Fri, 20 Dec 2013 07:22:10 -0800 (PST) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: Unexpected pgbench result To: Dave Johansen , Shaun Thomas Cc: pgsql-performance In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org Dave Johansen wrote: > Is there a benefit to having the WAL and logs on the separate > RAID 1? Or is just having them be part of the larger RAID 1+0 > just as good? I once accidentally left the pg_xlog directory on the 40-spindle RAID with most of the data instead of moving it.=A0 Results with graph here: http://www.postgresql.org/message-id/4B71358E020000250002F0E4@gw.wicourts.g= ov -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance