Message-ID: <351810d2-120b-9b90-a680-cce6ac1c0fa7@gmail.com>
Date: Fri, 9 Jun 2023 06:26:07 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0)
 Gecko/20100101 Thunderbird/102.12.0
Subject: Re: Introduce WAIT_EVENT_EXTENSION and WAIT_EVENT_BUFFER_PIN
To: Michael Paquier <michael@paquier.xyz>,
 Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Andres Freund <andres@anarazel.de>,
 PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
References: <20230516001716.iy7no2q77vwdt5w2@awork3.anarazel.de>
 <ZGLQnikZoxsqj2dl@paquier.xyz>
 <20230516010102.jwmsuaoynz6zfqmn@awork3.anarazel.de>
 <ZGMRMrrz02v8MGTE@paquier.xyz>
 <CA+TgmobtMj42OoAqETwhmiNU3k9LB+MiZhK+qdKg4Jh3Dq-Dag@mail.gmail.com>
 <20230517233832.si5zpq3qnxmx3swb@awork3.anarazel.de>
 <CA+TgmoaYTd3YN3N3vtXi+X63ePOzAdiKfVYX-BROtpWSdF-Auw@mail.gmail.com>
 <ZGaocGfirEt6OXNP@paquier.xyz>
 <81290a48-b25c-22a5-31a6-3feff5864fe3@gmail.com>
 <4420c7fb5bf0894ce92d6857a8d041ed@oss.nttdata.com>
 <ZIJhEhRkAGavghW6@paquier.xyz>
Content-Language: en-US
From: "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com>
In-Reply-To: <ZIJhEhRkAGavghW6@paquier.xyz>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/351810d2-120b-9b90-a680-cce6ac1c0fa7%40gmail.com>
Precedence: bulk

Hi,

On 6/9/23 1:15 AM, Michael Paquier wrote:
> On Thu, Jun 08, 2023 at 10:57:55AM +0900, Masahiro Ikeda wrote:
>> (Excuse me for cutting in, and this is not directly related to the thread.)
>> +1. I'm interested in the feature.
>>
>> This is just a example and it probable be useful for other users. IMO, at
>> least, it's better to improve the specification that "Extension"
>> wait event type has only the "Extension" wait event.
> 
> I hope that nobody would counter-argue you here.  In my opinion, we
> should just introduce an API that allows extensions to retrieve wait
> event numbers that are allocated by the backend under
> PG_WAIT_EXTENSION, in a fashion similar to GetNamedLWLockTranche().
> Say something like:
> int GetExtensionWaitEvent(const char *wait_event_name);

+1, that's something I've in mind to work on once/if this patch is/get
committed.

Regards,

-- 
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com