Re: Specifications for a new server

Поиск
Список
Период
Сортировка
От Dorian Hoxha
Тема Re: Specifications for a new server
Дата
Msg-id CANsFX04Sp29toW_FboqZGZ4+8U2p+2Lq_RFpW4xXKcr71YYpMQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Specifications for a new server  (Johann Spies <johann.spies@gmail.com>)
Список pgsql-performance
Why do you even want to use JBOD?

Not for postgresql , but for distributed filesystems like hdfs/qfs (which are supposed to work on JBOD) with hypertable on top (so the nvram would help with the commits, since it is the biggest bottleneck when writing(commits need to be saved to multiple servers before 'ok' is returned in the client)).


On Thu, May 8, 2014 at 10:28 AM, Johann Spies <johann.spies@gmail.com> wrote:



On 8 May 2014 10:11, Johann Spies <johann.spies@gmail.com> wrote:

Question: How do I dedicate a partition to indexes?  Were do I configure PostgreSQL to write them in a particular area?



I just discovered TABLESPACE which answered my question.

Regards
Johann

--
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

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

Предыдущее
От: Johann Spies
Дата:
Сообщение: Re: Specifications for a new server
Следующее
От: Clinton Adams
Дата:
Сообщение: Re: Check memory consumption of postgresql query