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