Re: Postgresql Write cluster needed

Поиск
Список
Период
Сортировка
От fahad basheer
Тема Re: Postgresql Write cluster needed
Дата
Msg-id CAKk-ntxisNWpVeJGqkBz_-DYySHYbJKnv47VLq1jRtf0P_v_vA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql Write cluster needed  (Koichi Suzuki <koichi.dbms@gmail.com>)
Ответы Re: Postgresql Write cluster needed  (Mario Splivalo <mario@splivalo.hr>)
Список pgsql-cluster-hackers
Hi All,

Thanks for the fast response

Database is used as OLTP database.

Frontend application used is  OpenERP.

I have tried postgresql xc,but its not supported with OpenERP.




On Mon, Nov 24, 2014 at 5:58 AM, Koichi Suzuki <koichi.dbms@gmail.com> wrote:
Write scalability for OLTP workload is available with Postgres-XC.
---
Koichi Suzuki


2014-11-21 21:15 GMT+09:00 desmodemone <desmodemone@gmail.com>:
>
>
> 2014-11-21 12:56 GMT+01:00 Sergei Sheinin <sergei.sheinin@gmail.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@splivalo.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.a.basheer@gmail.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


Regards,
Fahad

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

Предыдущее
От: Koichi Suzuki
Дата:
Сообщение: Re: Postgresql Write cluster needed
Следующее
От: Mario Splivalo
Дата:
Сообщение: Re: Postgresql Write cluster needed