Re: Streaming replication performance

On Thu, Aug 11, 2011 at 9:46 AM, Antonin Faltynek <pin007@gmail.com> wrote:
> Hi all,
>
> I'm testing Streamin replication with one hot standby node and I'm
> experiencing high delay of hot standby node.
>
> When I reach aprox. 50 transactions per second where every transaction
> includes only simple "UPDATE status SET number = number + 1 WHERE name =
> 'iterations'", the standby server falls behind master and the delay is several
> minutes. In comparison, Slony1 have no issues with the same test and its delay
> is only several seconds.
>
> Am I missing some configuration that affects speed of streaming replicaiton?

hm -- how are you determining the standby is behind?  are you running
any other queries on the standby?

merlin