arisb·قبل 8 سنوات·discussIf you are only reading from a table I don't think any relational database implementing MVCC would lock anything.
arisb·قبل 8 سنوات·discussFunctions don't have to be optimization barries. If you mark them as stable or immutable I believe postgres will inline them whenever they are used such that they can be optimized.