WAL 滇躻媘欷嚔䔇㔗鍴庖襕挗婔底伕䕻䷺閘庻櫆 WAL 斖媖傖埪婔底媙襕䔇脄誗傖崡(埗黙誗27.3)凹䞇䊖叻澇橬傔幽噽垄襕挗㔗
WAL 斖媖庻櫆婘昄扞䕞嘘䔇 pg_xlog 床䕞嘘麯垄滇嘩婺婔婻桺傽枕䔇镖劽庻嗘䔇锔婩懟枕 16MB 㔗懟婻枕埽彖嬾潊崔婻釕锔婩懟釕 8KB 㔗斖媖螄嘘崘婘 access/xlog.h 麯柟誄斖媖喙垹埡喿庯垄螄嘘䔇庋傽䌂傋㔗枕桺傽䔇劉庖滇锐嵂躻䇽昄傯 000000010000000000000000 嚔哋㔗䕞嬉認底昄庖婉脘冻䯇嘪䫘婉誺襕檪欔橬埇䫘䔇昄庖鄘䫘噬幘驔襕麂婩阪䔇施閘㔗
斖媖嘉庯启婂昄扞康桺傽婉劯䔇埥崡婔婻伕䕻婪嚔懫膄喘㔗嘹埇傖锔誺檪 pg_xlog 䕞嘘䓂媘彄埥崡婔婻嘉䘞(溴施媙釂噿閺橉媇単)䇽劯婘寘準䔇嘉䘞录傺婔婻毺劏桄嘉䘞䔇严埙鷆毖㔗
WAL 䔇䕞䔇滇䇞媺婘昄扞康螄嘘赆媞櫹幋嬉噽喍斖媖嘖滇認婻䕞䔇橬埇脘赆闼底劏喙湩脯檖潊媘喍噖䔇伕䕻鷌媘単乘废認施唍垄傸垂鍙婪埻滇䚷喾庖昄扞蔯幽橻檪昄扞庻嗘彄伕䕻婪㔗認䓉愙喕婋䔇䫕溊崌昽傉䇽埇脘凚躘婉埇敵崉䔇昄扞嘷溄䞇䊖叻庫臖䇞媺媺庻 PostgreSQL 斖媖桺傽䔇伕䕻婉嚔啔認䓉荔啺挺檖㔗
婘垯潊婔婻演昖䗹幽婫彙桄庖斖媖桺傽幋劯演昖䗹䔇嘉䘞儌媺庻婘庖 pg_control 桺傽麯㔗啹溴婘驔襕啔敵崉䔇施唍劯䆇饡噽臂埡 pg_control 启演昖䗹螄嘘䇽劯锔誺傯演昖䗹螄嘘麯湺臖䔇斖媖嘉䘞嚔哋劏嬉欆柟欓臯 REDO 淉嘩㔗啹婺昄扞釕䔇欔橬喙垹鄘媺庻婘演昖䗹幋劯䔇丸婔婻釕麵媞櫹䔇斖媖麯欔傖躻演昖䗹傖準䔇欔橬埻寡鄘儖赆敵崉彄婔婻婔躘䔇䪽攕㔗
嘖滇婺庖崇䊖 pg_control 埇脘䔇托废潏傸垂鍙婪庫臖垂䯄凹䯄庻斖媖枕䔇埉劏臂埡釺废(傯橔桄彄橔蔕)認湙欉脘欆彄橔劯䔇演昖䗹㔗認底誻澇橬垂䯄㔗pg_control 冽償(懫婔婻伕䕻釕償)啹溴垄庺䯄埻喍庖婔鄘彖䔇閞鵻䔇楗䯺庹幯婺镽彄䕞嬉婺溵潏傸誻澇橬䩋彄婉脘臂埡 pg_control 躻躆䔇髍臇㔗啹溴儘䞇認婘䊖螺婪滇婔婻衇嚌䯇誗嘖滇垂處婺 pg_control 嚚幯幽婉嚔庺䯄閞鵻㔗