Non-pausing table scan on 9.6 replica? - Mailing list pgsql-general

From Mark Fletcher
Subject Non-pausing table scan on 9.6 replica?
Date
Msg-id CAEO096oCNF+Hg08SmcrRGPhnVA6StgiCw7HbOUULPN8i8o3=gQ@mail.gmail.com
Whole thread Raw
Responses Re: Non-pausing table scan on 9.6 replica?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Hi All,

On a 9.6 streaming replica, we do table scans for stats and other things. During these scans, the replication is paused (the 'recovering' postgres process has 'waiting' appended to it). We're not using transactions with these scans. Is there anything we can do to prevent the pausing?

Thanks,
Mark

pgsql-general by date:

Previous
From: Matthew Pounsett
Date:
Subject: Re: [External] LIMIT not showing all results
Next
From: Adrian Klaver
Date:
Subject: Re: Connection Drop from PostgreSQL Database Server