Postgres Pro
Downloads
Home   >   mailing lists

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

From Sameer Kumar
Subject Re: Non-pausing table scan on 9.6 replica?
Date
Msg-id CADp-Sm6U_DfzhE=seN60qS9yUoQXsLSD24qkRZhiJd16X3H=Jw@mail.gmail.com
Whole thread Raw
In response to Re: Non-pausing table scan on 9.6 replica?  (Mark Fletcher <markf@corp.groups.io>)
List pgsql-general
Tree view


On Thu, Mar 7, 2019 at 5:16 AM Mark Fletcher <markf@corp.groups.io> wrote:
Andreas, Sameer,

Thank you for replying. I did not understand the purpose of hot_standby_feedback, and your explanations helped. I turned it on, and the pausing stopped.

Great!
But do bear in mind that this is also not without its own implications. As pointed out by Andreas, this could lead to bloats.

Which version of PostgreSQL are you using? Sorry if I have missed that information.


 Thanks,
Mark

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: python install location
Next
From: Noah Misch
Date:
Subject: Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes