On Thu, 26 Feb 2015 10:40:31 -0500 John Scalia <jayknowsunix@xxxxxxxxx> wrote: > Apologies, David, but as I don't check this list very often, I > thought you should have received an answer. Have you tried watching > the transaction with tcpdump or wireshark? Yes. Haven't observed anything unusual. > To me this sounds like either a network problem or like you're > thinking a contention problem. It is not a network problem; we monitor the link between sites. And it happens absolutely regularly, like clockwork, when we run our nightly pg_dump on the master. > Also, are you running streaming replication? If so, there > shouldn't be ANY delay as the standby gets the commit before the > primary. Otherwise, how are you replicating? -- Jay We are running asynchronous streaming replication. Regards, David. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
