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

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?
Date: 2016-10-18 18:25:01
Message-ID: cd5ed826-2dcf-9bb6-ef5c-3aa8a578e40c@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 10/18/2016 12:57 AM, digoal(at)126(dot)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

In response to

Browse pgsql-bugs by date

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