On Tue, 27 Jan 2009, James Mansion wrote:
Craig Ringer wrote:
These devices would be interesting for a few uses, IMO. One is temp
table space and sort space in Pg. Another is scratch space for apps
(like Photoshop) that do their own VM management. There's also potential
Surely temp tables and sort space isn't subject to fsync and won't gain that
much since they
should stay in the OS cache? The device will surely help seek- or sync-bound
tasks.
Doesn't that make it a good candidate for WAL and hot tables?
it doesn't just gain on fsync speed, but also raw transfer speed.
if everything stays in the OS buffers than you are right, but when you
start to exceed those buffers is when fast storage like this is very
useful.
David Lang
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
