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

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.

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 people

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

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 nothing to

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. 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 is

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 seems

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 its a good