Re: [PERFORM] temp tablespaces and SSDs, etc..

2013-02-15 Thread Bruce Momjian
On Fri, Feb 8, 2013 at 02:52:37PM -0600, Jon Nelson wrote: > I was wondering if somebody could clear up how tablespaces are used. > Let's say I have three classes of storage: > - ramdisk (tmpfs) > - SSD > - spinning rust > > Furthermore, let's say I'd like to be able to tell postgresql to > prefe

[PERFORM] temp tablespaces and SSDs, etc..

2013-02-08 Thread Jon Nelson
I was wondering if somebody could clear up how tablespaces are used. Let's say I have three classes of storage: - ramdisk (tmpfs) - SSD - spinning rust Furthermore, let's say I'd like to be able to tell postgresql to prefer them - in that order - until they each get full. IE, use tmpfs until it re