ZhangZhihui's Blog  

2023年12月2日

摘要: -- name: ListAccounts :many SELECT * FROM accounts WHERE owner = $1 ORDER BY id LIMIT $2 OFFSET $3; -- name: UpdateAccount :one UPDATE accounts SET ba 阅读全文
posted @ 2023-12-02 23:09 ZhangZhihuiAAA 阅读(22) 评论(0) 推荐(0)
 
摘要: ERROR: deadlock detectedDETAIL: Process 209 waits for ShareLock on transaction 1034; blocked by process 201.Process 201 waits for ShareLock on transac 阅读全文
posted @ 2023-12-02 23:02 ZhangZhihuiAAA 阅读(371) 评论(0) 推荐(0)
 
摘要: pg_locks view Looking at pg_locks shows you what locks are granted and what processes are waiting for locks to be acquired. A good query to start look 阅读全文
posted @ 2023-12-02 22:26 ZhangZhihuiAAA 阅读(34) 评论(0) 推荐(0)