Re: pgpool2 vs sequoia

David Fetter wrote:
> On Fri, Aug 03, 2007 at 09:25:41AM +0200, mljv@planwerk6.de wrote:
>> Am Donnerstag, 2. August 2007 22:37 schrieben Sie:
>>> On Thu, Aug 02, 2007 at 11:58:40AM +0200, mljv@planwerk6.de wrote:
>>>> Hi,
>>>>
>>>> i would like to use a statement replication for postgresql
>>> Why?
>> i have read
>> http://www.postgresql.org/docs/8.2/interactive/high-availability.html
>>
>> i want 4 synchronous databases with load balancing, so my
>> application has high performance and high availability.

synchronous replication <> high performance without lots of $$$$$$

Use a caching server or something like plproxy.

>
> Very few people actually need synchronous replication, and those who
> do buy Oracle's RAC (and curse it) or use DB2's offering (and also
> curse it ;).  For most purposes, fast asynchronous replication is good
> enough.
>
> Cheers,
> David.


--

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/