arisb·il y a 8 ans·discussIf you are only reading from a table I don't think any relational database implementing MVCC would lock anything.
arisb·il y a 8 ans·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.