Re: SSD performance

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