| From: | Dorian Hoxha <dorian(dot)hoxha(at)gmail(dot)com> |
|---|---|
| To: | Johann Spies <johann(dot)spies(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Specifications for a new server |
| Date: | 2014-05-08 11:44:12 |
| Message-ID: | CANsFX04Sp29toW_FboqZGZ4+8U2p+2Lq_RFpW4xXKcr71YYpMQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)spies(at)gmail(dot)com>wrote:
>
>
>
> On 8 May 2014 10:11, Johann Spies <johann(dot)spies(at)gmail(dot)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)
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Clinton Adams | 2014-05-08 14:04:01 | Re: Check memory consumption of postgresql query |
| Previous Message | Johann Spies | 2014-05-08 08:28:01 | Re: Specifications for a new server |