Postgres Pro
Downloads
Home   >   mailing lists

Re: Specifications for a new server - Mailing list pgsql-performance

From Dorian Hoxha
Subject Re: Specifications for a new server
Date
Msg-id CANsFX04Sp29toW_FboqZGZ4+8U2p+2Lq_RFpW4xXKcr71YYpMQ@mail.gmail.com
Whole thread Raw
In response to Re: Specifications for a new server  (Johann Spies <johann.spies@gmail.com>)
List pgsql-performance
Tree view
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 by date:

Previous
From: Johann Spies
Date:
Subject: Re: Specifications for a new server
Next
From: Clinton Adams
Date:
Subject: Re: Check memory consumption of postgresql query