没有合适的资源?快使用搜索试试~ 我知道了~
首页Internals Of PostgreSQL Wal.pdf
Internals Of PostgreSQL Wal.pdf
2星 需积分: 50 16 下载量 3 浏览量
更新于2023-05-12
评论
收藏 108KB PDF 举报
postgresql大神 代码级讲述WAll文件的构成、产生、使用 是学习postgresql不可缺少的环节 WAL就是预先写入日志,用于数据保全的 跟Oracle的REDO文件是一种意思
资源详情
资源评论
资源推荐
WAL Internals Of
PostgreSQL
Contents
REDO Definition
Redo Implementation in PostgreSQL
Key Structures Used in PostgreSQL
Advantages & Disadvantages of PostgreSQL Implementation
Redo Implementation in Oracle
Advantages & Disadvantages of Oracle Implementation
Improvements in PostgreSQL
Detailed method for one of the improvements
REDO Definition
• Redo logs contain a history of all changes made to the database.
• Redo log files are used by
– Recovery
– Incremental Backup and Point In Time Recovery
– Replication
• Every change made to the database is written to the redo log file
before it is written to the data file.
• The redo log buffer is flushed to the redo log file when a COMMIT
is issued.
• A background log writer process to flush Redo in case if the
database setting is such that Redo should be flushed in a batch.
• Redo is not required for temporary tables.
REDO Definition
Redo Implementation in PostgreSQL
Key Structures Used in PostgreSQL
Advantages & Disadvantages of PostgreSQL Implementation
Redo Implementation in Oracle
Advantages & Disadvantages of Oracle Implementation
Improvements in PostgreSQL
Detailed method for one of the improvements
Jargons
• WAL – Write Ahead Log. It is used in context of transaction log files.
• Xlog - Transaction log. It is used in context of transaction log
buffers.
• LSN –
Log sequence number. It is used to mark position of log in
pages.
• Bgwriter –
Background writer.This is used to flush shared buffers
and perform checkpoint.
• Clog - Commit log. It is used in context of transaction status buffers.
• Partial Page Write –
This happens when OS is able to write partial
page in disk files which can cause corruption.
剩余50页未读,继续阅读
wim1234
- 粉丝: 0
- 资源: 27
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- zigbee-cluster-library-specification
- JSBSim Reference Manual
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论1