Re: temp tablespaces and SSDs, etc.. - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: temp tablespaces and SSDs, etc..
Date
Msg-id 20130216003238.GB12029@momjian.us
Whole thread Raw
In response to temp tablespaces and SSDs, etc..  (Jon Nelson <jnelson+pgsql@jamponi.net>)
List pgsql-performance
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. +


pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Surprising no use of indexes - low performance
Next
From: Nicolas Charles
Date:
Subject: Re: Surprising no use of indexes - low performance