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

help / color / mirror / Atom feed
From: Michael Stone <mstone+postgres@mathom.us>
To: pgsql-performance@postgresql.org
Subject: Re: Testing Sandforce SSD
Date: Thu, 29 Jul 2010 10:45:34 -0400
Message-ID: <54cd1c80-9b1f-11df-9b6a-001cc0cda50c@msgid.mathom.us> (raw)
In-Reply-To: <4C503473.5080105@gmail.com>
References: <4C4C83DF.3010703@gmail.com>
	<4C4C8CCC.7080406@gmail.com>
	<alpine.DEB.2.00.1007261045470.20471@aragorn.flymine.org>
	<4C4D6396.5020707@gmail.com>
	<4C4DAAE8.3060501@2ndquadrant.com>
	<4C4DE50B.1060102@gmail.com>
	<4C4DE5C9.8090004@2ndquadrant.com>
	<AANLkTimwAqzvWvSfscqDKJDG3Yod=6KQ6e0Xo+c+k6s=@mail.gmail.com>
	<e7e05556-9a42-11df-9b6a-001cc0cda50c@msgid.mathom.us>
	<4C503473.5080105@gmail.com>

On Wed, Jul 28, 2010 at 03:45:23PM +0200, Yeb Havinga wrote:
>Due to the LBA remapping of the SSD, I'm not sure of putting files 
>that are sequentially written in a different partition (together with 
>e.g. tables) would make a difference: in the end the SSD will have a 
>set new blocks in it's buffer and somehow arrange them into sets of 
>128KB of 256KB writes for the flash chips. See also 
>http://www.anandtech.com/show/2899/2

It's not a question of the hardware side, it's the software. The xlog
needs to by synchronized, and the things the filesystem has to do to 
make that happen penalize the non-xlog disk activity. That's why my 
preferred config is xlog on ext2, rest on xfs. That allows the 
synchronous activity to happen with minimal overhead, while the parts 
that benefit from having more data in flight can do that freely.

Mike Stone



view thread (60+ messages)  latest in thread

Message-ID: <54cd1c80-9b1f-11df-9b6a-001cc0cda50c@msgid.mathom.us>
Permalink:  ../54cd1c80-9b1f-11df-9b6a-001cc0cda50c@msgid.mathom.us/
Also on:    postgresql.org/message-id/54cd1c80-9b1f-11df-9b6a-001cc0cda50c@msgid.mathom.us

 · 

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: mstone+postgres@mathom.us
  Subject: Re: Testing Sandforce SSD
  In-Reply-To: <54cd1c80-9b1f-11df-9b6a-001cc0cda50c@msgid.mathom.us>

* 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