¼òµ¥»Ø¹Ë Postgres

ÏÖÔÚ±»³ÆΪ PostgreSQL µÄ¶ÔÏó-¹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¨ÓÐÒ»¶Îʱ¼ä±»³ÆΪPostgres95 £©ÊÇ´Ó²®¿ËÀûдµÄ Postgres Èí¼þ°ü·¢Õ¹¶øÀ´µÄ¡£¾­¹ýÊ®¼¸ÄêµÄ·¢Õ¹£¬PostgreSQLÊÀ½çÉÏ¿ÉÒÔ»ñµÃµÄ×îÏȽøµÄ¿ª·ÅÔ´ÂëµÄÊý¾Ý¿âϵͳ£¬ËüÌṩÁ˶à°æ±¾²¢ÐпØÖÆ£¬Ö§³Ö¼¸ºõËùÓÐ SQL ¹¹¼þ£¨°üÀ¨×Ó²éѯ£¬ÊÂÎñºÍÓû§¶¨ÒåÀàÐͺͺ¯Êý£©£¬²¢ÇÒ¿ÉÒÔ»ñµÃ·Ç³£¹ãÀ«·¶Î§µÄ£¨¿ª·¢£©ÓïÑ԰󶨣¨°üÀ¨ C£¬C++£¬Java£¬perl£¬tcl£¬ºÍpython£©¡£

²®¿ËÀûµÄ Postgres ÏîÄ¿

PostgresDBMS µÄʵÏÖʼÓÚ1986Ä꣬ ¸Ãϵͳ×î³õµÄ¸ÅÄîÏê¼û PostgresµÄÉè¼Æ£®×îÔçµÄÊý¾ÝÄ£ÐͶ¨Òå¼ûPostgres Êý¾ÝÄ£ÐÍ£®µ±Ê±µÄ¹æÔòϵͳÉè¼ÆÔÚ Postgres ¹æÔòϵͳÉè¼Æ ÀïÃèÊö£®´æ´¢¹ÜÀíÆ÷µÄÀíÂÛ»ù´¡ºÍÌåϵ½á¹¹ÔÚ Postgres ´æ´¢ÏµÍ³ ÀïÓÐÏêϸÃèÊö£®

´ÓÄÇÒԺ󣬠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ʱÕýʽÖÕÖ¹£®

Postgres95

ÔÚ1994Ä꣬Andrew Yu ºÍ Jolly Chen Ïò PostgresÖÐÔö¼ÓÁËSQLÓïÑԵĽâÊÍÆ÷£®²¢Ëæºó½«Postgres95Ô´´úÂë·¢²¼µ½»¥ÁªÍøÉϹ©´ó¼ÒʹÓ㬳ÉΪһ¸ö¿ª·ÅÔ´ÂëµÄ£¬Ô­ÏȲ®¿ËÀûPostgres´úÂëµÄ¼Ì³ÐÕߣ®
Postgres95 ËùÓÐÔ´´úÂ붼ÊÇÍêÈ«µÄ ANSI C £¬ ¶øÇÒ´úÂëÁ¿¼õÉÙÁË25%£® ²¢ÇÒÓÐÐí¶àÄÚ²¿ÐÞ¸ÄÒÔÀûÓÚÌá¸ßÐÔÄܺʹúÂëµÄά»¤ÐÔ£®Postgres95 v1.0.x ÔÚ½øÐÐWisconsin Benchmark ²âÊÔʱ´ó¸Å±È v4.2¿ì30-50%£® ³ýÁËÐÞÕýÁËһЩ´íÎó£¬ ÆäËûµÄһЩÖ÷Òª¸Ä½ø»¹ÓУº

PostgreSQL

µ½ÁË1996Ä꣬ ÎÒÃǺÜÃ÷ÏԵĿ´³ö¡°Postgres95¡±Õâ¸öÃû×ÖÒѾ­²»Äܾ­µÃÆðʱ¼äµÄ¿¼ÑéÁË£®ÓÚÊÇÎÒÃÇÆðÁËÒ»¸öÐÂÃû×ÖPostgreSQL ÓÃÓÚ·´Ó³×î³õµÄ Postgres ºÍ×îеÄʹÓàSQLµÄ °æ±¾Ö®¼äµÄ¹Øϵ£® ͬʱ°æ±¾ºÅÒ²ÖØдÓ6.0¿ªÊ¼£¬ ½«°æ±¾ºÅ·Å»Øµ½×î³õµÄÓÉ PostgresÏîÄ¿¿ªÊ¼µÄ˳ÐòÖÐÈ¥£®

Postgres95 µÄ°æ±¾µÄ¿ª·¢Öصã·ÅÔÚ±êÃ÷ºÍÀí½âÏÖÓеĺó¶Ë´úÂëÉÏ£® PostgreSQL ¿ª·¢Öصãתµ½ÁËһЩÓÐÕùÒéµÄÌØÐԺ͹¦ÄÜÉÏÁË£¬µ±È»¸÷¸ö·½ÃæµÄ¹¤×÷¶¼ÔÚͬʱ½øÐУ®

PostgreSQL Ö÷ÒªµÄ¸Ä½øÓУº

¿