On Thu, Aug 11, 2011 at 9:46 AM, Antonin Faltynek <pin007@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
