From: | Koichi Suzuki <koichi(dot)dbms(at)gmail(dot)com> |
---|---|
To: | desmodemone <desmodemone(at)gmail(dot)com> |
Cc: | Sergei Sheinin <sergei(dot)sheinin(at)gmail(dot)com>, Mario Splivalo <mario(at)splivalo(dot)hr>, fahad basheer <fahad(dot)a(dot)basheer(at)gmail(dot)com>, pgsql-cluster-hackers(at)postgresql(dot)org |
Subject: | Re: Postgresql Write cluster needed |
Date: | 2014-11-24 00:28:39 |
Message-ID: | CABEZHFt1AJeCHfR0zpxtroDyqpPpTOdKByviNCR8ycFrtFHxvA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cluster-hackers |
Write scalability for OLTP workload is available with Postgres-XC.
---
Koichi Suzuki
2014-11-21 21:15 GMT+09:00 desmodemone <desmodemone(at)gmail(dot)com>:
>
>
> 2014-11-21 12:56 GMT+01:00 Sergei Sheinin <sergei(dot)sheinin(at)gmail(dot)com>:
>>
>> It may be possible to write to text files then use COPY command for bulk
>> inserts.
>>
>> On Fri, Nov 21, 2014 at 6:38 PM, Mario Splivalo <mario(at)splivalo(dot)hr> wrote:
>>>
>>> Unless you shard (partition) your data, writes can't be scaled.
>>>
>>> Mario
>>>
>>>
>>> On November 21, 2014 12:29:38 PM CET, fahad basheer
>>> <fahad(dot)a(dot)basheer(at)gmail(dot)com> wrote:
>>>>
>>>> Hi ALL,
>>>>
>>>> I need to scale postgresql with write capabilities, please help me.
>>>>
>>>> Regards
>>>> Fahad
>>>
>>>
>>> --
>>> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>>
>>
>
>
> Hi,
> I think we need more informations about this problem and how it's
> the enviroment (OLTP, dwh ? ) . For example if some tables not need to be
> full ACID you could use unlogged table or for example you could relax the
> durability of the commit , disabling synchronous commit .
>
> Regards
>
>
> --
> Matteo Durighetto
>
> - - - - - - - - - - - - - - - - - - - - - - -
>
> Italian PostgreSQL User Group
> Italian Community for Geographic Free/Open-Source Software
From | Date | Subject | |
---|---|---|---|
Next Message | fahad basheer | 2014-11-24 09:30:34 | Re: Postgresql Write cluster needed |
Previous Message | desmodemone | 2014-11-21 12:15:09 | Re: Postgresql Write cluster needed |