Re: Testing Sandforce SSD - Mailing list pgsql-performance

From Greg Smith
Subject Re: Testing Sandforce SSD
Date
Msg-id 4C575DCF.3050700@2ndquadrant.com
Whole thread Raw
In response to Re: Testing Sandforce SSD  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Testing Sandforce SSD
List pgsql-performance
Josh Berkus wrote:
> That doesn't make much sense unless there's some special advantage to a
> 4K blocksize with the hardware itself.

Given that pgbench is always doing tiny updates to blocks, I wouldn't be
surprised if switching to smaller blocks helps it in a lot of situations
if one went looking for them.  Also, as you point out, pgbench runtime
varies around wildly enough that 10% would need more investigation to
really prove that means something.  But I think Yeb has done plenty of
investigation into the most interesting part here, the durability claims.

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


pgsql-performance by date:

Previous
From: Maciek Sakrejda
Date:
Subject: Re: Optimizing NOT IN plans / verify rewrite
Next
From: Scott Marlowe
Date:
Subject: Re: Testing Sandforce SSD