Re: WIP: new system catalog pg_wait_event

Hi,

On 8/19/23 12:00 PM, Michael Paquier wrote:
> On Sat, Aug 19, 2023 at 11:35:01AM +0200, Drouvot, Bertrand wrote:
>> Hi,
>>
>> On 8/18/23 12:31 PM, Michael Paquier wrote:
>> Thanks! Please find attached v9 fixing this typo.
>
> I was looking at v8, and this looks pretty good to me.

Great!

> I have
> spotted a few minor things.
>
> + proretset => 't', provolatile => 's', prorettype => 'record',
> This function should be volatile.

Oh right, I copied/pasted this and should have paid more attention to
that part. Fixed in v10 attached.

> By the way, shouldn't the results of GetWaitEventExtensionNames() in
> the SQL function be freed? I mean that:
> for (int idx = 0; idx < nbextwaitevents; idx++)
> pfree(waiteventnames[idx]);
> pfree(waiteventnames);
>

I don't think it's needed. The reason is that they are palloc in a
short-lived memory context while executing pg_get_wait_events().

> + /* Handling extension custom wait events */
> Nit warning: s/Handling/Handle/, or "Handling of".

Thanks, fixed in v10.

Regards,

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