Re: Mixing an SSD and Spinning drive for best performance

Поиск
Список
Период
Сортировка
От Casey Allen Shobe
Тема Re: Mixing an SSD and Spinning drive for best performance
Дата
Msg-id CAFmVg3hcwsZwj8_jB2n3YSc9SfhBnuqXke2Dkn869uPbK8HKkA@mail.gmail.com
обсуждение исходный текст
Ответ на Mixing an SSD and Spinning drive for best performance  (postgresql.org@solomonson.com)
Список pgsql-admin
Дерево обсуждения
On Fri, Jan 4, 2013 at 10:31 PM, <postgresql.org@solomonson.com> wrote:

I'm thinking that option #2 is the best. But, I wonder if moving the OS on the SSD will give me a boost. I'm not too concerned about boot up time or OS responsiveness as much as getting more speed out of my DB queries.  I have plenty of space on both drives for the data and OS with room to spare.

I agree, though you probably want to consider setting up multiple tablespaces, so that you can move data between disk subsystems via alter.

Cheers,
--
Casey Allen Shobe
casey@shobe.info


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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Postgres base Backup fails to recover all logs fails from archive
Следующее
От: Casey Allen Shobe
Дата:
Сообщение: Re: How to implement the 'GRANT ALL ON DB1 TO 'USER'@'%' of MYSQL in PostgreSQL