On Wed, Oct 26, 2016 at 2:46 PM, Tsunakawa, Takayuki
<tsunakawa.takay@jp.fujitsu.com> wrote:
> If the stats collector is forcibly terminated on the standby in streaming replication configuration, it won't be
restarteduntil the standby is promoted to the primary. The attached patch restarts the stats collector on the
standby.
>
> FYI, when the stats collector is down, SELECTs against the statistics views get stale data with the following
message.
>
> LOG: using stale statistics instead of current ones because stats collector is not responding
> STATEMENT: select * from pg_stat_user_tables
Oops. This could be a problem for some applications... As far as I can
see and after playing with it, your patch looks correct.
--
Michael