David Fetter wrote:
On Fri, Aug 03, 2007 at 09:25:41AM +0200, [EMAIL PROTECTED] wrote:
Am Donnerstag, 2. August 2007 22:37 schrieben Sie:
On Thu, Aug 02, 2007 at 11:58:40AM +0200, [EMAIL PROTECTED] 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/
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
