granicus.if.org Git - postgresql/blob - doc/FAQ_chinese

   1
   2                           PostgreSQL ³£¼ûÎÊÌâ£¨FAQ£©
   3
   4    ×î½ü¸üÐÂ£º2005 Äê 06 ÔÂ 02 ÈÕ ÐÇÆÚÎå 22:27:35 CST
   5
   6    Ä¿Ç°Î¬»¤ÈËÔ±£ºBruce Momjian (pgman@candle.pha.pa.us)
   7    ÖÐÎÄ°æÎ¬»¤ÈËÔ±£ºdoudou586 £¨doudou586_2005@yahoo.com.cn£©
   8
   9    ±¾ÎÄµµµÄ×îÐÂ°æ±¾¿ÉÒÔÔÚ
  10    http://www.postgresql.org/files/documentation/faqs/FAQ.html²é¿´¡£
  11
  12    Óë²Ù×÷ÏµÍ³Æ½Ì¨Ïà¹ØµÄÎÊÌâÔÚhttp://www.postgresql.org/docs/faq/Àï»Ø´ð¡£
  13      _________________________________________________________________
  14
  15 ³£¼ûÎÊÌâ
  16
  17    1.1)PostgreSQL ÊÇÊ²Ã´£¿¸ÃÔõÃ´·¢Òô£¿
  18    1.2)PostgreSQL µÄ°æÈ¨ÊÇÊ²Ã´£¿
  19    1.3)PostgreSQL ¿ÉÒÔÔËÐÐÔÚÄÄÐ©²Ù×÷ÏµÍ³Æ½Ì¨ÉÏ£¿
  20    1.4)ÎÒ´ÓÄÄÀïÄÜµÃµ½ PostgreSQL£¿
  21    1.5)ÎÒ´ÓÄÄÀïÄÜµÃµ½¶Ô PostgreSQL µÄÖ§³Ö£¿
  22    1.6)ÎÒÈçºÎÌá½»Ò»¸öBUG±¨¸æ£¿
  23    1.7)×îÐÂ°æµÄPostgreSQL ÊÇÊ²Ã´£¿
  24    1.8)ÄÜ¹»»ñÈ¡µÄ×îÐÂÎÄµµÓÐÄÄÐ©£¿
  25    1.9)ÎÒÈçºÎÁË½âÒÑÖªµÄ BUG »òÔÝÈ±µÄ¹¦ÄÜ£¿
  26    1.10)ÎÒÓ¦¸ÃÔõÑùÑ§Ï° SQL £¿
  27    1.11)ÎÒÓ¦¸ÃÔõÑù¼ÓÈë¿ª·¢¶ÓÎé£¿
  28    1.12)PostgreSQL ºÍÆäËûÊý¾Ý¿âÏµÍ³±ÈÆðÀ´ÈçºÎ£¿
  29    1.13)Ë¿ØÖÆºÍ¹ÜÀíPostgreSQL £¿
  30
  31 ÓÃ»§¿Í»§¶ËÎÊÌâ
  32
  33    2.1)ÎÒÃÇ¿ÉÒÔÓÃÊ²Ã´ÓïÑÔºÍ PostgreSQL ´ò½»µÀ£¿
  34    2.2)ÓÐÊ²Ã´¹¤¾ß¿ÉÒÔ°Ñ PostgreSQL ÓÃÓÚ Web Ò³Ãæ£¿
  35    2.3)PostgreSQL ÓµÓÐÍ¼ÐÎÓÃ»§½çÃæÂð£¿
  36
  37 ÏµÍ³¹ÜÀíÎÊÌâ
  38
  39    3.1)ÎÒÔõÑù²ÅÄÜ°Ñ PostgreSQL ×°ÔÚ /usr/local/pgsql ÒÔÍâµÄµØ·½£¿
  40    3.2)ÎÒÈçºÎ¿ØÖÆÀ´×ÔÆäËûÖ÷»úµÄÁ¬½Ó£¿
  41    3.3)ÎÒÔõÑùµ÷ÕûÊý¾Ý¿âÒýÇæÒÔ»ñµÃ¸üºÃµÄÐÔÄÜ£¿
  42    3.4)PostgreSQL Àï¿ÉÒÔ»ñµÃÊ²Ã´ÑùµÄµ÷ÊÔÌØÐÔ£¿
  43    3.5)ÎªÊ²Ã´ÔÚÊÔÍ¼Á¬½ÓµÇÂ¼Ê±ÊÕµ½¡°Sorry, too many clients¡± ÏûÏ¢£¿
  44    3.6)ÎªÊ²Ã´ÒªÔÚÉý¼¶ PostgreSQL Ö÷Òª·¢²¼°æ±¾Ê±×ö dump ºÍ restore £¿
  45    3.7)(Ê¹ÓÃPostgreSQL)ÎÒÐèÒªÊ¹ÓÃÊ²Ã´¼ÆËã»úÓ²¼þ £¿
  46
  47 ²Ù×÷ÎÊÌâ
  48
  49    4.1)ÈçºÎÖ»Ñ¡ÔñÒ»¸ö²éÑ¯½á¹ûµÄÍ·¼¸ÐÐ£¿»òÊÇËæ»úµÄÒ»ÐÐ£¿
  50    4.2)ÈçºÎ²é¿´±í¡¢Ë÷Òý¡¢Êý¾Ý¿âÒÔ¼°ÓÃ»§µÄ¶¨Òå£¿ÈçºÎ²é¿´psqlÀïÓÃµ½µÄ²éÑ¯Ö¸
  51    Áî²¢ÏÔÊ¾ËüÃÇ£¿
  52    4.3)ÈçºÎ¸ü¸ÄÒ»¸ö×Ö¶ÎµÄÊý¾ÝÀàÐÍ£¿
  53    4.4)Ò»ÐÐ¼ÇÂ¼£¬Ò»¸ö±í£¬Ò»¸ö¿âµÄ×î´ó³ß´çÊÇ¶àÉÙ£¿
  54    4.5)´æ´¢Ò»¸öµäÐÍµÄÎÄ±¾ÎÄ¼þÀïµÄÊý¾ÝÐèÒª¶àÉÙ´ÅÅÌ¿Õ¼ä£¿
  55    4.6)ÎªÊ²Ã´ÎÒµÄ²éÑ¯ºÜÂý£¿ÎªÊ²Ã´ÕâÐ©²éÑ¯Ã»ÓÐÀûÓÃË÷Òý£¿
  56    4.7)ÎÒÈçºÎ²ÅÄÜ¿´µ½²éÑ¯ÓÅ»¯Æ÷ÊÇÔõÑùÆÀ¹À´¦ÀíÎÒµÄ²éÑ¯µÄ£¿
  57    4.8)ÎÒÔõÑù×öÕýÔò±í´ïÊ½ËÑË÷ºÍ´óÐ¡Ð´ÎÞ¹ØµÄÕýÔò±í´ïÊ½²éÕÒ£¿ÔõÑùÀûÓÃË÷Òý½ø
  58    ÐÐ´óÐ¡Ð´ÎÞ¹Ø²éÕÒ£¿
  59    4.9)ÔÚÒ»¸ö²éÑ¯Àï£¬ÎÒÔõÑù¼ì²âÒ»¸ö×Ö¶ÎÊÇ·ñÎª
  60    NULL£¿ÎÒÈçºÎ²ÅÄÜ×¼È·ÅÅÐò¶ø²»ÂÛÄ³×Ö¶ÎÊÇ·ñº¬NULLÖµ£¿
  61    4.10)¸÷ÖÖ×Ö·ûÀàÐÍÖ®¼äÓÐÊ²Ã´²»Í¬£¿
  62    4.11.1)ÎÒÔõÑù´´½¨Ò»¸öÐòÁÐºÅ/×Ô¶¯µÝÔöµÄ×Ö¶Î£¿
  63    4.11.2)ÎÒÈçºÎ»ñµÃÒ»¸ö²åÈëµÄÐòÁÐºÅµÄÖµ£¿
  64    4.11.3)Ê¹ÓÃ currval() »áµ¼ÖÂºÍÆäËûÓÃ»§µÄÎÉÂÒÇé¿ö£¨race condition£©Âð£¿
  65    4.11.4)ÎªÊ²Ã´²»ÔÚÊÂÎñÒì³£ÖÐÖ¹ºóÖØÓÃÐòÁÐºÅÄØ£¿ÎªÊ²Ã´ÔÚÐòÁÐºÅ×Ö¶ÎµÄÈ¡ÖµÖ
  66    Ð´æÔÚ¼ä¶ÏÄØ£¿
  67    4.12)Ê²Ã´ÊÇ OID£¿Ê²Ã´ÊÇ CTID £¿
  68    4.13)ÎªÊ²Ã´ÎÒÊÕµ½´íÎóÐÅÏ¢¡°ERROR: Memory exhausted in
  69    AllocSetAlloc()¡±£¿
  70    4.14)ÎÒÈçºÎ²ÅÄÜÖªµÀËùÔËÐÐµÄ PostgreSQL µÄ°æ±¾£¿
  71    4.15)ÎÒÈçºÎ´´½¨Ò»¸öÈ±Ê¡ÖµÊÇµ±Ç°Ê±¼äµÄ×Ö¶Î£¿
  72    4.16)ÈçºÎ½øÐÐ outer join £¨ÍâÁ¬½Ó£©£¿
  73    4.17)ÈçºÎÊ¹ÓÃÉæ¼°¶à¸öÊý¾Ý¿âµÄ²éÑ¯£¿
  74    4.18)ÈçºÎÈÃº¯Êý·µ»Ø¶àÐÐ»ò¶àÁÐ£¿
  75    4.19)ÎªÊ²Ã´ÎÒÔÚÊ¹ÓÃPL/PgSQLº¯Êý´æÈ¡ÁÙÊ±±íÊ±»áÊÕµ½´íÎóÐÅÏ¢¡°relation
  76    with OID ##### does not exist¡±£¿
  77    4.20)Ä¿Ç°ÓÐÄÄÐ©Êý¾Ý¸´ÖÆ·½°¸¿ÉÓÃ£¿
  78      _________________________________________________________________
  79
  80 ³£¼ûÎÊÌâ
  81
  82     1.1)PostgreSQL ÊÇÊ²Ã´£¿¸ÃÔõÃ´·¢Òô£¿
  83
  84    PostgreSQL ¶Á×÷ Post-Gres-Q-L£¬ÓÐÊ±ºòÒ²¼ò³ÆÎªPostgres ¡£
  85
  86    PostgreSQL
  87    ÊÇÃæÏòÄ¿±êµÄ¹ØÏµÊý¾Ý¿âÏµÍ³£¬Ëü¾ßÓÐ´«Í³ÉÌÒµÊý¾Ý¿âÏµÍ³µÄËùÓÐ¹¦ÄÜ£¬Í¬Ê±ÓÖ
  88    º¬ÓÐ½«ÔÚÏÂÒ»´ú DBMS ÏµÍ³µÄÊ¹ÓÃµÄÔöÇ¿ÌØÐÔ¡£ PostgreSQL
  89    ÊÇ×ÔÓÉÃâ·ÑµÄ£¬²¢ÇÒËùÓÐÔ´´úÂë¶¼¿ÉÒÔ»ñµÃ¡£
  90
  91    PostgreSQL
  92    µÄ¿ª·¢¶ÓÎéÖ÷ÒªÎªÖ¾Ô¸Õß£¬ËûÃÇ±é²¼ÊÀ½ç¸÷µØ²¢Í¨¹ý»¥ÁªÍø½øÐÐÁªÏµ£¬ÕâÊÇÒ»¸ö
  93    ÉçÇø¿ª·¢ÏîÄ¿£¬Ëü²»±»ÈÎºÎ¹«Ë¾¿ØÖÆ¡£
  94    ÈçÏë¼ÓÈë¿ª·¢¶ÓÎé£¬Çë²Î¼û¿ª·¢ÈËÔ±³£¼ûÎÊÌâ£¨FAQ£©
  95    http://www.postgresql.org/files/documentation/faqs/FAQ_DEV.html
  96
  97     1.2)PostgreSQL µÄ°æÈ¨ÊÇÊ²Ã´?
  98
  99    PostgreSQLµÄ·¢²¼×ñ´Ó¾
 100    µäµÄBSD°æÈ¨¡£¹ØÓÚÔ´´úÂëµÄÈçºÎÊ¹ÓÃÃ»ÓÐÈÎºÎÏÞÖÆ£¬ÎÒÃÇºÜÏ²»¶ÕâÖÖ·½Ê½²¢ÇÒ»
 101    ¹Ã»ÓÐ´òËã¸Ä±äËü¡£
 102
 103    ÏÂÃæ¾ÍÊÇÎÒÃÇÊ¹ÓÃµÄBSD°æÈ¨ÄÚÈÝ£º
 104
 105    ²¿·Ö°æÈ¨£¨c£©1996-2005£¬PostgreSQL
 106    È«Çò¿ª·¢Ð¡×é£¬²¿·Ö°æÈ¨£¨c£©1994-1996 ¼ÓÖÝ´óÑ§¶ÊÂ
 107
 108    £¨Portions copyright (c) 1996-2005, PostgreSQL Global Development
 109    Group Portions Copyright (c) 1994-6 Regents of the University of
 110    California£©
 111
 112    ÔÊÐíÎªÈÎºÎÄ¿µÄÊ¹ÓÃ£¬¿½±´£¬ÐÞ¸ÄºÍ·Ö·¢Õâ¸öÈí¼þºÍËüµÄÎÄµµ¶ø²»ÊÕÈ¡ÈÎºÎ·ÑÓÃ
 113    £¬
 114    ²¢ÇÒÎÞÐëÇ©ÊðÒò´Ë¶ø²úÉúµÄÖ¤Ã÷£¬Ç°ÌáÊÇÉÏÃæµÄ°æÈ¨ÉùÃ÷ºÍ±¾¶ÎÒÔ¼°ÏÂÃæÁ½¶ÎÎÄ
 115    ×Ö³öÏÖÔÚËùÓÐ¿½±´ÖÐ¡£
 116
 117    £¨Permission to use, copy, modify, and distribute this software and
 118    its documentation for any purpose, without fee, and without a written
 119    agreement is hereby granted, provided that the above copyright notice
 120    and this paragraph and the following two paragraphs appear in all
 121    copies.£©
 122
 123    ÔÚÈÎºÎÇé¿öÏÂ£¬¼ÓÖÝ´óÑ§¶¼²»³Ðµ£ÒòÊ¹ÓÃ´ËÈí¼þ¼°ÆäÎÄµµ¶øµ¼ÖÂµÄ¶ÔÈÎºÎµ±ÊÂÈË
 124    µÄÖ±½ÓµÄ£¬
 125    ¼ä½ÓµÄ£¬ÌØÊâµÄ£¬¸½¼ÓµÄ»òÕßÏà°é¶øÉúµÄËð»µ£¬°üÀ¨ÀûÒæËðÊ§µÄÔðÈÎ£¬¼´Ê¹¼ÓÖÝ
 126    ´óÑ§ÒÑ¾½¨ÒéÁËÕâÐ©ËðÊ§µÄ¿ÉÄÜÐÔÊ±Ò²ÊÇÈç´Ë¡£
 127
 128    £¨IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY
 129    PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL
 130    DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS
 131    SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA
 132    HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.£©
 133
 134    ¼ÓÖÝ´óÑ§Ã÷È··ÅÆúÈÎºÎ±£Ö¤£¬°üÀ¨µ«²»¾ÖÏÞÓÚÄ³Ò»ÌØ¶¨ÓÃÍ¾µÄÉÌÒµºÍÀûÒæµÄÒþº¬
 135    ±£Ö¤¡£
 136    ÕâÀïÌá¹©µÄÕâ·ÝÈí¼þÊÇ»ùÓÚ¡°µ±×÷ÊÇ¡±µÄ»ù´¡µÄ£¬Òò¶ø¼ÓÖÝ´óÑ§Ã»ÓÐÔðÈÎÌá¹©Î¬
 137    »¤£¬Ö§³Ö£¬¸üÐÂ£¬ÔöÇ¿»òÕßÐÞ¸ÄµÄ·þÎñ¡£
 138
 139    £¨THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,
 140    INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
 141    MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE
 142    PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE UNIVERSITY OF
 143    CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT,
 144    UPDATES, ENHANCEMENTS, OR MODIFICATIONS.£©
 145
 146     1.3)PostgreSQL ¿ÉÒÔÔËÐÐÔÚÄÄÐ©²Ù×÷ÏµÍ³Æ½Ì¨ÉÏ£¿
 147
 148    Ò»°ãËµÀ´£¬Ò»¸öÏÖ´úµÄ UNIX ¼æÈÝµÄÆ½Ì¨¶¼ÄÜÔËÐÐ PostgreSQL
 149    ¡£ÔÚ°²×°Ö¸ÄÏÀïÁÐ³öÁË·¢²¼Ê±¾¹ýÃ÷È·²âÊÔµÄÆ½Ì¨¡£
 150
 151    PostgreSQlÒ²¿ÉÒÔÖ±½ÓÔËÐÐÔÚ»ùÓÚÎ¢ÈíWindows-NTµÄ²Ù×÷ÏµÍ³£¬ÈçWin2000£¬Win
 152    XP ºÍ Win2003£¬ÒÑÖÆ×÷Íê³ÉµÄ°²×°°ü¿É´Ó
 153    http://pgfoundry.org/projects/pginstallerÏÂÔØ£¬»ùÓÚMSDOSµÄWindows²Ù×÷Ï
 154    µÍ³ £¨Win95£¬Win98£¬WinMe£©ÐèÒªÍ¨¹ýCygwinÄ£Äâ»·¾³ÔËÐÐPostgreSQL¡£
 155
 156    Í¬Ê±Ò²ÓÐÒ»¸öÎªNovell Netware 6¿ª·¢µÄ°æ±¾¿É´Ó http://forge.novell.com
 157    »ñÈ¡£¬ÎªOS/2¿ª·¢µÄ°æ±¾¿É´Ó
 158    http://hobbes.nmsu.edu/cgi-bin/h-search?sh=1&button=Search&key=postgre
 159    SQL&stype=all&sort=type&dir=%2F
 160
 161     1.4)ÎÒ´ÓÄÄÀïÄÜµÃµ½ PostgreSQL£¿
 162
 163    Í¨¹ýä¯ÀÀÆ÷¿É´Óhttp://www.postgresql.org/ftp/ÏÂÔØ£¬Ò²¿ÉÍ¨¹ýFTP£¬´Ó
 164    ftp://ftp.PostgreSQL.org/pub/Õ¾µãÏÂÔØ¡£
 165
 166     1.5)ÎÒ´ÓÄÄÀïÄÜµÃµ½¶Ô PostgreSQL µÄÖ§³Ö£¿
 167
 168    PostgreSQLÉçÇøÍ¨¹ýÓÊ¼þÁÐ±íÎªÆä´ó¶àÊýÓÃ»§Ìá¹©°ïÖú£¬¼ÓÈëÓÊ¼þÁÐ±íµÄÖ÷Õ¾µã
 169    ÊÇ
 170    http://www.postgresql.org/community/lists/£¬Ò»°ãÇé¿öÏÂ£¬ÏÈ¼ÓÈëGeneral
 171    »ò BugÓÊ¼þÁÐ±íÊÇÒ»¸ö½ÏºÃµÄ¿ªÊ¼¡£
 172
 173    Ö÷ÒªµÄIRCÆµµÀÊÇÔÚFreeNode(irc.freenode.net)µÄ#postgresql£¬ÎªÁËÁ¬ÉÏ´ËÆµ
 174    µÀ£¬¿ÉÒÔÊ¹ÓÃUNIX³ÌÐòirc£¬ÆäÖ¸Áî¸ñÊ½£º irc -c '#postgresql' "$USER"
 175    irc.freenode.net
 176    £¬»òÕßÊ¹ÓÃÆäËûIRC¿Í»§¶Ë³ÌÐò¡£ÔÚ´ËÍøÂçÖÐ»¹´æÔÚÒ»¸öPostgreSQLµÄÎ÷°àÑÀÆµµ
 177    À(#postgersql-es)ºÍ·¨ÓïÆµµÀ
 178    (#postgresql-fr)¡£Í¬ÑùµØ£¬ÔÚEFNETÉÏÒ²ÓÐÒ»¸öPostgreSQLµÄ½»Á÷ÆµµÀ¡£
 179
 180    ÉÌÒµÖ§³Ö¹«Ë¾µÄÁÐ±íÔÚ http://techdocs.postgresql.org/companies.php¡£
 181
 182     1.6)ÎÒÈçºÎÌá½»Ò»¸öBUG±¨¸æ£¿
 183
 184    ¿É·ÃÎÊ
 185    http://www.postgresql.org/support/submitbug£¬ÌîÐ´BugÉÏ±¨±í¸ñ¼´¿É¡£
 186
 187    Í¬ÑùÒ²¿É·ÃÎÊftpÕ¾µãftp://ftp.PostgreSQL.org/pub/
 188    ¼ì²éÓÐÎÞ¸üÐÂµÄPostgreSQL°æ±¾»ò²¹¶¡¡£
 189
 190     1.7)×îÐÂ°æµÄPostgreSQL ÊÇÊ²Ã´£¿
 191
 192    PostgreSQL ×îÐÂµÄ°æ±¾ÊÇ°æ±¾ 8.0.2 £¨Òë×¢£ºÏÖ×îÐÂ°æ±¾Îª8.0.3£©¡£
 193
 194    ÎÒÃÇ¼Æ»®Ã¿Äê·¢²¼Ò»¸öÖ÷Òª°æ±¾£¬Ã¿¼¸¸öÔÂ·¢²¼Ò»¸öÐ¡°æ±¾¡£
 195
 196     1.8)ÄÜ¹»»ñÈ¡µÄ×îÐÂÎÄµµÓÐÄÄÐ©£¿
 197
 198    PostgreSQL°üº¬´óÁ¿µÄÎÄµµ£¬Ö÷ÒªÓÐÒ»Ð©ÊÖ²á£¬ÊÖ²áÒ³ºÍÒ»Ð©µÄ²âÊÔÀý×Ó¡£²Î¼û
 199    /doc Ä¿Â¼£¨Òë×¢£ºÓ¦Îª $PGHOME/doc£©¡£ Äã»¹¿ÉÒÔÔÚÏßä¯ÀÀ PostgreSQL
 200    µÄÊÖ²á£¬ÆäµØÖ·ÊÇ£ºhttp://www.PostgreSQL.org/docs¡£
 201
 202    ÓÐÁ½±¾¹ØÓÚ PostgreSQL µÄÊéÔÚÏßÌá¹©£¬ÔÚ
 203    http://www.PostgreSQL.org/docs/awbook.html ºÍ
 204    http://www.commandprompt.com/ppbook/ ¡£
 205    Ò²ÓÐ´óÁ¿µÄPostgreSQLÊé¼®¿É¹©¹ºÂò£¬ÆäÖÐ×îÎªÁ÷ÐÐµÄÒ»±¾ÊÇÓÉKorry
 206    Douglas±àÐ´µÄ¡£ÔÚ
 207    http://techdocs.PostgreSQL.org/techdocs/bookreviews.phpÉÏ
 208    ÉÏÓÐ´óÁ¿ÓÐ¹ØPostgreSQLÊé¼®µÄ¼ò½é¡£ ÔÚ
 209    http://techdocs.PostgreSQL.org/ÉÏÊÕ¼¯ÁËÓÐ¹Ø PostgreSQL
 210    µÄ´óÁ¿¼¼ÊõÎÄÕÂ¡£
 211
 212    ¿Í»§¶ËµÄÃüÁîÐÐ³ÌÐòpsqlÓÐÒ»Ð©ÒÔ \d
 213    ¿ªÍ·µÄÃüÁî£¬¿ÉÏÔÊ¾¹ØÓÚÀàÐÍ£¬²Ù×÷·û£¬º¯Êý£¬»ã×ÜµÈµÄÐÅÏ¢£¬Ê¹ÓÃ \?
 214    ¿ÉÒÔÏÔÊ¾ËùÓÐ¿ÉÓÃµÄÃüÁî¡£
 215
 216    ÎÒÃÇµÄ web Õ¾µã°üº¬¸ü¶àµÄÎÄµµ¡£
 217
 218     1.9)ÎÒÈçºÎÁË½âÒÑÖªµÄ BUG »òÔÝÈ±µÄ¹¦ÄÜ£¿
 219
 220    PostgreSQL Ö§³ÖÒ»¸öÀ©Õ¹ÁËµÄ SQL-92 µÄ×Ó¼¯¡£²ÎÔÄÎÒÃÇµÄTODO
 221    ÁÐ±í£¬»ñÈ¡Ò»¸öÒÑÖªBug£¬ÔÝÈ±µÄ¹¦ÄÜºÍ½«À´µÄ¼Æ»®¡£
 222
 223     1.10)ÎÒÓ¦¸ÃÔõÑùÑ§Ï° SQL £¿
 224
 225    Ê×ÏÈ¿¼ÂÇÉÏÊöÌáµ½µÄÓëPostgreSQLÏà¹ØµÄÊé¼®£¬ÁíÍâÒ»±¾ÊÇTeach Yourself SQL
 226    in 21 Days, Second Edition£¬ ÎÒÃÇµÄÐí¶àÓÃ»§Ï²»¶The Practical SQL
 227    Handbook Bowman, Judith S., et al., Addison-Wesley£¬ÆäËûµÄÔòÏ²»¶ The
 228    Complete Reference SQL, Groff et al., McGraw-Hill¡£
 229
 230     1.11)ÎÒÓ¦¸ÃÔõÑù¼ÓÈë¿ª·¢¶ÓÎé£¿
 231
 232    Ïê¼û Developer's FAQ ¡£
 233
 234     1.12)PostgreSQL ºÍÆäËûÊý¾Ý¿âÏµÍ³±ÈÆðÀ´ÈçºÎ£¿
 235
 236    ÆÀ¼ÛÈí¼þÓÐºÃ¼¸ÖÖ·½·¨£ºÌØÐÔ£¬ÐÔÄÜ£¬¿É¿¿ÐÔ£¬Ö§³ÖºÍ¼Û¸ñ¡£
 237
 238    ÌØÐÔ
 239           PostgreSQL ÓµÓÐ´óÐÍÉÌÓÃ DBMS Àï´ó¶àÊýÌØÐÔ£¬
 240           ÀýÈç£ºÊÂÎñ£¬×Ó²éÑ¯£¬´¥·¢Æ÷£¬ÊÓÍ¼£¬Íâ¼ü²Î¿¼ÍêÕûÐÔºÍ¸´ÔÓµÄËøµÈ¡£
 241           ÎÒÃÇ»¹ÓÐÒ»Ð©ËüÃÇÃ»ÓÐµÄÌØÐÔ£¬ÈçÓÃ»§¶¨ÒåÀàÐÍ£¬¼Ì³Ð£¬¹æÔòºÍ¶à°æ±¾²
 242           ¢ÐÐ¿ØÖÆÒÔ¼õÉÙËøµÄÕùÓÃµÈ¡£
 243
 244    ÐÔÄÜ
 245           PostgreSQL ºÍÆäËûÉÌÓÃºÍ¿ªÔ´µÄÊý¾Ý¿â¾ßÓÐÀàËÆµÄÐÔÄÜ¡£
 246           ¶ÔÄ³Ð©´¦ÀíËü±È½Ï¿ì£¬¶ÔÆäËûÒ»Ð©´¦ÀíËü±È½ÏÂý¡£
 247           ÓëÆäËûÊý¾Ý¿âÏà±È£¬ÎÒÃÇµÄÐÔÄÜÍ¨³£ÔÚ +/- 10%Ö®¼ä¡£
 248
 249    ¿É¿¿ÐÔ
 250           ÎÒÃÇÖªµÀ DBMS ±ØÐëÊÇ¿É¿¿µÄ£¬·ñÔòËü¾ÍÒ»µãÓÃ¶¼Ã»ÓÐ¡£
 251           ÎÒÃÇÅ¬Á¦×öµ½·¢²¼¾
 252           ¹ýÈÏÕæ²âÊÔµÄ£¬ÎÈ¶¨µÄ³ô³æ×îÉÙµÄ´úÂë¡£Ã¿¸ö°æ±¾ÖÁÉÙÓÐÒ»¸öÔÂµÄ beta
 253           ²âÊÔÊ±¼ä£¬²¢ÇÒÎÒÃÇµÄ·¢²¼ÀúÊ·ÏÔÊ¾ÎÒÃÇ¿ÉÒÔÌá¹©ÎÈ¶¨µÄ£¬ÀÎ¹ÌµÄ£¬¿ÉÓ
 254           ÃÓÚÉú²úÊ¹ÓÃµÄ°æ±¾¡£ÎÒÃÇÏàÐÅ
 255           ÔÚÕâ·½ÃæÎÒÃÇÓëÆäËûµÄÊý¾Ý¿âÈí¼þÊÇÏàµ±µÄ¡£
 256
 257    Ö§³Ö
 258           ÎÒÃÇµÄÓÊ¼þÁÐ±íÌá¹©Ò»¸ö·Ç³£´óµÄ¿ª·¢ÈËÔ±ºÍÓÃ»§µÄ×éÒÔ°ïÖú½â¾öËùÅöµ
 259           ½µÄÈÎºÎÎÊÌâ¡£ ÎÒÃÇ²»ÄÜ±£Ö¤¿Ï¶¨ÄÜ½â¾öÎÊÌâ£¬Ïà±ÈÖ®ÏÂ£¬ÉÌÓÃ DBMS
 260           Ò²²¢²»ÊÇ×ÜÄÜ¹»Ìá¹©½â¾ö·½·¨¡£
 261           Ö±½ÓÓë¿ª·¢ÈËÔ±£¬ÓÃ»§Èº£¬ÊÖ²áºÍÔ´³ÌÐò½Ó´¥Áî PostgreSQL
 262           µÄÖ§³Ö±ÈÆäËû DBMS
 263           »¹ÒªºÃ¡£»¹ÓÐÒ»Ð©ÉÌÒµÐÔµÄÔ¤°ü×°µÄÖ§³Ö£¬¿ÉÒÔ¸øÌá¹©¸øÄÇÐ©ÐèÒªµÄÈË¡
 264           ££¨²ÎÔÄ FAQ Ìõ¿î 1.5 Ð¡½Ú£©
 265
 266    ¼Û¸ñ
 267           ÎÒÃÇ¶ÔÈÎºÎÓÃÍ¾¶¼Ãâ·Ñ£¬°üÀ¨ÉÌÓÃºÍ·ÇÉÌÓÃÄ¿µÄ¡£
 268           Äã¿ÉÒÔ²»¼ÓÏÞÖÆµØÏòÄãµÄ²úÆ·Àï¼ÓÈëÎÒÃÇµÄ´úÂë£¬³ýÁËÄÇÐ©ÎÒÃÇÔÚÉÏÃæµ
 269           Ä°æÈ¨ÉùÃ÷ÀïÉùÃ÷µÄ BSD ·ç¸ñµÄ°æÈ¨Íâ¡£
 270
 271     1.13)Ë¿ØÖÆPostgreSQL £¿
 272
 273    Èç¹ûÄãÔÚÑ°ÕÒPostgreSQLµÄÕÆÃÅÈË£¬»òÊÇÊ²Ã´ÖÐÑëÎ¯Ô±»á£¬»òÊÇÊ²Ã´ËùÊô¹«Ë¾£¬
 274    ÄãÖ»ÄÜ·ÅÆúÁË---ÒòÎªÒ»¸öÒ²²»´æÔÚ£¬µ«ÎÒÃÇµÄÈ·ÓÐÒ»¸ö
 275    Î¯Ô±»áºÍCVS¹ÜÀí×é£¬µ«ÕâÐ©¹¤×÷×éµÄÉèÁ¢Ö÷ÒªÊÇÎªÁË½øÐÐ¹ÜÀí¹¤×÷¶ø²»ÊÇ¶ÔPos
 276    tgreSQL½øÐÐ¿ØÖÆ£¬PostgreSQLÏîÄ¿ÊÇÓÉÈÎºÎÈË¾ù
 277    ¿É²Î¼ÓµÄ¿ª·¢ÈËÔ±ÉçÇøºÍËùÓÐÓÃ»§¿ØÖÆµÄ£¬ÄãËùÐèÒª×öµÄ¾ÍÊÇ¼ÓÈëÓÊ¼þÁÐ±í£¬²Î
 278    ÓëÌÖÂÛ¼´¿É£¨Òª²ÎÓëPostgreSQLµÄ¿ª·¢Ïê¼û Developer's FAQ »ñÈ¡ÐÅÏ¢£©¡£
 279      _________________________________________________________________
 280
 281 ÓÃ»§¿Í»§¶ËÎÊÌâ
 282
 283     2.1)ÎÒÃÇ¿ÉÒÔÓÃÊ²Ã´ÓïÑÔºÍ PostgreSQL ´ò½»µÀ£¿
 284
 285    PostgreSQL(È±Ê¡Çé¿ö)Ö»°²×°ÓÐCºÍÄÚÇ¶Ê½CµÄ½Ó¿Ú£¬ÆäËûµÄ½Ó¿Ú¶¼ÊÇ¶ÀÁ¢µÄÏîÄ¿
 286    £¬ÄÜ¹»·Ö±ðÏÂÔØ£¬ÕâÐ©½Ó¿ÚÏîÄ¿¶ÀÁ¢µÄºÃ´¦
 287    ÊÇËûÃÇ¿ÉÒÔÓÐ¸÷×ÔµÄ·¢²¼¼Æ»®ºÍ¸÷×Ô¶ÀÁ¢µÄ¿ª·¢×é¡£
 288
 289    Ò»Ð©±à³ÌÓïÑÔÈçPHP¶¼ÓÐ·ÃÎÊ PostgreSQL
 290    µÄ½Ó¿Ú£¬Perl,TCL,PythonÒÔ¼°ºÜ¶àÆäËûÓïÑÔµÄ½Ó¿ÚÔÚ
 291    http://gborg.postgresql.org ÉÏµÄDrivers/InterfacesÐ¡½Ú¿ÉÕÒµ½£¬
 292    ²¢ÇÒÍ¨¹ýInternetºÜÈÝÒ×ËÑË÷µ½¡£
 293
 294     2.2)ÓÐÊ²Ã´¹¤¾ß¿ÉÒÔ°Ñ PostgreSQL ÓÃÓÚ Web Ò³Ãæ£¿
 295
 296    Ò»¸ö½éÉÜÒÔÊý¾Ý¿âÎªºóÌ¨µÄÍ¦²»´íµÄÕ¾µãÊÇ£ºhttp://www.webreview.com¡£
 297
 298    ¶ÔÓÚ Web ¼¯³É£¬PHP ÊÇÒ»¸ö¼«ºÃµÄ½Ó¿Ú¡£ËüÔÚ£ºhttp://www.php.net/¡£
 299
 300    ¶ÔÓÚ¸´ÔÓµÄÈÎÎñ£¬ºÜ¶àÈË²ÉÓÃ Perl ½Ó¿ÚºÍ CGI.pm »ò mod_perl ¡£
 301
 302     2.3)PostgreSQL ÓµÓÐÍ¼ÐÎÓÃ»§½çÃæÂð£¿
 303
 304    ÊÇµÄ£¬ÔÚ
 305    http://techdocs.postgresql.org/guides/GUIToolsÓÐÒ»¸öÏêÏ¸µÄÁÐ±í¡£
 306      _________________________________________________________________
 307
 308 ÏµÍ³¹ÜÀíÎÊÌâ
 309
 310     3.1)ÎÒÔõÑùÄÜ°Ñ PostgreSQL ×°ÔÚ /usr/local/pgsql ÒÔÍâµÄµØ·½£¿
 311
 312    ÔÚÔËÐÐ configure Ê±¼ÓÉÏ --prefix Ñ¡Ïî¡£
 313
 314     3.2)ÎÒÈçºÎ¿ØÖÆÀ´×ÔÆäËûÖ÷»úµÄÁ¬½Ó£¿
 315
 316    È±Ê¡Ê±£¬PostgreSQL Ö»ÔÊÐíÍ¨¹ý unix
 317    ÓòÌ×½Ó×Ö»òTCP/IP·½Ê½ÇÒÀ´×Ô±¾»úµÄÁ¬½Ó¡£
 318    ÄãÖ»ÓÐÔÚÐÞ¸ÄÁËÅäÖÃÎÄ¼þpostgresql.confÖÐµÄlisten_addresses£¬ÇÒÒ²ÔÚÅäÖÃÎ
 319    Ä¼þpg_hba.confÖÐ´ò¿ªÁË Ö÷»úÎª»ù´¡£¨ host-based
 320    £©µÄÉí·ÝÈÏÖ¤£¬²¢ÖØÐÂÆô¶¯PostgreSQL£¬·ñÔòÆäËû»úÆ÷ÊÇ²»ÄÜÓëÄãµÄPostgreSQL
 321    ·þÎñÆ÷Á¬½ÓµÄ¡£
 322
 323     3.3)ÎÒÔõÑùµ÷ÕûÊý¾Ý¿âÒýÇæÒÔ»ñµÃ¸üºÃµÄÐÔÄÜ£¿
 324
 325    ÓÐÈý¸öÖ÷Òª·½Ãæ¿ÉÒÔÌáÉýPostgreSQLµÄÇ±ÄÜ¡£
 326
 327    ²éÑ¯·½Ê½µÄ±ä»¯
 328           ÕâÖ÷ÒªÉæ¼°ÐÞ¸Ä²éÑ¯·½Ê½ÒÔ»ñÈ¡¸üºÃµÄÐÔÄÜ:
 329
 330           + ´´½¨Ë÷Òý£¬°üÀ¨±í´ïÊ½ºÍ²¿·ÖË÷Òý£»
 331           + Ê¹ÓÃCOPYÓï¾ä´úÌæ¶à¸öInsertÓï¾ä£»
 332           + ½«¶à¸öSQLÓï¾ä×é³ÉÒ»¸öÊÂÎñÒÔ¼õÉÙÌá½»ÊÂÎñµÄ¿ªÏú£»
 333           + ´ÓÒ»¸öË÷ÒýÖÐÌáÈ¡¶àÌõ¼ÇÂ¼Ê±Ê¹ÓÃCLUSTER£»
 334           + ´ÓÒ»¸ö²éÑ¯½á¹ûÖÐÈ¡³ö²¿·Ö¼ÇÂ¼Ê±Ê¹ÓÃLIMIT£»
 335           + Ê¹ÓÃÔ¤±àÒëÊ½²éÑ¯£¨Prepared Query)£»
 336           + Ê¹ÓÃANALYZEÒÔ±£³Ö¾«È·µÄÓÅ»¯Í³¼Æ£»
 337           + ¶¨ÆÚÊ¹ÓÃ VACUUM »ò pg_autovacuum
 338           + ½øÐÐ´óÁ¿Êý¾Ý¸ü¸ÄÊ±ÏÈÉ¾³ýË÷Òý£¨È»ºóÖØ½¨Ë÷Òý£©
 339
 340    ·þÎñÆ÷µÄÅäÖÃ
 341           ÅäÖÃÎÄ¼þpostgres.confÖÐµÄºÜ¶àÉèÖÃ¶¼»áÓ°ÏìÐÔÄÜ£¬ËùÓÐ²ÎÊýµÄÁÐ±í¿É
 342           ¼û£º Administration Guide/Server Run-time Environment/Run-time
 343           Configuration£¬ ÓÐ¹Ø²ÎÊýµÄ½âÊÍ¿É¼û£º
 344           http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_co
 345           nf_e.html ºÍ
 346           http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html¡£
 347
 348    Ó²¼þµÄÑ¡Ôñ
 349           ¼ÆËã»úÓ²¼þ¶ÔÐÔÄÜµÄÓ°Ïì¿Éä¯ÀÀ
 350           http://candle.pha.pa.us/main/writings/pgsql/hw_performance/inde
 351           x.html ºÍ http://www.powerpostgresql.com/PerfList/¡£
 352
 353     3.4)PostgreSQL Àï¿ÉÒÔ»ñµÃÊ²Ã´ÑùµÄµ÷ÊÔÌØÐÔ£¿
 354
 355    PostgreSQL ÓÐºÜ¶àÀàËÆ log_*
 356    µÄ·þÎñÆ÷ÅäÖÃ±äÁ¿¿ÉÓÃÓÚ²éÑ¯µÄ´òÓ¡ºÍ½ø³ÌÍ³¼Æ£¬¶øÕâÐ©¹¤×÷¶Ôµ÷ÊÔºÍÐÔÄÜ²âÊÔ
 357    ºÜÓÐ°ïÖú¡£
 358
 359     3.5)ÎªÊ²Ã´ÔÚÊÔÍ¼Á¬½ÓÊ±ÊÕµ½¡°Sorry, too many clients¡±ÏûÏ¢£¿
 360
 361    Õâ±íÊ¾ÄãÒÑ´ïµ½È±Ê¡100¸ö²¢·¢ºóÌ¨½ø³ÌÊýµÄÏÞÖÆ£¬ÄãÐèÒªÍ¨¹ýÐÞ¸Äpostgresql.
 362    confÎÄ¼þÖÐµÄmax_connectionsÖµÀ´
 363    Ôö¼ÓpostmasterµÄºóÌ¨²¢·¢´¦ÀíÊý£¬ÐÞ¸ÄºóÐèÖØÐÂÆô¶¯postmaster¡£
 364
 365     3.6)ÎªÊ²Ã´ÒªÔÚÉý¼¶ PostgreSQL Ö÷Òª·¢²¼°æ±¾Ê±×ö dump ºÍ restore £¿
 366
 367    PostgreSQL ¿ª·¢×é¶ÔÃ¿´ÎÐ¡µÄÉý¼¶½ö×öÁË½ÏÉÙµÄÐÞ¸Ä£¬Òò´Ë´Ó 7.4.0 Éý¼¶µ½
 368    7.4.1 ²»ÐèÒª dump ºÍ restore¡£ µ«ÊÇÖ÷ÒªµÄÉý¼¶£¨ÀýÈç´Ó 7.3 µ½
 369    7.4£©Í¨³£»áÐÞ¸ÄÏµÍ³±íºÍÊý¾Ý±íµÄÄÚ²¿¸ñÊ½¡£
 370    ÕâÐ©±ä»¯Ò»°ã±È½Ï¸´ÔÓ£¬Òò´ËÎÒÃÇ²»Î¬Êý¾ÝÎÄ¼þµÄÏòºó¼æÈÝ¡£ dump
 371    ½«Êý¾Ý°´ÕÕÍ¨ÓÃµÄ¸ñÊ½Êä³ö£¬Ëæºó¿ÉÒÔ±»ÖØÐÂ¼ÓÔØ²¢Ê¹ÓÃÐÂµÄÄÚ²¿¸ñÊ½¡£
 372
 373     3.7)(Ê¹ÓÃPostgreSQL)ÎÒÐèÒªÊ¹ÓÃÊ²Ã´¼ÆËã»úÓ²¼þ £¿
 374
 375    ÓÉÓÚ¼ÆËã»úÓ²¼þ´ó¶àÊýÊÇ¼æÈÝµÄ£¬ÈËÃÇ×ÜÊÇÇãÏòÓÚÏàÐÅËùÓÐ¼ÆËã»úÓ²¼þÖÊÁ¿Ò²ÊÇ
 376    ÏàÍ¬µÄ¡£ÊÂÊµÉÏ²»ÊÇ£¬ ECC RAM£¨´øÆæÅ¼Ð£ÑéµÄÄÚ´æ£©£¬SCSI
 377    £¨Ó²ÅÌ£©ºÍÓÅÖÊµÄÖ÷°å±ÈÒ»Ð©±ãÒË»õÒª¸ü¼Ó¿É¿¿ÇÒ¾ßÓÐ¸üºÃµÄÐÔÄÜ¡£PostgreSQL
 378    ¼¸ºõ¿ÉÒÔÔËÐÐÔÚÈÎºÎÓ²¼þÉÏ£¬
 379    µ«Èç¹û¿É¿¿ÐÔºÍÐÔÄÜ¶ÔÄãµÄÏµÍ³ºÜÖØÒª£¬Äã¾ÍÐèÒªÈ«ÃæµÄÑÐ¾¿Ò»ÏÂÄãµÄÓ²¼þÅäÖÃ
 380    ÁË¡£ÔÚÎÒÃÇµÄÓÊ¼þÁÐ±íÉÏÒ²ÓÐ¹ØÓÚ Ó²¼þÅäÖÃºÍÐÔ¼Û±ÈµÄÌÖÂÛ¡£
 381      _________________________________________________________________
 382
 383 ²Ù×÷ÎÊÌâ
 384
 385     4.1)ÈçºÎÖ»Ñ¡ÔñÒ»¸ö²éÑ¯½á¹ûµÄÍ·¼¸ÐÐ£¿»òÊÇËæ»úµÄÒ»ÐÐ£¿
 386
 387    Èç¹ûÄãÖ»ÊÇÒªÌáÈ¡¼¸ÐÐÊý¾Ý£¬²¢ÇÒÄãÔÚÖ´ÐÐ²éÑ¯ÖÐÖªµÀÈ·ÇÐµÄÐÐÊý£¬Äã¿ÉÒÔÊ¹ÓÃ
 388    LIMIT¹¦ÄÜ¡£ Èç¹ûÓÐÒ»¸öË÷ÒýÓë ORDER BYÖÐµÄÌõ¼þÆ¥Åä£¬PostgreSQL
 389    ¿ÉÄÜ¾ÍÖ»´¦ÀíÒªÇóµÄÍ·¼¸Ìõ¼ÇÂ¼£¬
 390    £¨·ñÔò½«¶ÔÕû¸ö²éÑ¯½øÐÐ´¦ÀíÖ±µ½Éú³ÉÐèÒªµÄÐÐ£©¡£Èç¹ûÔÚÖ´ÐÐ²éÑ¯¹¦ÄÜÊ±²»Öª
 391    µÀÈ·ÇÐµÄ¼ÇÂ¼Êý£¬ ¿ÉÊ¹ÓÃÓÎ±ê(cursor)ºÍFETCH¹¦ÄÜ¡£
 392
 393    ¿ÉÊ¹ÓÃÒÔÏÂ·½·¨ÌáÈ¡Ò»ÐÐËæ»ú¼ÇÂ¼µÄ£º
 394                 SELECT  cols
 395                 FROM tab
 396                 ORDER BY random()
 397                 LIMIT 1 ;
 398
 399     4.2)ÈçºÎ²é¿´±í¡¢Ë÷Òý¡¢Êý¾Ý¿âÒÔ¼°ÓÃ»§µÄ¶¨Òå£¿ÈçºÎ²é¿´psqlÀïÓÃµ½µÄ²éÑ¯Ö¸Áî²¢Ï
 400     ÔÊ¾ËüÃÇ£¿
 401
 402    ÔÚpsqlÖÐÊ¹ÓÃ \dt
 403    ÃüÁîÀ´ÏÔÊ¾Êý¾Ý±íµÄ¶¨Òå£¬ÒªÁË½âpsqlÖÐµÄÍêÕûÃüÁîÁÐ±í¿ÉÊ¹ÓÃ\?
 404    £¬ÁíÍâ£¬ÄãÒ²¿ÉÒÔÔÄ¶Á psql µÄÔ´´úÂë
 405    ÎÄ¼þpgsql/src/bin/psql/describe.c£¬Ëü°üÀ¨ÎªÉú³Épsql·´Ð±¸ÜÃüÁîµÄÊä³öµÄË
 406    ùÓÐ SQL ÃüÁî¡£Äã»¹¿ÉÒÔ´ø -E Ñ¡ÏîÆô¶¯ psql£¬
 407    ÕâÑùËü½«´òÓ¡³öÖ´ÐÐÄãÔÚpsqlÖÐËù¸ø³öµÄÃüÁîµÄÄÚ²¿Êµ¼ÊÊ¹ÓÃµÄSQL²éÑ¯¡£Postg
 408    reSQLÒ²Ìá¹©ÁËÒ»¸ö¼æÈÝSQLµÄINFORMATION SCHEMA½Ó¿Ú£¬
 409    Äã¿ÉÒÔ´ÓÕâÀï»ñÈ¡¹ØÓÚÊý¾Ý¿âµÄÐÅÏ¢¡£
 410
 411    ÔÚÏµÍ³ÖÐÓÐÒ»Ð©ÒÔpg_ ´òÍ·µÄÏµÍ³±íÒ²ÃèÊöÁË±íµÄ¶¨Òå¡£
 412
 413    Ê¹ÓÃ psql -l Ö¸Áî¿ÉÒÔÁÐ³öËùÓÐµÄÊý¾Ý¿â¡£
 414
 415    Ò²¿ÉÒÔä¯ÀÀÒ»ÏÂ
 416    pgsql/src/tutorial/syscat.sourceÎÄ¼þ£¬ËüÁÐ¾ÙÁËºÜ¶à¿É´ÓÊý¾Ý¿âÏµÍ³±íÖÐ»ñ
 417    È¡ÐÅÏ¢µÄSELECTÓï·¨¡£
 418
 419     4.3)ÈçºÎ¸ü¸ÄÒ»¸ö×Ö¶ÎµÄÊý¾ÝÀàÐÍ£¿
 420
 421    ÔÚ8.0°æ±¾Àï¸ü¸ÄÒ»¸ö×Ö¶ÎµÄÊý¾ÝÀàÐÍºÜÈÝÒ×£¬¿ÉÊ¹ÓÃ ALTER TABLE ALTER
 422    COLUMN TYPE ¡£
 423
 424    ÔÚÒÔÇ°µÄ°æ±¾ÖÐ£¬¿ÉÒÔÕâÑù×ö£º
 425         BEGIN;
 426     ALTER TABLE tab ADD COLUMN new_col new_data_type;
 427     UPDATE tab SET new_col = CAST(old_col AS new_data_type);
 428     ALTER TABLE tab DROP COLUMN old_col;
 429     COMMIT;
 430
 431    ÄãÈ»ºó¿ÉÒÔÊ¹ÓÃVACUUM FULL tab Ö¸ÁîÀ´Ê¹ÏµÍ³ÊÕ»ØÎÞÐ§Êý¾ÝËùÕ¼ÓÃµÄ¿Õ¼ä¡£
 432
 433     4.4)Ò»ÐÐ¼ÇÂ¼£¬Ò»¸ö±í£¬Ò»¸ö¿âµÄ×î´ó³ß´çÊÇ¶àÉÙ£¿
 434
 435    ÏÂÃæÊÇÒ»Ð©ÏÞÖÆ£º
 436
 437      Ò»¸öÊý¾Ý¿â×î´ó³ß´ç£¿     ÎÞÏÞÖÆ£¨ÒÑ´æÔÚÓÐ 32TB µÄÊý¾Ý¿â£©
 438      Ò»¸ö±íµÄ×î´ó³ß´ç£¿       32 TB
 439      Ò»ÐÐ¼ÇÂ¼µÄ×î´ó³ß´ç£¿     1.6 TB
 440      Ò»¸ö×Ö¶ÎµÄ×î´ó³ß´ç?      1 GB
 441      Ò»¸ö±íÀï×î´óÐÐÊý£¿       ÎÞÏÞÖÆ
 442      Ò»¸ö±íÀï×î´óÁÐÊý£¿       250-1600 £¨ÓëÁÐÀàÐÍÓÐ¹Ø£©
 443      Ò»¸ö±íÀïµÄ×î´óË÷ÒýÊýÁ¿£¿ ÎÞÏÞÖÆ
 444
 445    µ±È»£¬Êµ¼ÊÉÏÃ»ÓÐÕæÕýµÄÎÞÏÞÖÆ£¬»¹ÊÇÒªÊÜ¿ÉÓÃ´ÅÅÌ¿Õ¼ä¡¢¿ÉÓÃÄÚ´æ/½»»»ÇøµÄÖ
 446    ÆÔ¼¡£ ÊÂÊµÉÏ£¬µ±ÕâÐ©ÊýÖµ±äµÃÒì³£µØ´óÊ±£¬ÏµÍ³ÐÔÄÜÒ²»áÊÜºÜ´óÓ°Ïì¡£
 447
 448    ±íµÄ×î´ó³ß´ç 32 TB ²»ÐèÒª²Ù×÷ÏµÍ³¶Ô´óÎÄ¼þµÄÖ§³Ö¡£´ó±íÓÃ¶à¸ö 1 GB
 449    µÄÎÄ¼þ´æ´¢£¬Òò´ËÎÄ¼þÏµÍ³³ß´çµÄÏÞÖÆÊÇ²»ÖØÒªµÄ¡£
 450
 451    Èç¹ûÈ±Ê¡µÄ¿é´óÐ¡Ôö³¤µ½ 32K £¬×î´óµÄ±í³ß´çºÍ×î´óÁÐÊý»¹¿ÉÒÔÔö¼Óµ½ËÄ±¶¡£
 452
 453     4.5)´æ´¢Ò»¸öµäÐÍµÄÎÄ±¾ÎÄ¼þÀïµÄÊý¾ÝÐèÒª¶àÉÙ´ÅÅÌ¿Õ¼ä£¿
 454
 455    Ò»¸ö Postgres
 456    Êý¾Ý¿â£¨´æ´¢Ò»¸öÎÄ±¾ÎÄ¼þ£©ËùÕ¼ÓÃµÄ¿Õ¼ä×î¶à¿ÉÄÜÐèÒªÏàµ±ÓÚÕâ¸öÎÄ±¾ÎÄ¼þ×Ô
 457    Éí´óÐ¡5±¶µÄ´ÅÅÌ¿Õ¼ä¡£
 458
 459    ÀýÈç£¬¼ÙÉèÓÐÒ»¸ö 100,000 ÐÐµÄÎÄ¼þ£¬Ã¿ÐÐÓÐÒ»¸öÕûÊýºÍÒ»¸öÎÄ±¾ÃèÊö¡£
 460    ¼ÙÉèÎÄ±¾´®µÄÆ½¾ù³¤¶ÈÎª20×Ö½Ú¡£ÎÄ±¾ÎÄ¼þÕ¼ÓÃ 2.8 MB¡£´æ·ÅÕâÐ©Êý¾ÝµÄ
 461    PostgreSQL Êý¾Ý¿âÎÄ¼þ´óÔ¼ÊÇ 6.4 MB:
 462      32 ×Ö½Ú: Ã¿ÐÐµÄÍ·£¨¹À¼ÆÖµ£©
 463      24 ×Ö½Ú: Ò»¸öÕûÊýÐÍ×Ö¶ÎºÍÒ»¸öÎÄ±¾ÐÍ×Ö¶Î
 464    +  4 ×Ö½Ú: Ò³ÃæÄÚÖ¸ÏòÔª×éµÄÖ¸Õë
 465    ----------------------------------------
 466      60 ×Ö½ÚÃ¿ÐÐ
 467
 468    PostgreSQL Êý¾ÝÒ³µÄ´óÐ¡ÊÇ 8192 ×Ö½Ú (8 KB)£¬Ôò£º
 469
 470    8192 ×Ö½ÚÃ¿Ò³
 471    -------------------   =  136 ÐÐ/Êý¾ÝÒ³£¨ÏòÏÂÈ¡Õû£©
 472      60 ×Ö½ÚÃ¿ÐÐ
 473
 474    100000 Êý¾ÝÐÐ
 475    --------------------  =  735 Êý¾ÝÒ³£¨ÏòÉÏÈ¡Õû£©
 476       128 ÐÐÃ¿Ò³
 477
 478    735 Êý¾ÝÒ³ * 8192 ×Ö½Ú/Ò³  =  6,021,120 ×Ö½Ú£¨6 MB£©
 479
 480    Ë÷Òý²»ÐèÒªÕâÃ´¶àµÄ¶îÍâÏûºÄ£¬µ«Ò²È·Êµ°üÀ¨±»Ë÷ÒýµÄÊý¾Ý£¬Òò´ËËüÃÇÒ²¿ÉÄÜºÜ
 481    ´ó¡£
 482
 483    ¿ÕÖµNULL´æ·ÅÔÚÎ»Í¼ÖÐ£¬Òò´ËÕ¼ÓÃºÜÉÙµÄ¿Õ¼ä¡£
 484
 485     4.6)ÎªÊ²Ã´ÎÒµÄ²éÑ¯ºÜÂý£¿ÎªÊ²Ã´ÕâÐ©²éÑ¯Ã»ÓÐÀûÓÃË÷Òý£¿
 486
 487    ²¢·ÇÃ¿¸ö²éÑ¯¶¼»á×Ô¶¯Ê¹ÓÃË÷Òý¡£Ö»ÓÐÔÚ±íµÄ´óÐ¡³¬¹ýÒ»¸ö×îÐ¡Öµ£¬²¢ÇÒ²éÑ¯Ö»
 488    »áÑ¡ÖÐ±íÖÐ½ÏÐ¡±ÈÀýµÄ¼ÇÂ¼Ê±²Å»á²ÉÓÃË÷Òý¡£
 489    ÕâÊÇÒòÎªË÷ÒýÉ¨ÃèÒýÆðµÄËæ¼´´ÅÅÌ´æÈ¡¿ÉÄÜ±ÈÖ±½ÓµØ¶ÁÈ¡±í£¨Ë³ÐòÉ¨Ãè£©¸üÂý¡£
 490
 491    ÎªÁËÅÐ¶ÏÊÇ·ñÊ¹ÓÃË÷Òý£¬PostgreSQL±ØÐë»ñµÃÓÐ¹Ø±íµÄÍ³¼ÆÖµ¡£ÕâÐ©Í³¼ÆÖµ¿ÉÒÔ
 492    Ê¹ÓÃ VACUUM ANALYZE£¬»ò ANALYZE »ñµÃ¡£
 493    Ê¹ÓÃÍ³¼ÆÖµ£¬ÓÅ»¯Æ÷ÖªµÀ±íÖÐÓÐ¶àÉÙÐÐ£¬¾ÍÄÜ¹»¸üºÃµØÅÐ¶ÏÊÇ·ñÀûÓÃË÷Òý¡£
 494    Í³¼ÆÖµ¶ÔÈ·¶¨ÓÅ»¯µÄÁ¬½ÓË³ÐòºÍÁ¬½Ó·½·¨Ò²ºÜÓÐÓÃ¡£ÔÚ±íµÄÄÚÈÝ·¢Éú±ä»¯Ê±£¬Ó¦
 495    ¶¨ÆÚ½øÐÐÍ³¼ÆÖµµÄ¸üÐÂÊÕ¼¯¡£
 496
 497    Ë÷ÒýÍ¨³£²»ÓÃÓÚ ORDER BY
 498    »òÖ´ÐÐÁ¬½Ó¡£¶ÔÒ»¸ö´ó±íµÄÒ»´ÎË³ÐòÉ¨Ãè£¬ÔÙ×öÒ»¸öÏÔÊ½µÄÅÅÐòÍ¨³£±ÈË÷ÒýÉ¨Ãè
 499    Òª¿ì¡£
 500
 501    µ«ÊÇ£¬ÔÚ LIMIT ºÍ ORDER BY ½áºÏÊ¹ÓÃÊ±¾
 502    ³£»áÊ¹ÓÃË÷Òý£¬ÒòÎªÕâÖ»»á·µ»Ø±íµÄÒ»Ð¡²¿·Ö¡£ Êµ¼ÊÉÏ£¬ËäÈ» MAX() ºÍ MIN()
 503    ²¢²»Ê¹ÓÃË÷Òý£¬Í¨¹ý¶Ô ORDER BY ºÍ LLIMIT
 504    Ê¹ÓÃË÷ÒýÈ¡µÃ×î´óÖµºÍ×îÐ¡ÖµÒ²ÊÇ¿ÉÒÔµÄ£º
 505         SELECT col
 506         FROM tab
 507         ORDER BY col [ DESC ]
 508         LIMIT 1;
 509
 510    Èç¹ûÄãÈ·ÐÅPostgreSQLµÄÓÅ»¯Æ÷Ê¹ÓÃË³ÐòÉ¨ÃèÊÇ²»ÕýÈ·µÄ£¬Äã¿ÉÒÔÊ¹ÓÃSET
 511    enable_seqscan TO 'off'Ö¸Áî£¬
 512    È»ºóÔÙ´ÎÔËÐÐ²éÑ¯£¬Äã¾Í¿ÉÒÔ¿´³öÊ¹ÓÃÒ»¸öË÷ÒýÉ¨ÃèÊÇ·ñÈ·ÊµÒª¿ìÒ»Ð©¡£
 513
 514    µ±Ê¹ÓÃÍ¨Åä·û²Ù×÷£¬ÀýÈç LIKE »ò ~ Ê±£¬Ë÷ÒýÖ»ÄÜÔÚÌØ¶¨µÄÇé¿öÏÂÊ¹ÓÃ£º
 515      * ×Ö·û´®µÄ¿ªÊ¼²¿·Ö±ØÐëÊÇÆÕÍ¨×Ö·û´®£¬Ò²¾ÍÊÇËµ£º
 516           + LIKE Ä£Ê½²»ÄÜÒÔ % ´òÍ·¡£
 517           + ~ £¨ÕýÔò±í´ïÊ½£©Ä£Ê½±ØÐëÒÔ ^ ´òÍ·¡£
 518      * ×Ö·û´®²»ÄÜÒÔÆ¥Åä¶à¸ö×Ö·ûµÄÄ£Ê½Àà´òÍ·£¬ÀýÈç [a-e]¡£
 519      * ´óÐ¡Ð´ÎÞ¹ØµÄ²éÕÒ£¬Èç ILIKE ºÍ ~* µÈ²»Ê¹ÓÃË÷Òý£¬µ«¿ÉÒÔÓÃ 4.8
 520        ½ÚÃèÊöµÄº¯ÊýË÷Òý¡£
 521      * ÔÚ×ö initdb Ê±±ØÐë²ÉÓÃÈ±Ê¡µÄ±¾µØÉèÖÃ C
 522        locale£¬ÒòÎªÏµÍ³²»¿ÉÄÜÖªµÀÔÚ·ÇC localeÇé¿öÊ±ÏÂÒ»¸ö×î´ó×Ö·ûÊÇÊ²Ã´¡£
 523        ÔÚÕâÖÖÇé¿öÏÂ£¬Äã¿ÉÒÔ´´½¨Ò»¸öÌØÊâµÄtext_pattern_opsË÷ÒýÀ´ÓÃÓÚLIKEµÄ
 524        Ë÷Òý¡£
 525
 526    ÔÚ8.0Ö®Ç°µÄ°æ±¾ÖÐ£¬³ý·ÇÒª²éÑ¯µÄÊý¾ÝÀàÐÍºÍË÷ÒýµÄÊý¾ÝÀàÐÍÏàÆ¥Åä£¬·ñÔòË÷Ò
 527    ý¾³£ÊÇÎ´±»ÓÃµ½£¬ÌØ±ðÊÇ¶Ôint2,int8ºÍÊýÖµÐÍµÄË÷Òý¡£
 528
 529     4.7)ÎÒÈçºÎ²ÅÄÜ¿´µ½²éÑ¯ÓÅ»¯Æ÷ÊÇÔõÑùÆÀ¹À´¦ÀíÎÒµÄ²éÑ¯£¿
 530
 531    ²Î¿¼ EXPLAIN ÊÖ²áÒ³¡£
 532
 533     4.8)ÎÒÔõÑù×öÕýÔò±í´ïÊ½ËÑË÷ºÍ´óÐ¡Ð´ÎÞ¹ØµÄÕýÔò±í´ïÊ½²éÕÒ£¿ÔõÑùÀûÓÃË÷Òý½øÐÐ´óÐ
 534     ¡Ð´ÎÞ¹Ø²éÕÒ£¿
 535
 536    ²Ù×÷·û ~ ´¦ÀíÕýÔò±í´ïÊ½Æ¥Åä£¬¶ø ~*
 537    ´¦Àí´óÐ¡Ð´ÎÞ¹ØµÄÕýÔò±í´ïÊ½Æ¥Åä¡£´óÐ´Ð©ÎÞ¹ØµÄ LIKE ±äÖÖ³ÉÎª ILIKE¡£
 538
 539    ´óÐ¡Ð´ÎÞ¹ØµÄµÈÊ½±È½ÏÍ¨³£Ð´×ö£º
 540     SELECT *
 541     FROM tab
 542     WHERE lower(col) = 'abc';
 543
 544    ÕâÑù½«²»»áÊ¹ÓÃ±ê×¼µÄË÷Òý¡£µ«ÊÇ¿ÉÒÔ´´½¨Ò»¸ö¿É±»ÀûÓÃµÄº¯ÊýË÷Òý:
 545     CREATE INDEX tabindex ON tab (lower(col));
 546
 547     4.9)ÔÚÒ»¸ö²éÑ¯Àï£¬ÎÒÔõÑù¼ì²âÒ»¸ö×Ö¶ÎÊÇ·ñÎª NULL
 548     £¿ÎÒÈçºÎ²ÅÄÜ×¼È·ÅÅÐò¶ø²»ÂÛÄ³×Ö¶ÎÊÇ·ñº¬ NULL Öµ£¿
 549
 550    ÓÃ IS NULL ºÍ IS NOT NULL ²âÊÔÕâ¸ö×Ö¶Î£¬¾ßÌå·½·¨ÈçÏÂ£º
 551    SELECT *
 552    FROM tab
 553    WHERE col IS NULL;
 554
 555    ÎªÁËÄÜ¶Ôº¬ NULL×Ö¶ÎÅÅÐò£¬¿ÉÔÚ ORDER BY Ìõ¼þÖÐÊ¹ÓÃ IS NULLºÍ IS NOT
 556    NULL ÐÞÊÎ·û£¬Ìõ¼þÎªÕæ true ½«±ÈÌõ¼þÎª¼Ùfalse
 557    ÅÅÔÚÇ°Ãæ£¬ÏÂÃæµÄÀý×Ó¾Í»á½«º¬ NULL µÄ¼ÇÂ¼ÅÅÔÚ½á¹ûµÄÉÏÃæ²¿·Ö£º
 558    SELECT *
 559    FROM tab
 560    ORDER BY (col IS NOT NULL)
 561
 562     4.10)¸÷ÖÖ×Ö·ûÀàÐÍÖ®¼äÓÐÊ²Ã´²»Í¬£¿
 563
 564         ÀàÐÍ    ÄÚ²¿Ãû³Æ                      ËµÃ÷
 565      VARCHAR(n) varchar
 566    Ö¸¶¨ÁË×î´ó³¤¶È£¬±ä³¤×Ö·û´®£¬²»×ã¶¨Òå³¤¶ÈµÄ²¿·Ö²»²¹Æë
 567      CHAR(n)    bpchar   ¶¨³¤×Ö·û´®£¬Êµ¼ÊÊý¾Ý²»×ã¶¨Òå³¤¶ÈÊ±£¬ÒÔ¿Õ¸ñ²¹Æë
 568      TEXT       text     Ã»ÓÐÌØ±ðµÄÉÏÏÞÏÞÖÆ£¨½öÊÜÐÐµÄ×î´ó³¤¶ÈÏÞÖÆ£©
 569      BYTEA      bytea    ±ä³¤×Ö½ÚÐòÁÐ£¨Ê¹ÓÃNULLÒ²ÊÇÔÊÐíµÄ£©
 570      "char"     char     Ò»¸ö×Ö·û
 571
 572    ÔÚÏµÍ³±íºÍÔÚÒ»Ð©´íÎóÐÅÏ¢ÀïÄã½«¿´µ½ÄÚ²¿Ãû³Æ¡£
 573
 574    ÉÏÃæËùÁÐµÄÇ°ËÄÖÖÀàÐÍÊÇ"varlena"£¨±ä³¤£©ÀàÐÍ£¨Ò²¾ÍÊÇËµ£¬¿ªÍ·µÄËÄ¸ö×Ö½ÚÊ
 575    Ç³¤¶È£¬ºóÃæ²ÅÊÇÊý¾Ý£©¡£ ÓÚÊÇÊµ¼ÊÕ¼ÓÃµÄ¿Õ¼ä±ÈÉùÃ÷µÄ´óÐ¡Òª¶àÒ»Ð©¡£
 576    È»¶øÕâÐ©ÀàÐÍ¶¼¿ÉÒÔ±»Ñ¹Ëõ´æ´¢£¬Ò²¿ÉÒÔÓÃ TOAST
 577    ÍÑ»ú´æ´¢£¬Òò´Ë´ÅÅÌ¿Õ¼äÒ²¿ÉÄÜ±ÈÔ¤ÏëµÄÒªÉÙ¡£
 578
 579    VARCHAR(n) ÔÚ´æ´¢ÏÞÖÆÁË×î´ó³¤¶ÈµÄ±ä³¤×Ö·û´®ÊÇ×îºÃµÄ¡£ TEXT
 580    ÊÊÓÃÓÚ´æ´¢×î´ó¿É´ï 1G×óÓÒµ«Î´¶¨ÒåÏÞÖÆ³¤¶ÈµÄ×Ö·û´®¡£
 581
 582    CHAR(n) ×îÊÊºÏÓÚ´æ´¢³¤¶ÈÏàÍ¬µÄ×Ö·û´®¡£
 583    CHAR(n)»á¸ù¾ÝËù¸ø¶¨µÄ×Ö¶Î³¤¶ÈÒÔ¿Õ¸ñ²¹×ã£¨²»×ãµÄ×Ö¶ÎÄÚÈÝ£©£¬ ¶ø
 584    VARCHAR(n) Ö»´æ´¢Ëù¸ø¶¨µÄÊý¾ÝÄÚÈÝ¡£ BYTEA
 585    ÓÃÓÚ´æ´¢¶þ½øÖÆÊý¾Ý£¬ÓÈÆäÊÇ°üº¬ NULL
 586    ×Ö½ÚµÄÖµ¡£ÕâÐ©ÀàÐÍ¾ßÓÐÏàËÆµÄÐÔÄÜÌØÐÔ¡£
 587
 588     4.11.1)ÎÒÔõÑù´´½¨Ò»¸öÐòÁÐºÅ/×Ô¶¯µÝÔöµÄ×Ö¶Î£¿
 589
 590    PostgreSQL Ö§³Ö SERIAL
 591    Êý¾ÝÀàÐÍ¡£ËüÔÚ×Ö¶ÎÉÏ×Ô¶¯´´½¨Ò»¸öÐòÁÐºÍË÷Òý¡£ÀýÈç£º
 592         CREATE TABLE person (
 593                 id   SERIAL,
 594                 name TEXT
 595         );
 596
 597    »á×Ô¶¯×ª»»Îª£º
 598         CREATE SEQUENCE person_id_seq;
 599         CREATE TABLE person (
 600                 id   INT4 NOT NULL DEFAULT nextval('person_id_seq'),
 601                 name TEXT
 602         );
 603
 604    ²Î¿¼ create_sequence ÊÖ²áÒ³»ñÈ¡¹ØÓÚÐòÁÐµÄ¸ü¶àÐÅÏ¢¡£
 605
 606     4.11.2)ÎÒÈçºÎ»ñµÃÒ»¸ö²åÈëµÄÐòÁÐºÅµÄÖµ£¿
 607
 608    Ò»ÖÖ·½·¨ÊÇÔÚ²åÈëÖ®Ç°ÏÈÓÃº¯Êý nextval() ´ÓÐòÁÐ¶ÔÏóÀï¼ìË÷³öÏÂÒ»¸ö SERIAL
 609    Öµ£¬È»ºóÔÙÏÔÊ½²åÈë¡£Ê¹ÓÃ 4.11.1 ÀïµÄÀý±í£¬¿ÉÓÃÎ±ÂëÕâÑùÃèÊö£º
 610         new_id = execute("SELECT nextval('person_id_seq')");
 611         execute("INSERT INTO person (id, name) VALUES (new_id, 'Blaise Pascal')");
 612
 613    ÕâÑù»¹ÄÜÔÚÆäËû²éÑ¯ÖÐÊ¹ÓÃ´æ·ÅÔÚ new_id ÀïµÄÐÂÖµ£¨ÀýÈç£¬×÷Îª person
 614    ±íµÄÍâ¼ü£©¡£ ×¢Òâ×Ô¶¯´´½¨µÄ SEQUENCE ¶ÔÏóµÄÃû³Æ½«»áÊÇ
 615    <table>_<serialcolumn>_seq£¬ ÕâÀï table ºÍ serialcolumn
 616    ·Ö±ðÊÇÄãµÄ±íµÄÃû³ÆºÍÄãµÄ SERIAL ×Ö¶ÎµÄÃû³Æ¡£
 617
 618    ÀàËÆµÄ£¬ÔÚ SERIAL ¶ÔÏóÈ±Ê¡²åÈëºóÄã¿ÉÒÔÓÃº¯Êý currval() ¼ìË÷¸Õ¸³ÖµµÄ
 619    SERIAL Öµ£¬ÀýÈç£º
 620         execute("INSERT INTO person (name) VALUES ('Blaise Pascal')");
 621         new_id = execute("SELECT currval('person_id_seq')");
 622
 623     4.11.3)Ê¹ÓÃ currval() »áµ¼ÖÂºÍÆäËûÓÃ»§µÄ³åÍ»Çé¿ö£¨race condition£©Âð£¿
 624
 625    ²»»á¡£currval() ·µ»ØµÄÊÇÄã±¾´Î»á»°½ø³ÌËù¸³µÄÖµ¶ø²»ÊÇËùÓÐÓÃ»§µÄµ±Ç°Öµ¡£
 626
 627     4.11.4)ÎªÊ²Ã´²»ÔÚÊÂÎñÒì³£ÖÐÖ¹ºóÖØÓÃÐòÁÐºÅÄØ£¿ÎªÊ²Ã´ÔÚÐòÁÐºÅ×Ö¶ÎµÄÈ¡ÖµÖÐ´æÔÚ
 628     ¼ä¶ÏÄØ£¿
 629
 630    ÎªÁËÌá¸ß²¢·¢ÐÔ£¬ÐòÁÐºÅÔÚÐèÒªµÄÊ±ºò¸³ÓèÕýÔÚÔËÐÐµÄÊÂÎñ£¬²¢ÇÒÔÚÊÂÎñ½áÊøÖ®
 631    Ç°²»½øÐÐËø¶¨£¬ Õâ¾Í»áµ¼ÖÂÒì³£ÖÐÖ¹µÄÊÂÎñºó£¬ÐòÁÐºÅ»á³öÏÖ¼ä¸ô¡£
 632
 633     4.12)Ê²Ã´ÊÇ OID £¿Ê²Ã´ÊÇ CTID £¿
 634
 635    PostgreSQL
 636    Àï´´½¨µÄÃ¿Ò»ÐÐ¼ÇÂ¼¶¼»á»ñµÃÒ»¸öÎ¨Ò»µÄOID£¬³ý·ÇÔÚ´´½¨±íÊ±Ê¹ÓÃWITHOUT
 637    OIDSÑ¡Ïî¡£ OID´´½¨Ê±»á×Ô¶¯Éú³ÉÒ»¸ö4×Ö½ÚµÄÕûÊý£¬ËùÓÐ OID ÔÚÕû¸ö
 638    PostgreSQL ÖÐ¾ùÊÇÎ¨Ò»µÄ¡£ È»¶ø£¬ËüÔÚ³¬¹ý40ÒÚÊ±½«Òç³ö£¬
 639    OID´Ëºó»á³öÏÖÖØ¸´¡£PostgreSQL ÔÚËüµÄÄÚ²¿ÏµÍ³±íÀïÊ¹ÓÃ OID
 640    ÔÚ±íÖ®¼ä½¨Á¢ÁªÏµ¡£
 641
 642    ÔÚÓÃ»§µÄÊý¾Ý±íÖÐ£¬×îºÃÊÇÊ¹ÓÃSERIAlÀ´´úÌæOID
 643    ÒòÎªSERIALÖ»ÊÇ±£Ö¤ÔÚµ¥¸ö±íÖÐÊý¾ÝÊÇÎ¨Ò»µÄ£¬ÕâÑùËüÒç³öµÄ¿ÉÄÜÐÔ¾Í·Ç³£Ð¡ÁË
 644    £¬ SERIAL8¿ÉÓÃÀ´±£´æ8×Ö½ÚµÄÐòÁÐºÅ×Ö¶Î¡£
 645
 646    CTID ÓÃÓÚ±êÊ¶´ø×ÅÊý¾Ý¿é£¨µØÖ·£©ºÍ£¨¿éÄÚ£©Æ«ÒÆµÄÌØ¶¨µÄÎïÀíÐÐ¡£ CTID
 647    ÔÚ¼ÇÂ¼±»¸ü¸Ä»òÖØÔØºó·¢Éú¸Ä±ä¡£Ë÷ÒýÈë¿ÚÊ¹ÓÃËüÃÇÖ¸ÏòÎïÀíÐÐ¡£
 648
 649     4.13)ÎªÊ²Ã´ÎÒÊÕµ½´íÎóÐÅÏ¢¡°ERROR: Memory exhausted in AllocSetAlloc()¡±£¿
 650
 651    ÕâºÜ¿ÉÄÜÊÇÏµÍ³µÄÐéÄâÄÚ´æÓÃ¹âÁË£¬»òÕßÄÚºË¶ÔÄ³Ð©×ÊÔ´ÓÐ½ÏµÍµÄÏÞÖÆÖµ¡£ÔÚÆô
 652    ¶¯ postmaster Ö®Ç°ÊÔÊÔÏÂÃæµÄÃüÁî£º
 653         ulimit -d 262144
 654         limit datasize 256m
 655
 656    È¡¾öÓÚÄãÓÃµÄ
 657    shell£¬ÉÏÃæÃüÁîÖ»ÓÐÒ»ÌõÄÜ³É¹¦£¬µ«ÊÇËü½«°ÑÄãµÄ½ø³ÌÊý¾Ý¶ÎÏÞÖÆÉèµÃ±È½Ï¸ß£
 658    ¬
 659    Òò¶øÒ²ÐíÄÜÈÃ²éÑ¯Íê³É¡£ÕâÌõÃüÁîÓ¦ÓÃÓÚµ±Ç°½ø³Ì£¬ÒÔ¼°ËùÓÐÔÚÕâÌõÃüÁîÔËÐÐºó
 660    ´´½¨µÄ×Ó½ø³Ì¡£
 661    Èç¹ûÄãÊÇÔÚÔËÐÐSQL¿Í»§¶ËÊ±ÒòÎªºóÌ¨·µ»ØÁËÌ«¶àµÄÊý¾Ý¶ø³öÏÖÎÊÌâ£¬ÇëÔÚÔËÐÐ¿
 662    Í»§¶ËÖ®Ç°Ö´ÐÐÉÏÊöÃüÁî¡£
 663
 664     4.14)ÎÒÈçºÎ²ÅÄÜÖªµÀËùÔËÐÐµÄ PostgreSQL µÄ°æ±¾£¿
 665
 666    ´Ó psql Àï£¬ÊäÈë SELECT version();Ö¸Áî¡£
 667
 668     4.15)ÎÒÈçºÎ´´½¨Ò»¸öÈ±Ê¡ÖµÊÇµ±Ç°Ê±¼äµÄ×Ö¶Î£¿
 669
 670    Ê¹ÓÃ CURRENT_TIMESTAMP£º
 671         CREATE TABLE test (x int, modtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
 672
 673     4.16)ÎÒÔõÑù½øÐÐ outer join £¨ÍâÁ¬½Ó£©£¿
 674
 675    PostgreSQL ²ÉÓÃ±ê×¼µÄ SQL Óï·¨Ö§³ÖÍâÁ¬½Ó¡£ÕâÀïÊÇÁ½¸öÀý×Ó£º
 676         SELECT *
 677         FROM t1 LEFT OUTER JOIN t2 ON (t1.col = t2.col);
 678
 679    »òÊÇ
 680         SELECT *
 681         FROM t1 LEFT OUTER JOIN t2 USING (col);
 682
 683    ÕâÁ½¸öµÈ¼ÛµÄ²éÑ¯ÔÚ t1.col ºÍ t2.col ÉÏ×öÁ¬½Ó£¬²¢ÇÒ·µ»Ø t1
 684    ÖÐËùÓÐÎ´Á¬½ÓµÄÐÐ£¨ÄÇÐ©ÔÚ t2 ÖÐÃ»ÓÐÆ¥ÅäµÄÐÐ£©¡£ ÓÒ[Íâ]Á¬½Ó(RIGHT OUTER
 685    JOIN)½«·µ»Ø t2 ÖÐÎ´Á¬½ÓµÄÐÐ¡£ ÍêÈ«ÍâÁ¬½Ó£¨FULL OUTER JOIN£©½«·µ»Ø t1
 686    ºÍ t2 ÖÐÎ´Á¬½ÓµÄÐÐ¡£ ¹Ø¼ü×Ö OUTER
 687    ÔÚ×ó[Íâ]Á¬½Ó¡¢ÓÒ[Íâ]Á¬½ÓºÍÍêÈ«[Íâ]Á¬½ÓÖÐÊÇ¿ÉÑ¡µÄ£¬ÆÕÍ¨Á¬½Ó±»³ÆÎªÄÚÁ¬½Ó
 688    £¨INNER JOIN£©¡£
 689
 690     4.17)ÈçºÎÊ¹ÓÃÉæ¼°¶à¸öÊý¾Ý¿âµÄ²éÑ¯£¿
 691
 692    Ã»ÓÐ°ì·¨²éÑ¯µ±Ç°Êý¾Ý¿âÖ®ÍâµÄÊý¾Ý¿â¡£ ÒòÎª PostgreSQL
 693    Òª¼ÓÔØÓëÊý¾Ý¿âÏà¹ØµÄÏµÍ³Ä¿Â¼£¨ÏµÍ³±í£©£¬Òò´Ë¿çÊý¾Ý¿âµÄ²éÑ¯ÈçºÎÖ´ÐÐÊÇ²»
 694    ¶¨µÄ¡£
 695
 696    ¸½¼ÓÔöÖµÄ£¿écontrib/dblinkÔÊÐí²ÉÓÃº¯Êýµ÷ÓÃÊµÏÖ¿ç¿â²éÑ¯¡£µ±È»ÓÃ»§Ò²¿ÉÒÔ
 697    Í¬Ê±Á¬½Óµ½²»Í¬µÄÊý¾Ý¿âÖ´ÐÐ²éÑ¯È»ºóÔÚ¿Í»§¶ËºÏ²¢½á¹û¡£
 698
 699     4.18)ÈçºÎÈÃº¯Êý·µ»Ø¶àÐÐ»ò¶àÁÐ£¿
 700
 701    ÔÚº¯ÊýÖÐ·µ»ØÊý¾Ý¼ÇÂ¼¼¯µÄ¹¦ÄÜÊÇºÜÈÝÒ×Ê¹ÓÃµÄ£¬ÏêÇé²Î¼û£º
 702    http://techdocs.postgresql.org/guides/SetReturningFunctions
 703
 704     4.19)ÎªÊ²Ã´ÎÒÔÚÊ¹ÓÃPL/PgSQLº¯Êý´æÈ¡ÁÙÊ±±íÊ±»áÊÕµ½´íÎóÐÅÏ¢¡°relation with
 705     OID ##### does not exist¡±£¿
 706
 707    PL/PgSQL»á»º´æº¯ÊýµÄÄÚÈÝ£¬ÓÉ´Ë´øÀ´µÄÒ»¸ö²»ºÃµÄ¸±×÷ÓÃÊÇÈôÒ»¸ö PL/PgSQL
 708    º¯Êý·ÃÎÊÁËÒ»¸öÁÙÊ±±í£¬È»ºó¸Ã±í±»É¾³ý²¢ÖØ½¨ÁË£¬ÔòÔÙ´Îµ÷ÓÃ¸Ãº¯Êý½«Ê§°Ü£¬
 709    ÒòÎª»º´æµÄº¯ÊýÄÚÈÝÈÔÈ»Ö¸Ïò¾ÉµÄÁÙÊ±±í¡£½â¾öµÄ·½·¨ÊÇÔÚ PL/PgSQL
 710    ÖÐÓÃEXECUTE ¶ÔÁÙÊ±±í½øÐÐ·ÃÎÊ¡£ÕâÑù»á±£Ö¤²éÑ¯ÔÚÖ´ÐÐÇ°×Ü»á±»ÖØÐÂ½âÎö¡£
 711
 712     4.27)Ä¿Ç°ÓÐÄÄÐ©Êý¾Ý¸´ÖÆ·½°¸¿ÉÓÃ£¿
 713
 714    ¡°¸´ÖÆ¡±Ö»ÊÇÒ»¸öÊõÓï£¬ÓÐºÃ¼¸ÖÖ¸´ÖÆ¼¼Êõ¿ÉÊ¹ÓÃ£¬Ã¿ÖÖ¶¼ÓÐÓÅµãºÍÈ±µã£º
 715
 716    Ö÷/´Ó¸´ÖÆ·½Ê½ÊÇÔÊÐíÒ»¸öÖ÷·þÎñÆ÷½ÓÊÜ¶Á/Ð´µÄÉêÇë£¬¶ø¶à¸ö´Ó·þÎñÆ÷Ö»ÄÜ½ÓÊÜ
 717    ¶Á/SELECT²éÑ¯µÄÉêÇë£¬ Ä¿Ç°×îÁ÷ÐÐÇÒÊÇÃâ·ÑµÄÖ÷/´Ó PostgreSQL¸´ÖÆ·½°¸ÊÇ
 718    Slony-I ¡£
 719
 720    ¶à¸öÖ÷·þÎñÆ÷µÄ¸´ÖÆ·½Ê½ÔÊÐí½«¶Á/Ð´µÄÉêÇë·¢ËÍ¸ø¶àÌ¨µÄ¼ÆËã»ú£¬ÕâÖÖ·½Ê½ÓÉÓ
 721    ÚÐèÒªÔÚ¶àÌ¨·þÎñÆ÷Ö®¼äÍ¬²½Êý¾Ý±ä¶¯
 722    ¿ÉÄÜ»á´øÀ´½ÏÑÏÖØµÄÐÔÄÜËðÊ§£¬PgclusterÊÇÄ¿Ç°ÕâÖÖ·½°¸
 723    ÖÐ×îºÃµÄ£¬¶øÇÒ»¹¿ÉÒÔÃâ·ÑÏÂÔØ¡£
 724
 725    Ò²ÓÐÒ»Ð©ÉÌÒµÐè¸¶·ÑºÍ»ùÓÚÓ²¼þµÄÊý¾Ý¸´ÖÆ·½°¸£¬Ö§³ÖÉÏÊö¸÷ÖÖ¸´ÖÆÄ£ÐÍ¡£