Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A428964FD20 for ; Sat, 5 Jul 2008 03:41:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 52014-08 for ; Sat, 5 Jul 2008 03:41:38 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.174]) by postgresql.org (Postfix) with ESMTP id 1494F64FD1D for ; Sat, 5 Jul 2008 03:41:39 -0300 (ADT) Received: by wf-out-1314.google.com with SMTP id 25so1390517wfc.28 for ; Fri, 04 Jul 2008 23:41:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=xrTEwh1EJOakBkTARXxwxk9JP4u3YxN2klBjEtFH2ZA=; b=v6sn+Dbap1/HFyapzIDI1qvqID0jyACdOQp3+/q1OHkknG8GYuEWpWtytNI6qh8Ezx /W5HNAy1Qr5SeD0h6H2Q7Ijeev7OBNg2YpaiHopoOTO/hvJ/oogUgi2nhAqyr0IKNKlr 7h+9hYBzZlJWrP6vOjGQ6CreMOXLryX/zDDFc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=o/XrbmkLrBiVM2QgPbZ2S4qZipjF5S79Hv4BHJIZj1m3xJObLwfSVIUODCnfwuFS6u M3C2y8tAiw6erqY935tVDnMoY8+hTGZbUt2VhV2Y9bnJ3fy6VOe3NTTEWjQIARQ7z2Rj mMPeuRq1SW5+ZvtAlCttRyzhNkQDnxpQi1I7I= Received: by 10.142.245.6 with SMTP id s6mr501953wfh.157.1215240098945; Fri, 04 Jul 2008 23:41:38 -0700 (PDT) Received: by 10.142.242.21 with HTTP; Fri, 4 Jul 2008 23:41:38 -0700 (PDT) Message-ID: Date: Fri, 4 Jul 2008 23:41:38 -0700 From: "Jeffrey Baker" To: "pgsql-performance@postgresql.org" Subject: Re: Fusion-io ioDrive In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/49 X-Sequence-Number: 30649 On Tue, Jul 1, 2008 at 5:18 PM, Jeffrey Baker wrote: > I recently got my hands on a device called ioDrive from a company > called Fusion-io. The ioDrive is essentially 80GB of flash on a PCI > card. [...] > Service Time Percentile, millis > R/W TPS R-O TPS 50th 80th 90th 95th > RAID 182 673 18 32 42 64 > Fusion 971 4792 8 9 10 11 Essentially the same benchmark, but on a quad Xeon 2GHz with 3GB main memory, and the scale factor of 300. Really all we learn from this exercise is the sheer futility of throwing CPU at PostgreSQL. R/W TPS: 1168 R-O TPS: 6877 Quadrupling the CPU resources and tripling the RAM results in a 20% or 44% performance increase on read/write and read-only loads, respectively. The system loafs along with 2-3 CPUs completely idle, although oddly iowait is 0%. I think the system is constrained by context switch, which is tens of thousands per second. This is a problem with the ioDrive software, not with pg. Someone asked for bonnie++ output: Block output: 495MB/s, 81% CPU Block input: 676MB/s, 93% CPU Block rewrite: 262MB/s, 59% CPU Pretty respectable. In the same ballpark as an HP MSA70 + P800 with 25 spindles. -jwb