pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Greg Smith <greg@2ndquadrant.com>
To: Yeb Havinga <yebhavinga@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Testing Sandforce SSD
Date: Tue, 03 Aug 2010 10:02:19 -0400
Message-ID: <4C58216B.7050401@2ndquadrant.com> (raw)
In-Reply-To: <4C57D5FD.9040306@gmail.com>
References: <4C4A9452.9070100@gmail.com>
	<4C4B1F84.5030306@2ndquadrant.com>
	<4C4B4B41.7000800@2ndquadrant.com>
	<4C52E957.8020304@gmail.com>
	<AANLkTinNX63EsRtNjtKeeygymWjH8VA3EWwxBzXGCy0=@mail.gmail.com>
	<4C56DD8B.6050303@gmail.com>
	<4C5744F5.3020805@agliodbs.com>
	<4C575DCF.3050700@2ndquadrant.com>
	<AANLkTikQ=CUSoRy+MxYA2TAfk2hdipA4Uz_qYXyu+yhR@mail.gmail.com>
	<4C57D5FD.9040306@gmail.com>

Yeb Havinga wrote:
> Small IO size: 4 KB
> Maximum Small IOPS=86883 @ Small=8 and Large=0
>
> Small IO size: 8 KB
> Maximum Small IOPS=48798 @ Small=11 and Large=0

Conclusion:  you can write 4KB blocks almost twice as fast as 8KB ones.  
This is a useful observation about the effectiveness of the write cache 
on the unit, but not really a surprise.  On ideal hardware performance 
should double if you halve the write size.  I already wagered the 
difference in pgbench results is caused by the same math.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us

view thread (60+ messages)  latest in thread

Message-ID: <4C58216B.7050401@2ndquadrant.com>
Permalink:  ../4C58216B.7050401@2ndquadrant.com/
Also on:    postgresql.org/message-id/4C58216B.7050401@2ndquadrant.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: greg@2ndquadrant.com, yebhavinga@gmail.com, scott.marlowe@gmail.com, josh@agliodbs.com
  Subject: Re: Testing Sandforce SSD
  In-Reply-To: <4C58216B.7050401@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox