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@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
