暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
文档 / PG增删改页跟踪.pdf
PG增删改页跟踪.pdf
王语嫣
154
7页
5次
2022-08-17
免费下载
pd_lsn
0/B2689388
pd_checksum
0
pd_flags
0
pd_lower
28
pd_upper
8152
pd_special
8192
pd_pagesize_version
4
pd_prune_xid
0
Lp 1
8152
Tuple 1
\x010000000d6b6576696e
原始页
8152
kevin=# create table txid(id int,name varchar(30));
kevin=# insert into txid values(1,'kevin');
pd_lsn
0/B2689768
pd_checksum
0
pd_flags
0
pd_lower
48
pd_upper
7952
pd_special
8192
pd_pagesize_version
4
pd_prune_xid
0
Tuple 1
\x010000000d6b6576696e
Tuple 2
\x020000000d6b6576696e
Tuple 3
\x030000000d6b6576696e
Tuple 4
\x040000000d6b6576696e
Tuple 5
\x050000000d6b6576696e
Tuple 6
\x060000000d6b6576696e
插入
Lp 1
8152
Lp 2
8112
Lp 1
8152
Lp 3
8072
Lp 4
8032
Lp 5
7992
Lp 6
7952
815281128072803279927952
kevin=# insert into txid values(2,'kevin');
kevin=# insert into txid values(3,'kevin');
kevin=# insert into txid values(4,'kevin');
kevin=# insert into txid values(5,'kevin');
kevin=# insert into txid values(6,'kevin');
pd_lsn
0/B2689A10
pd_checksum
0
pd_flags
0
pd_lower
48
pd_upper
7952
pd_special
8192
pd_pagesize_version
4
pd_prune_xid
78371
Tuple 1
\x010000000d6b6576696e
Tuple 2
\x020000000d6b6576696e
Tuple 3
\x030000000d6b6576696e
Tuple 4
\x040000000d6b6576696e
Tuple 5
\x050000000d6b6576696e
Tuple 6
\x060000000d6b6576696e
删除
Lp 1
8152
Lp 2
8112
Lp 1
8152
Lp 3
8072
Lp 4
8032
Lp 5
7992
Lp 6
7952
815281128072803279927952
kevin=# delete from txid where id = 4;
of 7
免费下载
postgresql
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

相关文档

You Need a PostgreSQL Restore Plan.pdf
4浏览
2018 - Packt - Hans-Jurgen Schonig - Mastering PostgreSQL 11_ Expert techniques to build scalable, reliable, and fault-tolerant database applications.pdf
5浏览
Learning Heroku Postgres_ Efficiently design, implement, and manage a successful PostgreSQL database with Heroku.pdf
7浏览
Packt.Pub_PostgreSQL Server Programming 2nd (2017).pdf
8浏览
PostgreSQL 9.6 High Performance_ Optimize, troubleshoot, and benchmark your PostgreSQL database.pdf
10浏览
Amazon Aurora for PostgreSQL: Internals and Performance Optimization.pdf
13浏览

评论