Re: Streaming Replication (Master Delta Sync)

From: Parkirat Bagga <parkiratbagga(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Streaming Replication (Master Delta Sync)
Date: 2012-10-18 17:32:36
Message-ID: 1350581556187-5728876.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks Albe.

For the delay between 2 machines, the data insertions is happening at 8K tps
and each record is around 1KB. So a total of 8Mb/s of data is getting
inserted in the Master PG.

The slave is not in different region but in different availability zone
(same region) on EC2. Sorry for the typo above.

We are using x1.large machines and PG-9.1 for both Master and Slave.

What, I have observed that there is always only one sender process sending
the data. Is it possible with any configuration that I can optimize this
system for more current and less overhead on master. We are not thinking
in-terms of long running queries.

Regards,
Parkirat Singh Bagga.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-Replication-Master-Delta-Sync-tp5728704p5728876.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Parkirat Bagga 2012-10-18 17:34:25 Re: WAL corruption while replication
Previous Message mike@trausch.us 2012-10-18 16:58:08 Re: Migration from Postgresql 9 to Oracle 10g