Re: SSD performance

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?

James