Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D55691337BA3 for ; Thu, 23 Dec 2010 15:58:28 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 96423-10 for ; Thu, 23 Dec 2010 19:58:21 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm6-vm0.bullet.mail.sp2.yahoo.com (nm6-vm0.bullet.mail.sp2.yahoo.com [98.139.91.206]) by mail.postgresql.org (Postfix) with SMTP id 1C04213364DE for ; Thu, 23 Dec 2010 15:58:20 -0400 (AST) Received: from [98.139.91.67] by nm6.bullet.mail.sp2.yahoo.com with NNFMP; 23 Dec 2010 19:58:19 -0000 Received: from [98.139.91.26] by tm7.bullet.mail.sp2.yahoo.com with NNFMP; 23 Dec 2010 19:58:19 -0000 Received: from [127.0.0.1] by omp1026.mail.sp2.yahoo.com with NNFMP; 23 Dec 2010 19:58:19 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 163244.75155.bm@omp1026.mail.sp2.yahoo.com Received: (qmail 73424 invoked by uid 60001); 23 Dec 2010 19:58:18 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1293134298; bh=Uay0OKMWAF+MoycfamQrK1TNFEfKCY6fDdzG0LvS6Jc=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=myfHsm3qK2W4+FLAaIlO26pMRlqFidtXA2TbohCUuKsaVkhazUoXD2UMzAmvGLPcKVqBc8TTGKzxEh5pu2uS+Zk0ADvaMc0+YaK7GrZtCqbL4sadX//gAe9dKRZVnMn1K9aWAyoqyJU92HkE2xx7E+P7Klff0vx9iQE/+m2KcCI= 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:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Or3nnfNyT7lqGQ0KCkC5rjtety88SDX3FX6dw+WgdGwjHb6+l68N8SLZTTvBdTGLpIMtOJNnqycnPeRQqKiFs3dH4vxdAbC20uG86qfORpgLV9m2dJv8mIjIDS6k3pft7aGNDkJF+DGH6M33E/oMfpbCUtSShpkfP5ktXMH5Vt8=; Message-ID: <409661.69535.qm@web111313.mail.gq1.yahoo.com> X-YMail-OSG: HuzDub8VM1mnBf6X2jPgHohNcDcygARXrFrEDi9IQPHF_Gn 2MC3Kcvdfqv3lQ5MQwtxvU9PoEGumOHSALsR5TLqfVbjNMa3Bih4F62ivsuU 16RyEo20YyGDvD6pJHDfsBwwP7nGvzUiK5qmeqq77sLuNWIlXAhIP.G_wPBO EelB3uFO2iSXNVuqzFXYe.01eJnQvqwOIo_RdDTwSPd8qRYw9rnawn6wKNEY V7L.jOnIYgpsnQAvKFQ7QLBluQ1uUrg08JLmMJp0MUyPbZRrIo4S_QRDZAcg fTVZgfg9RztmSjvuTMpB5bBE20ufTstKCxkuBfZr5M9ajqxYxqKtUqroZtZd fDJwc.cIhw.T_oS8uokKO3aul5_BVbGOnrac7NssuUknGfUo074l4rnQOaEi jRPJAezAX7jk- Received: from [24.34.116.197] by web111313.mail.gq1.yahoo.com via HTTP; Thu, 23 Dec 2010 11:58:18 PST X-Mailer: YahooMailClassic/11.4.20 YahooMailWebService/0.8.107.285259 Date: Thu, 23 Dec 2010 11:58:18 -0800 (PST) From: Andy Subject: Re: concurrent IO in postgres? To: "wozniak@lanl.gov" , "pgsql-performance@postgresql.org" , John W Strange 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=-0.009 tagged_above=-10 required=5 tests=BAYES_40=-0.001, 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/299 X-Sequence-Number: 41751 =0A--- On Thu, 12/23/10, John W Strange wrote= :=0A=0A> Typically my problem is that the=0A> large queries are simply CPU = bound..=A0 do you have a=0A> sar/top output that you see. I'm currently set= ting up two=0A> FusionIO DUO @640GB in a lvm stripe to do some testing with= ,=0A> I will publish the results after I'm done.=0A> =0A> If anyone has som= e tests/suggestions they would like to see=0A> done please let me know.=0A>= =0A> - John=0A=0ASomewhat tangential to the current topics, I've heard tha= t FusionIO uses internal cache and hence is not crash-safe, and if the cach= e is turned off performance will take a big hit. Is that your experience?= =0A=0A=0A