On Wed, Oct 26, 2016 at 2:46 PM, Tsunakawa, Takayuki
<tsunakawa.ta...@jp.fujitsu.com> wrote:
> If the stats collector is forcibly terminated on the standby in streaming 
> replication configuration, it won't be restarted until 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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to