日本人妻巨大乳挤奶水免费,亚洲av之男人的天堂,日韩 欧美 动漫 国产 制服,川上奈美夫の上司に犯 在线观看

您的位置:首頁(yè) >觀察 > 正文

天天觀察:PostgreSQL的clog屬于日志還是數(shù)據(jù),需要遵守write-WAL-before-data嗎?


(資料圖片僅供參考)

總結(jié)

從原理上來看,MVCC需要給定事務(wù)ID后,能查詢到事務(wù)的狀態(tài)。

在PG中事務(wù)狀態(tài)可以從幾個(gè)路徑獲取:

在快照中查詢(活躍事務(wù))在元組頭的狀態(tài)為查詢(不活躍事務(wù))在CLOG中查詢(不活躍事務(wù))

如果不看實(shí)現(xiàn)只看概念,不活躍事務(wù)提交狀態(tài)也可以在XLOG中查詢,CLOG可以視作一種XLOG commit/rollback日志的緩存、映射,一種事務(wù)提交狀態(tài)的快速查詢方式。

所以在write-WAL-before-data中,CLOG也會(huì)按照data來處理,只有XLOG屬于WAL。

Postgresql中clog寫盤實(shí)現(xiàn)SlruPhysicalWritePage

postgresql中clog使用SLRU機(jī)制讀寫,在Slru寫盤前,會(huì)有保證xlog先寫的機(jī)制:

group_lsn表示32個(gè)事務(wù)一組中最大的日志序列號(hào)(LSN)。group_lsn主要用于事務(wù)提交非同步落盤的場(chǎng)景。
static boolSlruPhysicalWritePage(SlruCtl ctl, int pageno, int slotno, SlruWriteAll fdata){...if (shared->group_lsn != NULL){/* * We must determine the largest async-commit LSN for the page. This * is a bit tedious, but since this entire function is a slow path * anyway, it seems better to do this here than to maintain a per-page * LSN variable (which"d need an extra comparison in the * transaction-commit path). */XLogRecPtrmax_lsn;intlsnindex,lsnoff;lsnindex = slotno * shared->lsn_groups_per_page;max_lsn = shared->group_lsn[lsnindex++];for (lsnoff = 1; lsnoff < shared->lsn_groups_per_page; lsnoff++){XLogRecPtrthis_lsn = shared->group_lsn[lsnindex++];if (max_lsn < this_lsn)max_lsn = this_lsn;    <<<<<<<<<<<<<<<<<<<<<<<<< 找到最大的LSN}if (!XLogRecPtrIsInvalid(max_lsn)){/* * As noted above, elog(ERROR) is not acceptable here, so if * XLogFlush were to fail, we must PANIC.  This isn"t much of a * restriction because XLogFlush is just about all critical * section anyway, but let"s make sure. */START_CRIT_SECTION();XLogFlush(max_lsn);      <<<<<<<<<<<<<<<<<<<<<<<<< 先保證XLOG寫到這個(gè)位點(diǎn)!END_CRIT_SECTION();}}  ...  if (pg_pwrite(fd, shared->page_buffer[slotno], BLCKSZ, offset) != BLCKSZ)  {    ...  }}

Postgresql中用戶數(shù)據(jù)寫盤實(shí)現(xiàn)FlushBuffer

數(shù)據(jù)頁(yè)面同理,也是先找到頁(yè)面lsn,刷xlog,在寫數(shù)據(jù)。

static voidFlushBuffer(BufferDesc *buf, SMgrRelation reln){...buf_state = LockBufHdr(buf);/* * Run PageGetLSN while holding header lock, since we don"t have the * buffer locked exclusively in all cases. */recptr = BufferGetLSN(buf);   <<<<<<<<<<<<<<<<<<<<<<<<< 找到頁(yè)面的LSN/* To check if block content changes while flushing. - vadim 01/17/97 */buf_state &= ~BM_JUST_DIRTIED;UnlockBufHdr(buf, buf_state);/* * Force XLOG flush up to buffer"s LSN.  This implements the basic WAL * rule that log updates must hit disk before any of the data-file changes * they describe do. * * However, this rule does not apply to unlogged relations, which will be * lost after a crash anyway.  Most unlogged relation pages do not bear * LSNs since we never emit WAL records for them, and therefore flushing * up through the buffer LSN would be useless, but harmless.  However, * GiST indexes use LSNs internally to track page-splits, and therefore * unlogged GiST pages bear "fake" LSNs generated by * GetFakeLSNForUnloggedRel.  It is unlikely but possible that the fake * LSN counter could advance past the WAL insertion point; and if it did * happen, attempting to flush WAL through that location would fail, with * disastrous system-wide consequences.  To make sure that can"t happen, * skip the flush if the buffer isn"t permanent. */if (buf_state & BM_PERMANENT)XLogFlush(recptr);         <<<<<<<<<<<<<<<<<<<<<<<<< 先保證XLOG寫到這個(gè)位點(diǎn)!    ...smgrwrite(reln,  BufTagGetForkNum(&buf->tag),  buf->tag.blockNum,  bufToWrite,  false);  ...}

關(guān)鍵詞 PostgreSQL

熱門資訊

国产强奷伦奷片| H无码精品视频在线观看| 猛烈的打扑克的视频| 亚洲av无码a片在线观看蜜桃| 久久精品99国产精品蜜桃小说 | 久久精品国产大片免费观看| 韩国漫画漫免费观看免费| 善良的小峓子hd完整视频中文| 国产片xxxxa片国语对白| 人妻夜夜爽天天爽三区丁香花| 欧美乱妇日本无乱码特黄大片| 亚洲AV永久无码精品古装片| 亚洲女人被黑人巨大进入| 久久97精品久久久久久久不卡| 欧美精品乱码99久久蜜桃| 久久人人妻人人做人人爽| 男人桶女人30分钟| 丰满学生被猛烈进入播放| 97精品久久久久中文字幕| 夜来香视频免费观看| 男女囗交大图片26交| 无码国产精成人午夜视频一区二区| 99久久久国产精品免费蜜臀| 人妻含泪让粗大挺进| 快穿名器系统纯肉巨污文直播| 国产第一页屁屁影院| 扒开她粉嫩的小缝的a片| 欧美性欧美巨大黑白大战| 全国最大成人网站| 亚洲欧洲日产国码无码久久99| 老熟女草bx×| 中文字幕精品一区二区精品| julia无码人妻中文字幕在线| 中文在线а天堂中文在线新版| 精东传媒vs天美传媒电影| 无永久免费精品精品永久-夜色| 初尝禁果稚嫩宫交h| 狠狠色噜噜狠狠狠狠97首创麻豆| 免费无码又爽又刺激高潮| 亚洲国产精品无码久久| 亚洲精品久久久无码|