| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | digoal(at)126(dot)com |
| Cc: | 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:32:08 |
| Message-ID: | 20161018183208.l4eso7sgnw25s7zu@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 2016-10-18 07:57:33 +0000, digoal(at)126(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14378
> Logged by: Zhou Digoal
> Email address: digoal(at)126(dot)com
> PostgreSQL version: 9.6.0
> Operating system: CentOS 6.x x64
> Description:
>
>
>
> 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?
>
> this is my test:
There's some O(n^2) behaviour around lock release and acquire during
replay IIRC. See for example the thread around
http://archives.postgresql.org/message-id/20140630231741.GA30918%40alap3.anarazel.de
It's not entirely trivial to fix that though. E.g. the patch of Simon's
later in that thread wouldn't help in your situation.
Greetings,
Andres Freund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hellkite500 | 2016-10-18 22:59:05 | BUG #14380: pg_config fails to build. |
| Previous Message | John R Pierce | 2016-10-18 18:25:01 | Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug? |