Hi, On 2023-02-07 22:16:36 +0800, jack...@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