pg库sharelock_pg中关于AccessShareLock和ExclusiveLock的问题-问答-阿里云开发者社区-阿里云...

HI，要搞清楚锁，首先要搞清楚，PG是有很多可以加锁的对象的，每种对象下面，再去看它的锁冲突。

可以加锁的对象：

LOCKTAG_RELATION, /* whole relation */

/* ID info for a relation is DB OID + REL OID; DB OID = 0 if shared */

LOCKTAG_RELATION_EXTEND, /* the right to extend a relation */

/* same ID info as RELATION */

LOCKTAG_PAGE, /* one page of a relation */

/* ID info for a page is RELATION info + BlockNumber */

LOCKTAG_TUPLE, /* one physical tuple */

/* ID info for a tuple is PAGE info + OffsetNumber */

LOCKTAG_TRANSACTION, /* transaction (for waiting for xact done) */

/* ID info for a transaction is its TransactionId */

LOCKTAG_VIRTUALTRANSACTION, /* virtual transaction (ditto) */

/* ID info for a virtual transaction is its VirtualTransactionId */

LOCKTAG_SPECULATIVE_TOKEN, /* speculative insertion Xid and token */

/* ID info for a transaction is its TransactionId */

LOCKTAG_OBJECT, /* non-relation database object */

/* ID info for an object is DB OID + CLASS OID + OBJECT OID + SUBID */

/*

* Note: object ID has same representation as in pg_depend and

* pg_description, but notice that we are constraining SUBID to 16