Re: How to solve "too many Lwlocks taken"?

Hi,

On 2023-02-07 22:16:36 +0800, jacktby@gmail.com wrote:
> 
> I'm trying to write am table_am extension. But I get "too many Lwlocks taken" after I insert 
> too many tuples. So I try to use UnLockBuffers() everywhere; but it still give me "too many Lwlocks taken",
> So how should I release All locks?

This indicates that you aren't actually releasing all the lwlocks. You can
inspect
static int	num_held_lwlocks = 0;
static LWLockHandle held_lwlocks[MAX_SIMUL_LWLOCKS];
in a debugger to see which locks you didn't release.


You're currently starting multiple threads with questions a week. Could you at
least keep them in one thread?

Greetings,

Andres Freund