摘要:
-- 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)
摘要:
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)
摘要:
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)