temp tablespaces and SSDs, etc..

Поиск
Список
Период
Сортировка
От Jon Nelson
Тема temp tablespaces and SSDs, etc..
Дата
Msg-id CAKuK5J3uYTFaWk4ep2XNZHyVm7t4hLPoJWZ_GZi+j92jg=e6pg@mail.gmail.com
обсуждение исходный текст
Ответы Re: temp tablespaces and SSDs, etc..
Список pgsql-performance
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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Stefan Keller
Дата:
Сообщение: Re: FTS performance issue probably due to wrong planner estimate of detoasting
Следующее
От: "Foster, Kristian B (HSC)"
Дата:
Сообщение: Query Time is Slow