Database Concurrent transaction control 4: postgresql database lock mechanism 2: Table lock, postgresql database
In the blog article "Database Concurrent transaction control 4: postgresql database lock mechanism"
Http://blog.csdn.net/beiigang/article/details/43302947
As mentioned later:
For more information about the general locking mechanism, see the official PostgreSQL manual. For more information about the chapters and content, see the following.
13.3. Explicit Locking
Http://www.postgresql.org/docs/9.4/static/explicit-locking.html
This section includes table lock, row lock, page lock, deadlock, and Advisory lock ??? Advice lock, announcement lock, consultation lock ???).
The following content outlines:
Table lock,
Row lock,
Page lock,
Deadlock,
Advisory lock (how can I translate this name ??? Consultation lock, announcement lock, consultation lock ???) ,
View the lock.
I feel a little tired and lazy. I don't want to write it anymore. I will go to the Internet to find some articles from my colleagues, classmates, and friends and put them here for classification, if necessary, sort out the organization based on my ideas next time. Complete the questions this time.
Continue here. The following content