Postgres Pro
Downloads
Home   >   mailing lists

some queries on standby preventing replication updates - Mailing list pgsql-general

From Joe Van Dyk
Subject some queries on standby preventing replication updates
Date
Msg-id CACfv+pKSoLVMo2+j2GYtGXK-DMbk6_B5hsmny6P_jQbSsSFxaA@mail.gmail.com
Whole thread Raw
Responses Re: some queries on standby preventing replication updates
List pgsql-general
Tree view
Hi,

I have a master and a slave database. 

I've got hot_standby_feedback turned on, max_standby_streaming_delay=-1. I've configured the master and slave to keep a few days of WALs around.

I've noticed that when some large queries are run on the standby machine (ones that take more than a minute or so), replication updates are paused. Is there a way to fix this?

Thanks,
Joe

pgsql-general by date:

Previous
From: David G Johnston
Date:
Subject: Re: Emulating flexible regex replace
Next
From: Миша Тюрин
Date:
Subject: Re[2]: [GENERAL] DBlink, postgres to DB2