Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUG] postgresql replaying WAL slowly when master drop a largenumber of relations in one transaction - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: [BUG] postgresql replaying WAL slowly when master drop a largenumber of relations in one transaction
Date
Msg-id 20180530172001.GA22225@paquier.xyz
Whole thread Raw
In response to [BUG] postgresql replaying WAL slowly when master drop a large number of relations in one transaction  ("158306855" <anderson2013@qq.com>)
Responses Re: [BUG] postgresql replaying WAL slowly when master drop a largenumber of relations in one transaction  ("158306855" <anderson2013@qq.com>)
List pgsql-bugs
Tree view 
On Wed, May 30, 2018 at 10:38:01AM +0800, 158306855 wrote:
> 3 But, the problem drop relation buffers by function
> DropRelFileNodesAllBuffers, that call by smgrdounlink. Each relation
> search the entire shared_buffer. This is unnecessary and can be
> optimized.

Yes, this is a known problem.  Fujii Masao has written a patch which
will likely get committed in v12.  Please see this thread:
https://www.postgresql.org/message-id/CAHGQGwHVQkdfDqtvGVkty+19cQakAydXn1etGND3X0PHbZ3+6w@mail.gmail.com
--
Michael
Attachment

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #15220: upgrade
Next
From: Alexandr Blinov
Date:
Subject: BUG: postgresql.auto.conf location