From: | fahad basheer <fahad(dot)a(dot)basheer(at)gmail(dot)com> |
---|---|
To: | Koichi Suzuki <koichi(dot)dbms(at)gmail(dot)com> |
Cc: | desmodemone <desmodemone(at)gmail(dot)com>, Sergei Sheinin <sergei(dot)sheinin(at)gmail(dot)com>, Mario Splivalo <mario(at)splivalo(dot)hr>, pgsql-cluster-hackers(at)postgresql(dot)org |
Subject: | Re: Postgresql Write cluster needed |
Date: | 2014-11-24 09:30:34 |
Message-ID: | CAKk-ntxisNWpVeJGqkBz_-DYySHYbJKnv47VLq1jRtf0P_v_vA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)dbms(at)gmail(dot)com>
wrote:
> 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
>
Regards,
Fahad
From | Date | Subject | |
---|---|---|---|
Next Message | Mario Splivalo | 2014-11-24 10:21:53 | Re: Postgresql Write cluster needed |
Previous Message | Koichi Suzuki | 2014-11-24 00:28:39 | Re: Postgresql Write cluster needed |