Re: Testing Sandforce SSD

Greg Spiegelberg wrote:
> Speaking of the layers in-between, has this test been done with the
> ext3 journal on a different device?  Maybe the purpose is wrong for
> the SSD.  Use the SSD for the ext3 journal and the spindled drives for
> filesystem?

The main disk bottleneck on PostgreSQL databases are the random seeks
for reading and writing to the main data blocks.  The journal
information is practically noise in comparison--it barely matters
because it's so much less difficult to keep up with.  This is why I
don't really find ext2 interesting either.

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