On Mon, Dec 30, 2013 at 10:27 AM, Sergey Konoplev <gray.ru@gmail.com> wrote:
On Mon, Dec 30, 2013 at 12:02 AM, Joe Van Dyk <joe@tanga.com> wrote: > On Sun, Dec 29, 2013 at 10:52 PM, Sergey Konoplev <gray.ru@gmail.com> wrote: >> On Sun, Dec 29, 2013 at 9:56 PM, Joe Van Dyk <joe@tanga.com> wrote: >> > On Wed, Dec 18, 2013 at 3:39 PM, Sergey Konoplev <gray.ru@gmail.com> >> > wrote:
>> > If I run "COPY (select * from complicate_view) to stdout" on the >> > standby, >> > I've noticed that sometimes halts replication updates to the slave. >> > >> > For example, that's happening right now and "now() - >> > pg_last_xact_replay_timestamp()" is 22 minutes. There's many >> > transactions >> > per second being committed on the master. Once that query is canceled, >> > the >> > slave catches up immediately. >> >> And what >> >> \x >> select * from pg_stat_repication; >> >> shows? >
> on the master, right?
Yes.
And it would be very useful to take a look at your checkpoints and replication configuration parameters on both master and replica.