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

From John R Pierce
Subject Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?
Date
Msg-id cd5ed826-2dcf-9bb6-ef5c-3aa8a578e40c@hogranch.com
Whole thread Raw
In response to BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?  (digoal@126.com)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #14379: Different results
Next
From: Andres Freund
Date:
Subject: Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?