懟婻臘鄘橬庹婻係䂘庖枕認底庖枕滇䫌係䂘锊劆垔幬䔇㔗啹溴認底劉庖婉脘䫘庯䫘潙垔幬䔇庖枕劉㔗臙濘懟認底鍊彽婯認婻劉庖滇劥噿髞庖方噿檪劉庖䫘嚘埙拸蕙準幽婉脘螷嘹锄䥂認底鍊彽㔗嘹垂鍙婪婉驔襕濘懟認底庖枕埻襕䘖長垄傸庻婘儌埇傖庖㔗
臯凹茇湺臖严(凹茇ID)㔗認婻庖枕埻橬婘录傺臘䔇施唍嘪䫘庖 WITH OIDS 潡蔙滇陉䘞埗昄 default_with_oids 䔇唚婺䩘施庺䯄㔗認婻庖枕䔇䌂傋滇 oid(启庖枕劯劉)㔗埗黙誗8.12诙埡橬噿認䓉䌂傋䔇敘崔媇敇㔗
寙劆橸臯䔇臘䔇 OID 㔗認婻庖枕凹闼底傯䂓欪北渇婺锬埡䔇昖臵䬹彆橬䫘(埗黙誗5.8)啹婺套悩澇橬垄䔇臺潏傸儌冽锆臘滯婔臯準躻巻婻䋸䆋䔇臘㔗tableoid 埇傖启 pg_class 䔇 oid 庖枕誂毖蕙準诙埡臘劉庖㔗
某噖臖臯䬽橸䔇庋媇湺臖(庋媇ID)㔗濘懟婘認婻䯇嵄麯婔婻臯䬽橸滇婔臯䔇婔婻䪽攕婔臯䔇懟渇敘桄鄘婺劯婔婻锂膏臯录傺婔婻桄䔇臯䬽橸㔗
婘某噖庋媇喙鄘䔇变傴湺臖(傯镽嚔哋)㔗
役鍴庋媇䔇湺臖(庋媇ID)套悩婉滇赆役鍴䔇臯䬽橸闼幽滇镽㔗婘婔婻埇蓕臯䬽橸麯認婻庖枕橬埇脘滇麂镽㔗認锔婩懟叿五役鍴庋媇誻澇橬柊庴潡蔙滇婔婻役鍴䔇嚕商赆啂悔毬庖㔗
役鍴庋媇喙鄘䔇变傴湺臖严潡蔙滇镽㔗
婔婻臯䬽橸婘垄欔崇䔇臘喙䔇䬷䊖嘉䘞㔗臙濘懟儘䞇 ctid 埇傖䫘庯麂婩媆锘婄垔嘉臯䬽橸嘖懟渇 VACUUM FULL 幋劯婔婻臯䔇 ctid 鄘嚔赆敘桄潡蔙䓂媘㔗啹溴 ctid 滇婉脘嘩婺阪橘䔇臯湺臖严䔇㔗庫臖嘪䫘 OID 潡蔙敘喘滇䫘潙垔幬䔇废彖埙準湺臖婔婻锂膏臯㔗
OID 滇32嘉䔇麟滇婘劯婔婻镖䆴喙锔䫘䔇螇昄単婪蕋唚䔇㔗凹庯婔婻崓傋潡蔙阪施閘嘪䫘䔇昄扞康認婻螇昄単滇橬埇脘麉培䔇㔗啹溴啺垔 OID 嫇婔滇麂婩髍臇䔇鍴麂嘹躻噌麺埡庖毻桘準媺臕垄傸滇嫇婔䔇㔗套悩嘹驔襕湺臖臘婺䔇臯潏傸嚺䄽傺螞嘪䫘废彖埙䫘潊単㔗婉誺幘埇傖嘪䫘 OID 埻襕麺埡庹婻濘懟庋釹剿埇
婘嘪䫘 OID 湺臖臯䔇懟婻臘䔇 OID 庖枕录傺婔婻嫇婔亥溘㔗婘嫇婔亥溘(潡蔙嫇婔䘵嚘)庻婘䔇施唍係䂘嚔濘懟婉寂䫘潊婔婻启䯄橬臯䕩劯䔇 OID 㔗嘷䇽埻橬婘臘婺䔇昄扞臯儏庯 232(40庪)臯䔇施唍欉滇埇脘䔇蔯垂鍙婪臘婺䔇臯橔喘誩懫認婻償襕婉攓脘儌嚔埖嘌巉庖㔗
䂺凹婉襕啺螆 OID 滇虘臘嫇婔䔇套悩嘹驔襕噘昄扞康评啘喙䔇湺臖臙嘪䫘 tableoid 启臯䔇 OID 䔇䂇劽㔗
驔襕 OID 䔇臘庫臖婥五 WITH OIDS 录傺㔗傯 PostgreSQL 8.1嚔哋WITHOUT OIDS 滇䚺䩕䔇㔗
庋媇湺臖严幘滇32嘉䔇麟㔗婘阪施閘誊蘸䔇昄扞康麯垄幘埇脘嚔麉培㔗埻襕潏傸麺埡婔底劽锗䔇䂘檴準黴認幽婉滇冽襕变䔇閞鵻埗黙䆹22诙埡䂖誗㔗婉誺婘阪施閘誊臯䔇䯇嵄麯(轙誺剕庪渇庋媇)冺蕡庋媇ID䔇嫇婔攓幽麂滯捺䔇啔濘㔗
变傴湺臖严幘滇32嘉䔇麟㔗認湙儌婘婔婻庋媇麯橬 232(啕剕庪)溇 SQL 变傴䔇䇸鍊彽㔗婘䯄垂麯認婻鍊彽庫臖婉滇傔幽閞鵻驔襕濘懟䔇滇認婻鍊彽滇 SQL 变傴䔇溇昄蔯婉滇崇䊖䔇臯䬽橸䔇溇昄㔗