[GENERAL] too may LWLocks

Поиск
Список
Период
Сортировка
От hariprasath nallasamy
Тема [GENERAL] too may LWLocks
Дата
Msg-id CAGgejVzjQZ=iX9uqhx89O-N1DA-O3hUGkcpB7eQ=KDxPXq=Xeg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] too may LWLocks  (Julien Rouhaud <julien.rouhaud@dalibo.com>)
Список pgsql-general
Дерево обсуждения
Hi all
I am building an extension using shared memory hash table and for locking hash table i am using LWLocks, but the thing was when i try to run some 1k queries one after other, for each query i am getting one LWLock but on executing 200th query i am getting the error ERROR:  too many LWLocks taken.

But in each query i acquire and release that block. So that lock has to be flushed after executing query, but why am i getting this error.?

Is this due to held_lwlocks in LWLock.c is fixed only to some number 200 here.
Or am i missing something here.?


thanks
harry

В списке pgsql-general по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: [GENERAL] Postgres, apps, special characters and UTF-8 encoding
Следующее
От: Yogesh Sharma
Дата:
Сообщение: Re: [GENERAL] Request to confirm which command is use for exclusive operation