Thread: temp tablespaces and SSDs, etc..

temp tablespaces and SSDs, etc..

From
Jon Nelson
Date:
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 reports ENOSPC and then fall back to SSD, finally falling
back to spinning rust.  Is there a way to do this?

--
Jon


Re: temp tablespaces and SSDs, etc..

From
Bruce Momjian
Date:
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
> prefer them - in that order - until they each get full. IE, use tmpfs
> until it reports ENOSPC and then fall back to SSD, finally falling
> back to spinning rust.  Is there a way to do this?

Nope.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +