Re: [HACKERS] [PATCHES] replication docs: split single vs.

2006-11-17 Thread Bruce Momjian
I have renamed the documentation section "High Availability and Load Balancing". I think the current version takes many of your comments below into account. Please let me know. --- Markus Schiltknecht wrote: > Good morning

Re: [HACKERS] [PATCHES] replication docs: split single vs.

2006-11-17 Thread Bruce Momjian
Markus Schiltknecht wrote: > Hello Bruce, > > You wrote: > > I am still feeling that data partitioning is like master/slave > > replication because you have to get that read-only copy to the other > > server. > > Yes, that's where replication comes into play. But data partitioning per > se has

Re: [HACKERS] [PATCHES] replication docs: split single vs.

2006-11-17 Thread Bruce Momjian
Hannu Krosing wrote: > ?hel kenal p?eval, R, 2006-11-17 kell 00:01, kirjutas Bruce Momjian: > > > > Current version at: > > > > > > > > http://momjian.us/main/writings/pgsql/sgml/failover.html > > it refers to "Warm Standby Using Point-In-Time > Recovery" (http://momjian.us/main/writings/pgsq

Re: [HACKERS] [PATCHES] replication docs: split single vs.

2006-11-17 Thread Bruce Momjian
Hannu Krosing wrote: > > OK. I am still feeling that data partitioning is like master/slave > > replication because you have to get that read-only copy to the other > > server. If you split things up so data sets resided on only one > > machine, you are right that would not be replication, but do

Re: [HACKERS] [PATCHES] replication docs: split single vs. multi-master

2006-11-17 Thread Markus Schiltknecht
Good morning Hannu, Hannu Krosing wrote: People do that in cases where there is high write loads ("high" as in "not 10+ times less than reads") and just replicating the RO copies would be prohibitively expensive in either network, cpu or memory terms. Okay. It that case it's even less like any

Re: [HACKERS] [PATCHES] replication docs: split single vs. multi-master

2006-11-17 Thread Markus Schiltknecht
Hello Bruce, You wrote: I am still feeling that data partitioning is like master/slave replication because you have to get that read-only copy to the other server. Yes, that's where replication comes into play. But data partitioning per se has nothing to do with replication, has it? You can

Re: [HACKERS] [PATCHES] replication docs: split single vs.

2006-11-16 Thread Hannu Krosing
Ühel kenal päeval, R, 2006-11-17 kell 00:01, kirjutas Bruce Momjian: > > > Current version at: > > > > > > http://momjian.us/main/writings/pgsql/sgml/failover.html it refers to "Warm Standby Using Point-In-Time Recovery" (http://momjian.us/main/writings/pgsql/sgml/warm-standby.html), maybe i

Re: [HACKERS] [PATCHES] replication docs: split single vs.

2006-11-16 Thread Hannu Krosing
Ühel kenal päeval, R, 2006-11-17 kell 00:01, kirjutas Bruce Momjian: > Markus Schiltknecht wrote: > > Not mentioning that categorization doesn't help in clearing the > > confusion. Just look around, most people use these terms. They're used > > by MySQL and Oracle. Even Microsofts ActiveDirectory

Re: [HACKERS] [PATCHES] replication docs: split single vs. multi-master

2006-11-16 Thread Bruce Momjian
Markus Schiltknecht wrote: > Not mentioning that categorization doesn't help in clearing the > confusion. Just look around, most people use these terms. They're used > by MySQL and Oracle. Even Microsofts ActiveDirectory seems to have a > multi-master operation mode. OK. > > For example, Slony