| PostgreSQL 9.6.0 锟街诧拷
| |||
|---|---|---|---|
| 锟斤拷一页 | 锟斤拷一锟斤拷 | 锟斤拷 26. 锟竭匡拷锟矫★拷锟斤拷锟截撅拷锟斤拷透锟斤拷锟� | 锟斤拷一页 |
锟斤拷锟斤拷锟斤拷锟教癸拷锟斤拷转锟狡憋拷锟斤拷锟斤拷只使锟斤拷一锟斤拷锟斤拷锟捷库拷锟斤拷锟斤拷锟斤拷锟斤拷同锟斤拷锟斤拷锟斤拷锟斤拷 锟斤拷使锟斤拷一锟斤拷锟缴讹拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷牡锟揭伙拷锟斤拷锟斤拷锟斤拷小锟斤拷锟斤拷锟斤拷锟斤拷锟捷匡拷锟斤拷锟斤拷锟绞э拷锟� 锟襟备凤拷锟斤拷锟斤拷锟斤拷锟斤拷怨锟斤拷夭锟斤拷锟斤拷锟斤拷锟斤拷菘猓拷秃锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷菘锟斤拷锟斤拷锟叫恢革拷锟斤拷锟斤拷锟剿★拷 锟斤拷锟斤拷一锟街匡拷锟劫的癸拷锟斤拷转锟狡ｏ拷锟斤拷锟揭诧拷锟斤拷锟斤拷锟斤拷锟捷讹拷失锟斤拷
锟斤拷锟斤拷硬锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷娲拷璞革拷泻艹锟斤拷锟斤拷锟揭诧拷锟斤拷锟绞癸拷锟揭伙拷锟斤拷锟斤拷锟斤拷募锟较低筹拷锟� 锟斤拷锟斤拷要注锟斤拷锟斤拷歉锟斤拷募锟较低秤︼拷锟斤拷锟斤拷锟饺拷锟�POSIX锟斤拷为 锟斤拷锟斤拷锟斤拷 18.2.2 锟斤拷锟斤拷锟斤拷 锟斤拷锟街凤拷锟斤拷锟斤拷一锟斤拷锟截达拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟绞э拷锟斤拷鸹担锟� 锟斤拷要锟酵后备凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟睫凤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷要锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷时锟斤拷 锟襟备凤拷锟斤拷锟斤拷锟斤拷远锟斤拷锟杰凤拷锟绞癸拷锟斤拷锟芥储锟斤拷
锟斤拷锟斤拷硬锟斤拷锟斤拷锟杰碉拷一锟斤拷锟睫改版本锟斤拷锟侥硷拷系统锟斤拷锟狡ｏ拷 锟斤拷锟斤拷锟叫讹拷一锟斤拷锟侥硷拷系统锟斤拷锟斤拷锟叫改憋拷岜伙拷锟斤拷锟轿伙拷锟斤拷锟揭惶拷锟斤拷锟斤拷锟较碉拷一锟斤拷锟侥硷拷系统锟斤拷 唯一锟斤拷锟斤拷锟斤拷锟角该撅拷锟斤拷锟斤拷瘫锟斤拷锟斤拷鼙锟街わ拷蟊阜锟斤拷锟斤拷锟斤拷锟揭伙拷莞锟斤拷募锟较低筹拷锟揭伙拷碌目锟斤拷锟� — 锟截憋拷锟角对后备凤拷锟斤拷锟斤拷锟斤拷写锟斤拷锟斤拷氚达拷锟斤拷锟斤拷鼗锟斤拷锟斤拷锟酵拷锟剿筹拷锟斤拷锟叫★拷 DRBD锟斤拷锟斤拷锟斤拷 Linux 锟斤拷一锟斤拷锟斤拷锟叫碉拷锟侥硷拷系统锟斤拷锟狡凤拷锟斤拷锟斤拷
锟铰憋拷锟斤拷锟饺憋拷锟斤拷锟斤拷锟斤拷锟杰癸拷通锟斤拷锟斤拷取一锟斤拷预写式锟斤拷志锟斤拷WAL锟斤拷 锟斤拷录锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟斤拷前状态锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟绞э拷锟� 锟襟备凤拷锟斤拷锟斤拷拥锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟侥硷拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷ｏ拷 锟斤拷锟斤拷锟杰癸拷锟斤拷锟劫地憋拷锟斤拷锟斤拷碌锟斤拷锟斤拷锟斤拷菘锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵拷锟斤拷幕锟斤拷觳斤拷模锟� 锟斤拷锟斤拷只锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷匡拷锟斤拷锟斤拷锟斤拷锟�
锟斤拷锟斤拷使锟矫伙拷锟斤拷锟侥硷拷锟斤拷锟斤拷志锟斤拷锟酵ｏ拷锟斤拷 26.2 锟斤拷锟斤拷锟斤拷 锟斤拷锟斤拷锟狡ｏ拷锟斤拷锟斤拷 26.2.5 锟斤拷锟斤拷 锟斤拷锟斤拷锟竭碉拷锟斤拷锟斤拷锟绞碉拷锟揭伙拷锟斤拷蟊阜锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷缺锟斤拷锟斤拷锟较拷杉锟� 锟斤拷 26.5 锟斤拷锟斤拷
一锟斤拷锟斤拷-锟斤拷锟斤拷锟斤拷锟斤拷锟矫伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷薷牟锟窖拷锟斤拷偷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟� 锟斤拷锟斤拷锟斤拷锟斤拷锟届步锟截斤拷锟斤拷锟斤拷锟睫改凤拷锟酵革拷锟襟备凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷时锟斤拷 锟襟备凤拷锟斤拷锟斤拷锟斤拷锟皆回达拷只锟斤拷锟斤拷询锟斤拷锟襟备凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷仓匡拷锟窖拷锟揭伙拷锟斤拷锟斤拷锟斤拷选锟斤拷
Slony-I锟斤拷锟斤拷锟街革拷锟斤拷锟斤拷锟酵碉拷一锟斤拷锟斤拷锟接★拷锟斤拷使锟矫憋拷锟斤拷锟饺ｏ拷 锟斤拷锟斤拷支锟街讹拷锟斤拷蟊阜锟斤拷锟斤拷锟斤拷锟斤拷锟轿拷锟斤拷锟斤拷觳斤拷锟斤拷潞蟊阜锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟� 锟节癸拷锟斤拷转锟斤拷时锟斤拷锟杰伙拷锟斤拷锟斤拷锟捷讹拷失锟斤拷
通锟斤拷锟斤拷锟斤拷锟斤拷锟侥革拷锟斤拷锟叫硷拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫恳伙拷锟� SQL 锟斤拷询锟斤拷锟斤拷锟斤拷锟斤拷锟酵革拷一锟斤拷锟斤拷锟斤拷锟叫凤拷锟斤拷锟斤拷锟斤拷 每一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟截诧拷锟斤拷锟斤拷锟斤拷写锟斤拷询锟斤拷锟诫被锟斤拷锟酵革拷锟斤拷锟叫凤拷锟斤拷锟斤拷锟斤拷 锟斤拷锟斤拷每一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟杰斤拷锟秸碉拷锟轿猴拷锟睫改★拷锟斤拷只锟斤拷锟斤拷询锟斤拷锟皆憋拷只锟斤拷锟酵革拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟节凤拷锟斤拷锟斤拷之锟斤拷植锟斤拷锟�
锟斤拷锟斤拷锟窖拷锟斤拷虻サ锟斤拷锟轿达拷锟斤拷薷牡毓悴ワ拷锟�random()锟斤拷
CURRENT_TIMESTAMP之锟斤拷暮锟斤拷锟斤拷约锟斤拷锟斤拷锟斤拷诓锟酵拷锟斤拷锟斤拷锟斤拷峡锟斤拷锟斤拷胁锟酵拷锟街碉拷锟�
锟斤拷锟斤拷锟斤拷为每一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷夭锟斤拷锟斤拷锟斤拷锟斤拷锟� SQL 锟斤拷询锟斤拷锟姐播锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟睫改碉拷锟叫ｏ拷锟斤拷
锟斤拷锟斤拷獠伙拷山锟斤拷埽锟斤拷屑锟斤拷锟斤拷应锟矫憋拷锟斤拷锟揭伙拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟窖拷锟斤拷锟斤拷锟街碉拷锟斤拷锟饺伙拷锟斤拷锟叫┲碉拷锟斤拷锟叫达拷锟窖拷小锟�
锟斤拷一锟斤拷选锟斤拷锟角斤拷锟斤拷锟斤拷锟斤拷锟窖★拷锟斤拷一锟街达拷统锟斤拷-锟斤拷锟斤拷锟斤拷一锟斤拷使锟矫ｏ拷
锟斤拷锟斤拷锟斤拷锟睫改诧拷询只锟斤拷锟斤拷锟酵革拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷通锟斤拷锟斤拷-锟斤拷锟斤拷锟狡达拷锟斤拷锟斤拷锟襟备凤拷锟斤拷锟斤拷锟斤拷
锟斤拷锟斤拷锟斤拷通锟斤拷锟斤拷锟斤拷锟叫硷拷锟斤拷锟斤拷锟斤拷锟揭拷锟斤拷锟角ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷要么锟斤拷锟斤拷锟叫凤拷锟斤拷锟斤拷锟较讹拷锟结交锟斤拷
要么锟斤拷锟斤拷锟叫凤拷锟斤拷锟斤拷锟较讹拷锟斤拷止锟斤拷也锟斤拷锟斤拷锟斤拷使锟斤拷锟斤拷锟阶讹拷锟结交锟斤拷PREPARE TRANSACTION
锟斤拷COMMIT PREPARED锟斤拷锟斤拷Pgpool-II
锟斤拷Continuent Tungsten锟斤拷锟斤拷锟街革拷锟斤拷锟斤拷锟酵碉拷锟斤拷锟接★拷
锟斤拷锟节诧拷锟结被锟斤拷锟斤拷锟斤拷锟接的凤拷锟斤拷锟斤拷锟斤拷锟斤拷始潜锟斤拷锟皆讹拷谭锟斤拷锟斤拷锟斤拷锟斤拷锟� 锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟揭伙拷锟斤拷锟秸斤拷锟酵拷锟绞癸拷锟斤拷觳斤拷亩锟斤拷锟斤拷鼗锟斤拷锟斤拷疲锟� 每一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭讹拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷通锟斤拷锟斤拷确锟斤拷锟斤拷突锟斤拷锟斤拷锟斤拷 锟斤拷些锟斤拷突锟斤拷锟斤拷锟斤拷锟矫伙拷锟斤拷锟酵伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟紹ucardo 锟斤拷锟斤拷锟街革拷锟斤拷锟斤拷锟酵碉拷一锟斤拷锟斤拷锟接★拷
锟斤拷同锟斤拷锟斤拷锟斤拷锟截伙拷锟斤拷锟斤拷锟叫ｏ拷每一锟斤拷锟斤拷锟斤拷锟斤拷锟杰癸拷锟斤拷锟斤拷写锟斤拷锟襟，诧拷锟斤拷锟斤拷每一锟斤拷锟斤拷锟斤拷锟结交之前锟斤拷
锟斤拷锟睫改碉拷锟斤拷锟捷会被锟斤拷原始锟斤拷锟斤拷锟斤拷锟斤拷锟酵革拷每一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
锟斤拷锟截碉拷写锟筋动锟斤拷锟杰碉拷锟铰癸拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷潞懿锟斤拷锟斤拷锟杰★拷锟斤拷实锟较ｏ拷
写锟斤拷锟斤拷通锟斤拷锟斤拷一锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷要锟姐。锟斤拷锟斤拷锟斤拷锟斤拷员锟斤拷锟斤拷透锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
某些实锟斤拷使锟矫癸拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷通锟脚革拷锟缴★拷同锟斤拷锟斤拷锟斤拷锟截伙拷锟斤拷锟斤拷锟斤拷要锟斤拷锟节达拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫的ｏ拷
锟斤拷锟斤拷锟斤拷锟侥达拷锟脚碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷芙锟斤拷锟叫达拷锟斤拷锟� —
没锟叫憋拷要锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵后备凤拷锟斤拷锟斤拷之锟戒划锟街革拷锟截ｏ拷
锟斤拷锟斤拷锟斤拷为锟斤拷锟斤拷锟睫改憋拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵碉拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
锟斤拷锟斤拷锟叫凤拷确锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷random()锟斤拷锟斤拷锟斤拷锟解。
PostgreSQL锟斤拷锟结供锟斤拷锟街革拷锟斤拷锟斤拷锟酵ｏ拷 锟斤拷锟斤拷锟斤拷应锟矫达拷锟斤拷锟斤拷屑锟斤拷锟叫匡拷锟斤拷使锟斤拷PostgreSQL锟斤拷锟斤拷锟阶讹拷锟结交 锟斤拷PREPARE TRANSACTION锟斤拷COMMIT PREPARED锟斤拷 锟斤拷实锟斤拷锟斤拷锟街革拷锟狡★拷
锟斤拷为PostgreSQL锟角匡拷源锟侥诧拷锟揭猴拷锟斤拷锟阶憋拷锟斤拷展锟斤拷 一些锟斤拷司锟窖撅拷使锟斤拷PostgreSQL锟斤拷锟揭达拷锟斤拷锟剿达拷锟斤拷唯一锟斤拷锟斤拷转锟狡★拷 锟斤拷锟狡和革拷锟截撅拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷业锟皆的憋拷源锟斤拷锟斤拷锟斤拷
锟斤拷 26-1锟杰斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
锟斤拷 26-1. 锟竭匡拷锟矫★拷锟斤拷锟截撅拷锟斤拷透锟斤拷锟斤拷锟斤拷跃锟斤拷锟�
| 锟斤拷锟斤拷 | 锟斤拷锟斤拷锟斤拷锟教癸拷锟斤拷转锟斤拷 | 锟侥硷拷系统锟斤拷锟斤拷 | 锟斤拷锟斤拷锟斤拷志锟斤拷锟斤拷 | 锟斤拷锟节达拷锟斤拷锟斤拷锟斤拷锟斤拷-锟斤拷锟斤拷锟斤拷 | 锟斤拷锟斤拷锟斤拷锟侥革拷锟斤拷锟叫硷拷锟� | 锟届步锟斤拷锟斤拷锟截伙拷锟斤拷锟斤拷 | 同锟斤拷锟斤拷锟斤拷锟截伙拷锟斤拷锟斤拷 |
|---|---|---|---|---|---|---|---|
| 锟斤拷通锟矫碉拷实锟斤拷 | NAS | DRBD | Streaming Repl. | Slony | pgpool-II | Bucardo | |
| 通锟脚凤拷锟斤拷 | shared disk | disk blocks | WAL | table rows | SQL | table rows | table rows and row locks |
| 锟斤拷要锟斤拷锟斤拷锟斤拷硬锟斤拷 | • | • | • | • | • | • | |
| 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷鼗锟斤拷锟斤拷锟斤拷锟� | • | • | • | ||||
| 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 | • | • | • | ||||
| 锟斤拷锟饺达拷锟斤拷锟斤拷锟斤拷锟斤拷锟� | • | with sync off | • | • | |||
| 锟斤拷锟截伙拷失效锟斤拷锟斤拷锟斤拷锟斤拷失锟斤拷锟斤拷 | • | • | with sync on | • | • | ||
| 锟襟备伙拷锟斤拷锟斤拷只锟斤拷锟斤拷询 | with hot | • | • | • | • | ||
| 每锟斤拷锟斤拷锟斤拷锟斤拷 | • | • | • | ||||
| 锟斤拷锟斤拷要锟斤拷突锟斤拷锟� | • | • | • | • | • |
锟斤拷一些锟斤拷锟斤拷锟斤拷锟绞猴拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
锟斤拷锟捷凤拷锟斤拷锟斤拷锟斤拷锟街匡拷锟斤拷锟斤拷锟捷硷拷锟斤拷每锟斤拷锟斤拷锟斤拷只锟杰憋拷一锟斤拷锟斤拷锟斤拷锟斤拷锟睫改★拷锟斤拷锟界， 锟斤拷锟捷匡拷锟皆革拷锟捷办公锟揭伙拷锟街ｏ拷锟斤拷锟阶敦和帮拷锟借，每一锟斤拷锟届公锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 锟斤拷锟斤拷锟窖拷斜锟揭拷锟斤拷锟阶敦和帮拷锟斤拷锟斤拷锟斤拷荩锟揭伙拷锟接︼拷每锟斤拷圆锟窖拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟� 锟斤拷锟竭匡拷锟斤拷使锟斤拷锟斤拷/锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷每一台锟斤拷锟斤拷锟斤拷锟较憋拷锟斤拷锟斤拷锟斤拷锟届公锟斤拷锟斤拷锟捷碉拷一锟斤拷只锟斤拷锟斤拷锟斤拷锟斤拷
锟斤拷锟斤拷锟侥很多方锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷询锟斤拷 锟斤拷锟斤拷没锟斤拷一锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷一锟斤拷询使锟矫讹拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟缴★拷 锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟揭伙拷锟窖拷喜锟斤拷锟斤拷锟斤拷锟斤拷锟� 锟斤拷通锟斤拷通锟斤拷锟斤拷锟斤拷锟斤拷锟节凤拷锟斤拷锟斤拷之锟戒划锟街诧拷锟斤拷锟斤拷每一锟斤拷锟斤拷锟斤拷锟斤拷执锟叫该诧拷询锟斤拷锟斤拷锟斤拷锟斤拷锟侥诧拷锟街ｏ拷 然锟襟将斤拷锟斤拷锟斤拷馗锟揭伙拷锟斤拷锟斤拷姆锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷辖锟斤拷锟斤拷锟斤拷锟截革拷锟矫伙拷锟斤拷 Pgpool-II锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷同锟斤拷锟斤拷也锟斤拷锟斤拷使锟斤拷 PL/Proxy锟斤拷锟竭硷拷锟斤拷实锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷