Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TOtxa-0000Tl-AA for pgsql-admin@postgresql.org; Thu, 18 Oct 2012 17:32:42 +0000 Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TOtxV-0006Pl-Gs for pgsql-admin@postgresql.org; Thu, 18 Oct 2012 17:32:41 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1TOtxU-0008S4-6f for pgsql-admin@postgresql.org; Thu, 18 Oct 2012 10:32:36 -0700 Date: Thu, 18 Oct 2012 10:32:36 -0700 (PDT) From: Parkirat Bagga To: pgsql-admin@postgresql.org Message-ID: <1350581556187-5728876.post@n5.nabble.com> In-Reply-To: References: <1350506045391-5728704.post@n5.nabble.com> <1350507684535-5728709.post@n5.nabble.com> Subject: Re: Streaming Replication (Master Delta Sync) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.0 (/) X-Archive-Number: 201210/77 X-Sequence-Number: 40193 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.