Re: Replication - Mailing list pgsql-hackers

From D'Arcy J.M. Cain
Subject Re: Replication
Date
Msg-id 20060823093736.bc063d42.darcy@druid.net
Whole thread Raw
In response to Re: Replication  (Hannu Krosing <hannu@skype.net>)
List pgsql-hackers
On Wed, 23 Aug 2006 12:42:11 +0300
Hannu Krosing <hannu@skype.net> wrote:
> > OK, that solves your problem.  How about my problem where replication
> > has to happen on servers in three countries on two continents and
> > thousands of updates a second have to happen in less that 10ms? 
> 
> For this scenario you are far better off with partitioning than
> replication. 
> 
> That is if your data is partitionable. But geographically distributed
> data often is.

I agree but in this case it wasn't.

-- 
D'Arcy J.M. Cain <darcy@druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Question about (lazy) vacuum
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCHES] Contrib module to examine client certificate