LwLockRelease performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi 
The performance bottleneck in LWLockRelease()method goes through an array one by one to see which lock was released with O(N). As soon as the lock is found it performs an array to remove the lock.
As linear search and compaction delays the release of the lock forcing the other Postgres instances WAiting for the lock to be released 
Is any possible solution like 
1. LWLockRelease() releases the lock first and then remove held lock from the array
2. Binary search (like non-linear structure) to reduce on high searching and remove all held locks 


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux