pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Parkirat Bagga <parkiratbagga@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Streaming Replication (Master Delta Sync)
Date: Thu, 18 Oct 2012 10:32:36 -0700 (PDT)
Message-ID: <1350581556187-5728876.post@n5.nabble.com> (raw)
In-Reply-To: <D960CB61B694CF459DCFB4B0128514C208902834@exadv11.host.magwien.gv.at>
References: <1350506045391-5728704.post@n5.nabble.com>
	<CAP=oouG3pKKeyv22h+E-DvzG4fmtKTy4b28FdVTu_c7bUv6BVA@mail.gmail.com>
	<1350507684535-5728709.post@n5.nabble.com>
	<CAP=oouE-cMq66=ZG=N1CdMf_t7T2x4MLS9_Zd0FyXMgPHd0Fng@mail.gmail.com>
	<D960CB61B694CF459DCFB4B0128514C208902834@exadv11.host.magwien.gv.at>

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.ht...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.




view thread (10+ messages)  latest in thread

Message-ID: <1350581556187-5728876.post@n5.nabble.com>
Permalink:  ../1350581556187-5728876.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1350581556187-5728876.post@n5.nabble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: parkiratbagga@gmail.com
  Subject: Re: Streaming Replication (Master Delta Sync)
  In-Reply-To: <1350581556187-5728876.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox