Unverified50% confidenceFactExact time
Flush only sends the SQL; the transaction remains open and row locks are not released until the transaction commits or rolls back, so another thread can observe and wait on that lock.
1
Sources
50%
Confidence
Long-term
Relevance
10/20/2026
First Seen
Sources
Related Entities
Related Claims
UnverifiedPostgreSQL maintains a lock manager in shared memory, and when acquiring a row lock it places an entry in the lock table identifying the relation, block number and specific tuple offset.66% similarUnverifiedPostgreSQL的锁体系分为表级锁、行级锁和轻量级锁（LWLock）三个层次61% similarUnverifiedLatch does not collect any usage data; the unlock logic runs entirely locally, NFC and QR-code unlocks are both processed on-device, and step data is not uploaded either.60% similarUnverifiedA secure data write process should first look up the user's real OpenID on the backend, then save it together with the data to prevent unauthorized writes.57% similar
Cite This Claim
Stable URI
https://kongchang.com/claim/1072917API
curl https://kongchang.com/api/v1/knowledge/claims/1072917MCP
get_claim(id=1072917)