| From: | Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com> |
|---|---|
| To: | Mark Fletcher <markf(at)corp(dot)groups(dot)io> |
| Cc: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Non-pausing table scan on 9.6 replica? |
| Date: | 2019-03-07 02:51:29 |
| Message-ID: | CADp-Sm6U_DfzhE=seN60qS9yUoQXsLSD24qkRZhiJd16X3H=Jw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Mar 7, 2019 at 5:16 AM Mark Fletcher <markf(at)corp(dot)groups(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2019-03-07 03:19:54 | Re: LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes |
| Previous Message | Adrian Klaver | 2019-03-07 00:23:32 | Re: python install location |