What is Postgres Session?
What is a Postgres session in the context of advisory locks ? Can two threads / processes share the same session?
+3
source to share
1 answer
According to this thread , session is "synonymous with TCP connection". The Session Information Feature support language also supports this.
So, in the context of a session-level advisory blocking, anything that shares the TCP connection will have access to the resource, and the resource will not be released unless it is explicitly unlocked or the TCP connection is closed.
+1
source to share