From: | hariprasath nallasamy <hariprasathnallasamy(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | too may LWLocks |
Date: | 2017-03-08 10:04:56 |
Message-ID: | CAGgejVzjQZ=iX9uqhx89O-N1DA-O3hUGkcpB7eQ=KDxPXq=Xeg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Yogesh Sharma | 2017-03-08 10:42:50 | Re: Request to confirm which command is use for exclusive operation |
Previous Message | Albe Laurenz | 2017-03-08 09:47:00 | Re: Postgres, apps, special characters and UTF-8 encoding |