are analyze statistics synced with replication?

Поиск
Список
Период
Сортировка
От Kevin Goess
Тема are analyze statistics synced with replication?
Дата
Msg-id CABZkbxh-_F1cv9E93XVDBUpwQwm0XRvwaAkM1x0VWRmExs15wA@mail.gmail.com
обсуждение исходный текст
Ответы Re: are analyze statistics synced with replication?
Список pgsql-general
Дерево обсуждения
We have a master/slave setup with replication.  Today we failed over to the slave and saw disk I/O go through the roof.  

Are the pg_statistic statistics synced along with streaming replication? Are you expected to have to do a vacuum analyze after failing over?  That's what we're trying now to see if it makes a difference.  Our next step will be to fall back to the first host and see where this one went wrong (society?  lax discipline at home? the wrong sort of friends?)


В списке pgsql-general по дате отправления:

Предыдущее
От: Keith
Дата:
Сообщение: Re: what should be the best autovacuum configuration for daily partition table
Следующее
От: Khangelani Gama
Дата:
Сообщение: Correct update statement