From: | Michael Stone <mstone+postgres(at)mathom(dot)us> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Testing Sandforce SSD |
Date: | 2010-07-29 14:45:34 |
Message-ID: | 54cd1c80-9b1f-11df-9b6a-001cc0cda50c@msgid.mathom.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-07-29 15:20:45 | Re: planner index choice |
Previous Message | tv | 2010-07-29 11:14:54 | Re: planner index choice |