博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
postgres 锁
阅读量:6319 次
发布时间:2019-06-22

本文共 1928 字,大约阅读时间需要 6 分钟。

hot3.png

p *allProcs

$46 = {links = {prev = 0x0, next = 0x0}, procgloballist = 0x7f1b6135fd98, sem = {semId = 524288, semNum = 0}, waitStatus = 0, procLatch = {is_set = 0, is_shared = 1 '\001', owner_pid = 0}, lxid = 0, pid = 0, pgprocno = 0, backendId = 0, databaseId = 0, roleId = 0, recoveryConflictPending = 0 '\000', lwWaiting = 0 '\000', lwWaitMode = 0 '\000', lwWaitLink = {prev = 0x0, next = 0x0}, waitLock = 0x0, waitProcLock = 0x0, waitLockMode = 0, heldLocks = 0, waitLSN = 0, syncRepState = 0, syncRepLinks = {prev = 0x0, next = 0x0}, myProcLocks = {{prev = 0x7f1b6135fe98, next = 0x7f1b6135fe98}, {prev = 0x7f1b6135fea8,next = 0x7f1b6135fea8}, {prev = 0x7f1b6135feb8, next = 0x7f1b6135feb8}, {prev = 0x7f1b6135fec8, next = 0x7f1b6135fec8}, {prev = 0x7f1b6135fed8, next = 0x7f1b6135fed8}, {prev = 0x7f1b6135fee8, next = 0x7f1b6135fee8}, {prev = 0x7f1b6135fef8, next = 0x7f1b6135fef8}, {prev = 0x7f1b6135ff08, next = 0x7f1b6135ff08}, {prev = 0x7f1b6135ff18, next = 0x7f1b6135ff18}, {prev = 0x7f1b6135ff28, next = 0x7f1b6135ff28}, {prev = 0x7f1b6135ff38, next = 0x7f1b6135ff38}, {prev = 0x7f1b6135ff48, next = 0x7f1b6135ff48}, {prev = 0x7f1b6135ff58, next = 0x7f1b6135ff58}, {prev = 0x7f1b6135ff68, next = 0x7f1b6135ff68}, {prev = 0x7f1b6135ff78, next = 0x7f1b6135ff78}, {prev = 0x7f1b6135ff88, next = 0x7f1b6135ff88}}, subxids = {xids = {0 
}}, procArrayGroupMember = 0 '\000', procArrayGroupNext = {value = 0}, procArrayGroupMemberXid = 0, wait_event_info = 0, backendLock = {tranche = 13, state = {value = 536870912}, waiters = {head = {prev = 0x7f1b613600b0, next = 0x7f1b613600b0}}}, fpLockBits = 0, fpRelId = {0
}, fpVXIDLock = 0 '\000', fpLocalTransactionId = 0, lockGroupLeader = 0x0, lockGroupMembers = { head = {prev = 0x7f1b61360118, next = 0x7f1b61360118}}, lockGroupLink = {prev = 0x0, next = 0x0}}

PgXact

每个进程里只能存在一个事物

转载于:https://my.oschina.net/innovation/blog/810243

你可能感兴趣的文章
高并发系统设计参考
查看>>
面向切面的基本概念
查看>>
linux网络管理三剑客
查看>>
我的友情链接
查看>>
决心书
查看>>
Linux下 su命令与su - 命令的区别
查看>>
CentOS7使用firewalld打开关闭防火墙与端口
查看>>
浅谈jsp的7个动作
查看>>
[精华][推荐]CAS SSO单点登录服务端客户端学习
查看>>
squid缓存服务器
查看>>
SVN服务器搭建
查看>>
干货 | VMAF视频质量评估在视频云转码中的应用
查看>>
数组-在Shell脚本中的基本使用介绍
查看>>
elk日志收集
查看>>
iOS runtime实用篇:让你快速上手一个项目
查看>>
ConfigurationProperties
查看>>
从本机发送信息到另一台服务器上时中文乱码
查看>>
网络慢是带宽不足?优化网络带宽的5个小窍门
查看>>
一个Java方法能有多少个参数类型?这个好奇coder做了个实验
查看>>
Django使用已经存有数据的mysql数据库
查看>>