Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 0D80F9FB39D; Tue, 24 Oct 2006 21:57:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 24552-01; Wed, 25 Oct 2006 00:57:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from exprod6og50.obsmtp.com (exprod6og50.obsmtp.com [64.18.1.181]) by postgresql.org (Postfix) with SMTP id E74869FA5D8; Tue, 24 Oct 2006 21:57:07 -0300 (ADT) Received: from source ([63.240.6.47]) by exprod6ob50.postini.com ([64.18.5.12]) with SMTP; Tue, 24 Oct 2006 17:57:03 PDT Received: from 172.16.1.25 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Tue, 24 Oct 2006 20:56:54 -0400 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01HOST03.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 24 Oct 2006 20:56:53 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Subject: Re: Replication documentation addition Date: Tue, 24 Oct 2006 20:56:16 -0400 Message-ID: <3E37B936B592014B978C4415F90D662D04C5BC1C@MI8NYCMAIL06.Mi8.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [HACKERS] Replication documentation addition Thread-Index: Acb3ytdlr3i+zX1CRTaepOJ4GTq8ZwABDFBg From: "Luke Lonergan" To: "Bruce Momjian" , "Hannu Krosing" cc: "PostgreSQL-documentation" , "PostgreSQL-development" X-OriginalArrivalTime: 25 Oct 2006 00:56:53.0451 (UTC) FILETIME=[762C49B0:01C6F7D0] X-WSS-ID: 692069DF3WC983231-02-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/1319 X-Sequence-Number: 93216 Bruce,=20 > -----Original Message----- > From: pgsql-hackers-owner@postgresql.org=20 > [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Bruce Momjian > Sent: Tuesday, October 24, 2006 5:16 PM > To: Hannu Krosing > Cc: PostgreSQL-documentation; PostgreSQL-development > Subject: Re: [HACKERS] Replication documentation addition >=20 >=20 > OK, I have updated the URL. Please let me know how you like it. There's a typo on line 8, first paragraph: "perhaps with only one server allowing write rwork together at the same time." Also, consider this wording of the last description: "Single-Query Clustering..." Replaced by: "Shared Nothing Clustering ----------------------- This allows multiple servers with separate disks to work together on a each query. In shared nothing clusters, the work of answering each query is distributed among the servers to increase the performance through parallelism. These systems will typically feature high availability by using other forms of replication internally. While there are no open source options for this type of clustering, there are several commercial products available that implement this approach, making PostgreSQL achieve very high performance for multi-Terabyte business intelligence databases." - Luke