Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A38B16324FB for ; Sun, 8 Aug 2010 07:10:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 07450-08 for ; Sun, 8 Aug 2010 10:10:15 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ey0-f174.google.com (mail-ey0-f174.google.com [209.85.215.174]) by mail.postgresql.org (Postfix) with ESMTP id AE1AC6321E9 for ; Sun, 8 Aug 2010 07:10:14 -0300 (ADT) Received: by eya25 with SMTP id 25so3176989eya.19 for ; Sun, 08 Aug 2010 03:10:12 -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 :user-agent:mime-version:to:cc:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=ha2shUFbhRGVIAi1wSfb5WWz9rD5f//0bCBSakbVZpY=; b=a1JXdQPLsD+qs2hC/uu2A8j/tD38UrACOGc0V+rm5CEGQlhhbUYuZEIyZgJv1UZAwK eFDBLZdAQPJTObqsiKVFjKGc/dar2UmeNxd4BhX83TasykHO0IaKhin6XZuJzjBg1kRl A92RrKLqWaSed+XqOYsxIQWhqJXzb1RjzdVfE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; b=g7ySMixcQtkWIpU7wdEgZmvO0/Y+m+rkgeLajgQzSOVfLRFDhNGJQ7GX3CBE2291VI zDJel93dN88Q51Ix0+rGTRSgQSVUGWR8tuNH29x2BbA/MnSOOisALS5C8fVZNbjx4dgp z0CfN+VmxOnXbTHkFdNpzFUQ0L73b5uBPLLdg= Received: by 10.213.5.5 with SMTP id 5mr10722756ebt.72.1281262212209; Sun, 08 Aug 2010 03:10:12 -0700 (PDT) Received: from [0.0.0.0] (5357DA75.cable.casema.nl [83.87.218.117]) by mx.google.com with ESMTPS id a48sm5765865eei.0.2010.08.08.03.10.10 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sun, 08 Aug 2010 03:10:11 -0700 (PDT) Message-ID: <4C5E82F7.8040700@gmail.com> Date: Sun, 08 Aug 2010 12:12:07 +0200 From: Yeb Havinga User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Michael March CC: pgsql-performance@postgresql.org Subject: Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201008/99 X-Sequence-Number: 39942 Michael March wrote: > If anyone is interested I just completed a series of benchmarks of > stock Postgresql running on a normal HDD vs a SSD. > > If you don't want to read the post, the summary is that SSDs are 5 to > 7 times faster than a 7200RPM HDD drive under a pgbench load. > > http://it-blog.5amsolutions.com/2010/08/performance-of-postgresql-ssd-vs.html > > Is this what everyone else is seeing? I tested a SSD with a capacitor and posted conclusions here http://archives.postgresql.org/pgsql-performance/2010-07/msg00449.php regards, Yeb Havinga