Non-pausing table scan on 9.6 replica?

From: Mark Fletcher <markf(at)corp(dot)groups(dot)io>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Non-pausing table scan on 9.6 replica?
Date: 2019-03-06 00:26:12
Message-ID: CAEO096oCNF+Hg08SmcrRGPhnVA6StgiCw7HbOUULPN8i8o3=gQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-03-06 00:49:28 Re: Connection Drop from PostgreSQL Database Server
Previous Message Matthew Pounsett 2019-03-05 23:52:36 Re: [External] LIMIT not showing all results