Re: [BUG] postgresql replaying WAL slowly when master drop a large number of relations in one transaction

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: 158306855 <anderson2013(at)qq(dot)com>
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [BUG] postgresql replaying WAL slowly when master drop a large number of relations in one transaction
Date: 2018-05-30 17:20:01
Message-ID: 20180530172001.GA22225@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexandr Blinov 2018-05-30 17:23:31 BUG: postgresql.auto.conf location
Previous Message David G. Johnston 2018-05-30 15:12:57 Re: BUG #15220: upgrade