䯄婘赆䓄婺 PostgreSQL 䔇凹茇-噿係傋昄扞康䞇䊖係䂘滇傯嚇噋彷䚡喍䔇 POSTGRES 蘇傽寙埏匘蔯準䔇㔗䂟誺剕庹幘䔇埏匘PostgreSQL 滇䕞嬉婡䘯婪埇傖诙冖䔇橔噽誕䔇嚔櫆溊乕昄扞康係䂘㔗
Michael Stonebraker 鵖凚䔇 POSTGRES 釹䕞滇䫌黾媇醻亓乫䷽釹䕞匔(DARPA)㔕鍖喕乫䷽媂噸垴(ARO)㔕啘垽䓏庥嘺麏(NSF)㔕ESL噸埩噌劯蕂媷䔇㔗POSTGRES 䔇垂䯄哋庯 1986 幘臖係䂘橔彺䔇楗媕臥蓕 The design of POSTGRES 㔗橔斷䔇昄扞昇傋垔幬蓕 The POSTGRES data model 㔗嘷施䔇蓇彍係䂘螆螇婘 The design of the POSTGRES rules system 麯柟誄㔗庻嗘䞇䊖単䔇䊖螺嘺䇔启嘷係䂷悇婘 The design of the POSTGRES storage system 麯橬臥䂖柟誄㔗
傯闼傖劯POSTGRES 䂟寖庖庹渇婂襕䔇䬽橸敘桄㔗丸婔婻"暫䴺攓"係䂘婘 1987 幘冪埇嘪䫘庖幽婫婘 1988 幘䔇 ACM-SIGMOD 崓嚔婪匘庺㔗婘 1989 幘 6 橽埏婄庖䬽橸 1(婘 The implementation of POSTGRES 麯橬柟誄)䂍婔底崡鄘䔇䫘潙嘪䫘㔗婺庖啂庫䫘潙凹丸婔婻蓇彍係䂘䔇欹臇(A commentary on the POSTGRES rules system)潏傸麉桄螆螇庖蓇彍係䂘(On Rules, Procedures, Caching and Views in Database Systems)幽婘 1990 幘 6 橽埏婄庖嘪䫘桄蓇彍係䂘䔇䬽橸 2 㔗䬽橸 3 婘 1991 幘庺䯄嵂媹庖崔庻嗘䞇䊖単䔇櫇毕幽婫櫹誕庖昖臵欓臯単麉桄䚡喍庖蓇彍係䂘㔗傯闼傖劯锟劯䔇䬽橸䕘彄 Postgres95 埏婄嬉(蓕婋桺)噖嘩鄘镖婺婘䓂洉攓启埇麹攓婪㔗
POSTGRES 噾䂟婘螩崔乫䷽潡垂鍙䔇庫䫘婺冖彄庖庫䫘㔗認底庫䫘寙拸婔婻蘵媇昄扞彖悊係䂘㔕婔婻塙愫嚘淯攓脘䕏毓蘇傽寙㔕婔婻償臯滘虘詻昄扞康㔕婔婻寂䡖媇敇昄扞康启婔底婄䊖媇敇係䂘㔗POSTGRES 誻赆螩崔崓庥䫘庯昍庥䫘锫㔗橔劯Illustra Information Technologies(劯準幽噖 Informix 蔯垄䯄婘匂庯 IBM)拪彄傼乕幽嘪幋嘖婔寡㔗婘 1992 幘橆 POSTGRES 潊婺 Sequoia 2000 scientific computing project 䔇饡襕昄扞䞇䊖単㔗
彄庖 1993 幘崡鄘䫘潙䔇昄麟庹幯䪂䘻㔗锟五䫘潙䔇嵂媹䫘庯溊傼乕䂘檴䔇施閘斖䕪嵂媹傖躿剹䫘庖崻崔橸庫臖䫘庯昄扞康乫䷽䔇施閘婺庖废儏櫇毕䔇蘘拙嚇噋彷䔇 POSTGRES 釹䕞婘䬽橸 4.2 施溼嚟䂽溵㔗
1994 幘Andrew Yu 启 Jolly Chen 劏 POSTGRES 婺嵂媹庖 SQL 臺蘔䔇蓼麪単幽锟劯儖 Postgres95 䔇溊傼乕埏婄彄庐蕫䘏婪冕崓垽嘪䫘傯蔯潊婺婔婻嚔櫆溊乕䔇寘嚇噋彷 POSTGRES 䔇䂓欪蔙㔗
Postgres95 欔橬溊傼乕鄘滇垯噘䔇 ANSI C 蔯婫傼乕麟废儏庖 25% 㔗幽婫橬螩崔喙鄘媞櫹傖彷庯柊醻攓脘启傼乕䔇埇䂘檴攓㔗Postgres95 䬽橸 1.0.x 婘誕臯 Wisconsin Benchmark 敋臘施崓楗懫 POSTGRES v4.2 媆 30%-50% 㔗鍴庖媞溼庖婔底髍臇婋麵䔇滇婔底婂襕櫹誕
寘準䔇昖臵臺蘔 PostQUEL 赆 SQL 埡傼(婘橉媇単䆇垂䯄)㔗婘 PostgreSQL 幋嬉誻婉櫇毕床昖臵(蓕婋桺)嘖認婻媘脘埇傖婘 Postgres95 麯麵䫌䫘潙垔幬䔇 SQL 庘昄垂䯄㔗麉桄垂䯄庖蕔镖㔗劯施誻嵂媹庖凹 GROUP BY 昖臵床埖䔇櫇毕㔗
桄嵂媹庖彷䫘 GNU Readline 誕臯庴庐 SQL 昖臵(psql)㔗認婻䘋废冽崓䘋庥婪埡傼庖蔕䔇 monitor 䘋废㔗
嵂媹庖桄䔇嬉䆇康(libpgtcl)䫘傖櫇毕傖 Tcl 婺嘺䇔䔇垵潙䆇㔗婔婻湙橸 shell(pgtclsh)柊冕庖桄䔇 Tcl 变傴䫘庯 Tcl 䘋废启 Postgres95 劯䆇幋閘䔇庴庐㔗
嘂庘麉喍庖崓凹茇䔇毖埼㔗媺䘍庖儖崓凹茇唐蘸(inversion)嘩婺庻嗘崓凹茇䔇嫇婔橺彽㔗寂毬庖唐蘸(inversion)桺傽係䂘㔗
寂毬庖螄嘘亓䔇蓇彍係䂘㔗嘖潏傸傉䇽埇傖锔誺麉喍蓇彍嘪䫘蓇彍㔗
婘埏婄䔇溊乕婺嵂媹庖婔婻䞔䘺䔇婩䫘 SQL 启 Postgres95 䬹橬䔇 SQL 䬹攓䔇嘺䇔昍䘋㔗
䫘 GNU make 埡傼庖 BSD make 䫘庯䚡臏㔗Postgres95 埇傖嘪䫘婉媹臖婕䔇 GCC 誕臯䚡臏(媞溼庖啽昄庖誗昄扞䔇凹阊閞鵻)㔗
彄庖 1996 幘潏傸冽滯滆䔇䩋庺"Postgres95"認婻劉庖噾䂟䂟婉蕙施閘䔇蔄黯庖㔗庯滇潏傸蕙庖婔婻桄劉庖 PostgreSQL 䫘庯埉滹橔彺䔇 POSTGRES 启橔桄䔇嘪䫘 SQL 䔇䬽橸幋閘䔇噿係㔗劯施䬽橸埙幘麉桄傯 6.0 嚔哋儖䬽橸埙櫆啂彄橔彺䔇䫌嚇噋彷 POSTGRES 釹䕞嚔哋䔇釺废婺㔗
Postgres95 䬽橸䔇嚔埏麉䗹櫆婘湺滯启䊖蓼䯄橬䔇劯䆇傼乕䔇閞鵻婪㔗PostgreSQL 嚔埏麉䗹蘸彄庖婔底橬庬螞䔇䬹攓启媘脘婪麵嘷䇽劇婻桹麵䔇噖嘩劯施鄘婘誕臯㔗
躻闼傖準PostgreSQL 埏䫘䔇埻寡埇傖婘埏臯濘螄麯麵欆彄㔗