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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
