turbo_zone的博客

表锁LOCK [ TABLE ] [ ONLY ] name [ * ] [, ...] [ IN lockmode MODE ] [ NOWAIT ]lockmode包括以下几种：ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE| SHARE | SHARE ROW EXCLUSIVE | EXCLUSIV...

测试步骤建表create table if not exists test_100000 ( id serial primary key, name varchar(50), password varchar(50), description varchar(50))create table if not exists test_1000000 ( ...