Re: temp tablespaces and SSDs, etc..

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: temp tablespaces and SSDs, etc..
Дата
Msg-id 20130216003238.GB12029@momjian.us
обсуждение исходный текст
Ответ на temp tablespaces and SSDs, etc..  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Список 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 по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Surprising no use of indexes - low performance
Следующее
От: Nicolas Charles
Дата:
Сообщение: Re: Surprising no use of indexes - low performance