Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?
Дата
Msg-id cd5ed826-2dcf-9bb6-ef5c-3aa8a578e40c@hogranch.com
обсуждение исходный текст
Ответ на BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?  (digoal@126.com)
Список pgsql-bugs
On 10/18/2016 12:57 AM, digoal@126.com wrote:
> when i use postgresql 9.6.0 for primary-standby, i drop a schema on primary,
> but it's apply very slow on standby.
>
> the wal send very fast, but apply very slow, i think the syscall more than
> it on primary?

your table has 100 associated sequences, and 100 associated indexes,
along with 100 expression constraints?, and you're creating 500 of
these?   thats quite a lot of metadata.


--
john r pierce, recycling bits in santa cruz

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14379: Different results
Следующее
От: Andres Freund
Дата:
Сообщение: Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?