Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 029F9B5DC4A
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 28 Oct 2011 16:55:55 -0300 (ADT)
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 86783-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 28 Oct 2011 19:55:49 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from mail.nuevasync.com (server13-scl.nuevasync.com [64.13.157.153])
	by mail.postgresql.org (Postfix) with ESMTP id 10B32B5DC07
	for <pgsql-performance@postgresql.org>;
	Fri, 28 Oct 2011 16:55:49 -0300 (ADT)
Received: from [69.145.82.243] (unknown [69.145.82.243])
	by mail.nuevasync.com (Postfix) with ESMTP id CC184458001
	for <pgsql-performance@postgresql.org>;
	Fri, 28 Oct 2011 13:30:01 -0600 (MDT)
Message-ID: <4EAB08C5.7050206@boreham.org>
Date: Fri, 28 Oct 2011 13:55:49 -0600
From: David Boreham <david_list@boreham.org>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: WAL in RAM
References: <4EAACA17.7010503@engene.se>
	<CAHyXU0xNW6ihoqWMn7tyqP5iEsYB-63v=+FiGVXDkQtWiw=CtQ@mail.gmail.com>
	<70afb7c488aca8f564f4b569f857747b.squirrel@sq.gransy.com>
In-Reply-To: <70afb7c488aca8f564f4b569f857747b.squirrel@sq.gransy.com>
Content-Type: text/plain; charset=UTF-8; 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: 201110/265
X-Sequence-Number: 45487

On 10/28/2011 12:26 PM, Tomas Vondra wrote:
> For example the Intel 710 SSD has a sequential write speed of 210MB/s,
> while a simple SATA 7.2k drive can write about 50-100 MB/s for less than
> 1/10 of the 710 price.
Bulk data transfer rates mean almost nothing in the context of a database
(unless you're for example backing it up by copying the files to another 
machine...)
The key factor typically is small block writes/s (for WAL) and random 
small block
reads/s (for data). 710 or similar performance SSDs will deliver on the 
order
of 20-50x the performance of a traditional hard drive in these areas.