Hi all,
I am using Postgres 9.0.3 in production with Slony 2.0.6 for replication.
I am currently testing the streaming replication with 9.0.3. My database
contains 100 GBytes of data (6000 tables).
I have 1 master node and 3 slave nodes. The 1st slave node is in the same
datacenter as the maste
Jean-Armel Luce wrote:
> Please, could you help me to understand why it is so long to rsync
> the data from the new master to the other slaves ?
Your post is a little light on details. I think the most useful
information would be the output of:
rysnc --version
and the exact rsync command
On 10/31/2011 07:28 PM, Brian Fehrle wrote:
The main thing I am currently seeing is that there are 300X or more
buffers written by checkpoints rather than background writer.
Writing buffers at checkpoint time is more efficient than having the
background writer handle them. I think your effo
Jean-Armel Luce writes:
> Hi all,
>
> I am using Postgres 9.0.3 in production with Slony 2.0.6 for replication.
> I am currently testing the streaming replication with 9.0.3.? My database
> contains 100 GBytes of data (6000 tables).
>
> I have 1 master node and 3 slave nodes. The 1st slave node
