´ÓÄÇÒÔºó£¬ Postgres ¾ÀúÁ˼¸´ÎÖ÷ÒªµÄ°æ±¾¸üУ® µÚÒ»¸öÑÝʾÐÔµÄϵͳÔÚ1987Äê±ã¿ÉÓÃÁË£¬ ²¢ÇÒÔÚ1988ÄêµÄACM-SIGMOD ´ó»áÉÏÕ¹³ö£® ÎÒÃÇÔÚ1989Äê·¢²¼°æ±¾ 1£¨ÔÚ PostgresµÄʵÏÖÀïÓÐÃèÊö£©¸øһЩÍⲿµÄÓû§Ê¹Óã®×÷Ϊ¶ÔµÚÒ»¸ö¹æÔòϵͳµÄÅúÆÀµÄÏìÓ¦£¬£¨¶Ô Postgres ¹æÔòϵͳµÄÌÖÂÛ£©£¬ÎÒÃÇÖØÐÂÉè¼ÆÁ˹æÔòϵͳ£¨On Rules, Procedures, Caching and Views in Database Systems£©²¢ÔÚ1990Äê6Ô·¢²¼ÁËʹÓÃйæÔòϵͳµÄ°æ±¾ 2£® °æ±¾ 3 ÔÚ1991Äê³öÏÖ£¬ Ôö¼ÓÁ˶à´æ´¢¹ÜÀíÆ÷µÄÖ§³Ö£¬ ²¢ÇҸĽøÁ˲éѯִÐÐÆ÷£¬ ÖØбàдÁËÖØд¹æÔòϵͳ£® ´ÓÄÇÒÔºó£¬ Ö±µ½ Postgres95·¢²¼·¢²¼Ç°£¨¼ûÏÂÎÄ£©£¬¹¤×÷¶¼¼¯ÖÐÔÚÒÆÖ²ÐԺͿɿ¿ÐÔÉÏ¡£
Postgres ÒѾ±»ÓÃÓÚÐí¶àÑо¿»òʵ¼ÊµÄÓ¦ÓÃÖÐÈ¥ÁË£® ÕâЩӦÓðüÀ¨£º Ò»¸ö²ÆÎñÊý¾Ý·ÖÎöϵͳ£¬ Ò»¸öÅçÆøÒýÇæÐÔÄܼà¿ØÈí¼þ°ü£¬ Ò»¸öСÐÐÐǸú×ÙÊý¾Ý¿â£¬ Ò»¸öÒ½ÁÆÐÅÏ¢Êý¾Ý¿âºÍһЩµØÀíÐÅϢϵͳ£® Postgres »¹±»Ðí¶à´óѧÓÃÓÚ½ÌѧÓÃ;£® ×îºó£¬Illustra Information Technologies £¨ºóÀ´²¢Èë Informix £©Äõ½´úÂ벢ʹ֮ÉÌÒµ»¯£® ÔÚ1992ÄêÄ©Postgres ³ÉΪ Sequoia 2000 ¿Æѧ¼ÆËãÏîÄ¿µÄÊ×ÒªÊý¾Ý¹ÜÀíÆ÷£®
µ½ÁË1993Ä꣬ ÍⲿÓû§µÄÊýÁ¿¼¸ºõ··¬£® Ëæ×ÅÓû§µÄÔö¼Ó£® ÓÃÓÚÔ´´úÂëά»¤µÄʱ¼äÈÕÒæÔö¼Ó Õ¼ÓÃÁËÌ«¶à±¾Ó¦¸ÃÓÃÓÚÊý¾Ý¿âÑо¿µÄʱ¼ä£¬ ÓÚÊǸÃÏîÄ¿ÔÚ°æ±¾4.2ʱÕýʽÖÕÖ¹£®
ÔÚ¼à¿Ø³ÌÐò·½Ã棬 Ôö¼ÓÁËÐÂÀûÓà GNUreadline
½øÐн»»¥²éѯµÄ¼à¿Ø³ÌÐò£¨psql£©¡£
Ôö¼ÓÁËеÄÇ°¶Ë¿â£¬ libpgtcl£¬ ÓÃÒÔÖ§³ÖÒÔ TclΪ»ù´¡µÄ¿Í»§¶Ë£®Ò»¸öÑù±¾shell£¬pgtclsh£¬ÌṩÁËеÄ
TclÃüÁîÓÃÓÚ tcl ³ÌÐòºÍ Postgres95
ºó¶ËÖ®¼äµÄ½»»¥£®
³¹µ×ÖØдÁË´ó¶ÔÏóµÄ½Ó¿Ú£® ±£ÁôÁ˽«´ó¶ÔÏóתÖã¨Inversion £©×÷Ϊ´æ´¢´ó¶ÔÏóµÄΨһ»úÖÆ£®£¨È¥µôÁ˵ÄתÖã¨Inversion £©Îļþϵͳ¡££©
È¥µôÁ˼Ǽ¼¶£¨instance-level £©µÄ¹æÔòϵͳ£® µ«Í¨¹ýÖØд¹æÔòÈÔ¿ÉÒÔʹÓùæÔò£®
ÔÚ·¢²¼µÄÔ´ÂëÖÐÔö¼ÓÁËÒ»¸ö¼ò¶ÌµÄ³£Óà SQL ºÍ Postgres95 ÌØÓÐµÄ SQL ÌØÐԵĽ̳̣®
ÓÃGNU make £¨È¡´úÁËBSD make£©ÓÃÓÚÖÆ×÷£® ͬÑù£¬ Postgres95 ¿ÉÒÔʹÓò»¼Ó²¹¶¡µÄgcc£¨ÐÞÕýÁËżÊý×Ö½ÚÊý¾Ý£¨ doubles £©µÄ¶ÔÆëÎÊÌ⣩£®
Postgres95 µÄ°æ±¾µÄ¿ª·¢Öصã·ÅÔÚ±êÃ÷ºÍÀí½âÏÖÓеĺó¶Ë´úÂëÉÏ£® PostgreSQL ¿ª·¢Öصãתµ½ÁËһЩÓÐÕùÒéµÄÌØÐԺ͹¦ÄÜÉÏÁË£¬µ±È»¸÷¸ö·½ÃæµÄ¹¤×÷¶¼ÔÚͬʱ½øÐУ®
PostgreSQL Ö÷ÒªµÄ¸Ä½øÓУº
Ðí¶àÖØÒªµÄºó¶ËÌØÐÔ£¬°üÀ¨×Ó²éѯ£¬È±Ê¡£¨Öµ£©£¬Ô¼ÊøºÍ´¥·¢Æ÷¶¼ÊµÏÖÁË£®
Ôö¼ÓÁ˸½¼ÓµÄ SQL92£¼æÈݵÄÓïÑÔÌØÐÔ£¬°üÀ¨Ö÷¼ü£¬ÒýÓñêʶ£¬Ç¿ÖƵÄÓïÒå×Ö·û´®ÀàÐÍת»»(?literal string type coersion)£¬ÀàÐÍת»»£¬ÒÔ¼°¶þ½øÖƺÍÊ®Áù½øÖÆÕûÊýµÄÊäÈ룮
¸Ä½øÁËÄÚ½¨µÄÊý¾ÝÀàÐÍ£¬ °üÀ¨ÐµĴó·¶Î§ÈÕÆÚ/ʱ¼äÀàÐͺ͸½¼Ó¼¸ºÎÊý¾ÝÀàÐ͵ÄÖ§³Ö£®
×ÜÌåÉϺó¶Ë´úÂëµÄËÙ¶ÈÌá¸ßÁË´óÔ¼20-40%£¬¶øÇÒ×Ôv6.0Æðºó¶ËµÄÆô¶¯Ê±¼äËõ¶ÌÁË80%£®