Re: Postgre and Web Request - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: Postgre and Web Request
Date
Msg-id 20040429.174451.115902788.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Postgre and Web Request  (Shridhar Daithankar <shridhar@frodo.hserus.net>)
List pgsql-general
> > (replication ?, I'm not sure there is a realtime solution of replication with
> > PostgreSQL able to accep 10000 insert by second ... for the moment !?)

pgpool(annouced at general/announce list) is a synchronous single
master replication solution and it runs UPDATE/INSERT about 2/3 speed
of a normal PostgreSQL. So if you are lucky enough to aquire good
hardware which can run normal PostgreSQL with 15000 INSERTs, you could
obtain that speed with replication.

> > And second point ... to talk about beowulf cluster .... is there any solution
> > for PostgreSQL ? We here talking many time about MySQL solution for that ...
> > why PostgreSQL do not have this kind of solution, yet ?
>
> Ohh. good question.. there are so many facets of this problems that it would
> take a book...:-)
>
> There are many replication solutions for postgresql. Most of them do async
> replication quite nicely. Synchronous multimaster replication isn't there AFAIK.
> But I could be out of touch..

PGCluster (http://www.csra.co.jp/~mitani/jpug/pgcluster/en/index.html) is a
synchronous multimaster replication solution.
--
Tatsuo Ishii

pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Postgre and Web Request
Next
From: Anton Nikiforov
Date:
Subject: Re: Partial index question