Colleagues incomprehensible situation: it seems that the statistics for autovacuum analyze is not passed to the slave. After a manual run, vacuum analyze all comes to life.
the essence of this is a frequently changing table when I request a replica I get on a big Heap Fetches: 18623 the request is made up to 400 msec as soon as the master starts vacuum analyze Heap Fetches: 6394 the request is executed 5-10 msec screwed to the table alter table callback SET (autovacuum_analyze_scale_factor = 0.0); alter table callback SET (autovacuum_analyze_threshold = 500); I see in the statistics of current requests the autovacuum on this table passes, but it does not help, the visibility data for this table are not updated for the slave -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
