contrib/pgrowlocks/README.pgrowlocks.euc_jp

   1 $PostgreSQL$
   2
   3 pgrowlocks README               ÀÐ°æÃ£É×
   4
   5 1. pgrowlocks¤È¤Ï
   6
   7    pgrowlocks¤Ï¡¤»ØÄê¤µ¤ì¤¿¥Æ¡¼¥Ö¥ë¤Î¹Ô¥í¥Ã¥¯¤Ë´Ø¤¹¤ë¾ðÊó¤òÉ½¼¨¤·¤Þ¤¹¡¥
   8
   9    pgrowlocks¤ÎÊÖ¤¹·¿¤Ï¡¤°Ê²¼¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡¥
  10
  11 CREATE TYPE pgrowlocks_type AS (
  12         locked_row TID,         -- row TID
  13         lock_type TEXT,         -- lock type
  14         locker XID,             -- locking XID
  15         multi bool,             -- multi XID?
  16         xids xid[],             -- multi XIDs
  17         pids INTEGER[]          -- locker's process id
  18 );
  19
  20   ¼Â¹ÔÎã¤ò¼¨¤·¤Þ¤¹¡¥
  21
  22 test=# SELECT * FROM pgrowlocks('t1');
  23  locked_row | lock_type | locker | multi |   xids    |     pids
  24 ------------+-----------+--------+-------+-----------+---------------
  25       (0,1) | Shared    |     19 | t     | {804,805} | {29066,29068}
  26       (0,2) | Shared    |     19 | t     | {804,805} | {29066,29068}
  27       (0,3) | Exclusive |    804 | f     | {804}     | {29066}
  28       (0,4) | Exclusive |    804 | f     | {804}     | {29066}
  29 (4 rows)
  30
  31   ³Æ¹àÌÜ¤ÎÀâÌÀ¤Ç¤¹¡¥
  32
  33   locked_row            -- ¥í¥Ã¥¯¤µ¤ì¤¿¹Ô¤Î¥¿¥×¥ëID(TID)
  34   lock_type             -- ¶¦Í¥í¥Ã¥¯¤Ê¤é"Shared"¡¤ÇÓÂ¾¥í¥Ã¥¯¤Ê¤é"Exclusive"
  35   locker                -- ¥í¥Ã¥¯¤ò¤«¤±¤Æ¤¤¤ë¥È¥é¥ó¥¶¥¯¥·¥ç¥óID[Ãí1]
  36   multi                 -- locker¤¬¥Þ¥ë¥Á¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤Ê¤ét¤½¤¦¤Ç¤Ê¤±¤ì¤Ðf
  37   xids                  -- ¥í¥Ã¥¯¤ò¤«¤±¤Æ¤¤¤ë¥È¥é¥ó¥¶¥¯¥·¥ç¥óID[Ãí2]
  38   pids                  -- ¥í¥Ã¥¯¤ò¤«¤±¤Æ¤¤¤ë¥Ð¥Ã¥¯¥¨¥ó¥É¥×¥í¥»¥¹¤Î¥×¥í¥»¥¹ID[Ãí2]
  39
  40   [Ãí1: locker¤¬¥Þ¥ë¥Á¤Ê¤é¡¤¥È¥é¥ó¥¶¥¯¥·¥ç¥óID¤Ç¤Ï¤Ê¤¯¤Æ¥Þ¥ë¥ÁID¤Ë¤Ê¤ê
  41   ¤Þ¤¹¡¥]
  42
  43   [Ãí2: locker¤¬¥Þ¥ë¥Á¤Î¾ì¹ç¡¤Ê£¿ô¤Î¥Ç¡¼¥¿¤¬É½¼¨¤µ¤ì¤Þ¤¹¡¥]
  44
  45 2. pgrowlocks¤Î¥¤¥ó¥¹¥È¡¼¥ë
  46
  47    pgrowlocks¤Î¥¤¥ó¥¹¥È¡¼¥ë¤Ë¤Ï¡¤PostgreSQL¤ò¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿¤È¤¤Î¥½¡¼
  48    ¥¹¥Ä¥ê¡¼¤¬É¬Í×¤Ç¤¹¡¥º£¤Î¤È¤³¤íÂÐ±þ¤·¤Æ¤¤¤ë¥Ð¡¼¥¸¥ç¥ó¤ÏPostgreSQL
  49    8.0°Ê¹ß¤Ç¤¹¡¥
  50
  51    ¤³¤³¤Ç¤ÏPostgreSQL¤Î¥½¡¼¥¹¤Ï/usr/local/src/postgresql-8.1/¤ËÅ¸³«¤µ
  52    ¤ì¤Æ¤¤¤ë¤â¤Î¤È¤·¤Þ¤¹¡¥
  53
  54    1) pgrowlocks¤Î¥½¡¼¥¹¤òÅ¸³«¤·¤Þ¤¹¡¥¥½¡¼¥¹¥Õ¥¡¥¤¥ë¤Ï
  55       /tmp/pgrowlocks-1.0.tar.gz¤ËÃÖ¤¤¤Æ¤¢¤ë¤â¤Î¤È¤·¤Þ¤¹¡¥
  56
  57       $ cd /usr/local/src/postgresql-8.1/contrib
  58       $ tar xfz pgrowlocks-1.0.tar.gz
  59
  60    2) PostgreSQL 8.0¤Î¾ì¹ç¤Ï¡¤¥½¡¼¥¹¤Î°ìÉô¤Ë½¤Àµ¤¬É¬Í×¤Ç¤¹¡¥
  61       pgrowlocks.c¤Î61¹ÔÌÜÊÕ¤ê¤Ë
  62
  63       #undef MAKERANGEVARFROMNAMELIST_HAS_TWO_ARGS
  64
  65       ¤È¤¤¤¦¤Î¤¬¤¢¤ë¤Î¤Ç¡¤¤³¤ì¤ò
  66
  67       #define MAKERANGEVARFROMNAMELIST_HAS_TWO_ARGS
  68
  69       ¤Ë½ñ¤´¹¤¨¤Þ¤¹(undef->define¤Ë¤·¤Þ¤¹)¡¥
  70
  71    3) ¥³¥ó¥Ñ¥¤¥ë¤·¤Æ´Ø¿ô¤Î¶¦Í¥é¥¤¥Ö¥é¥ê¤ò¥¤¥ó¥¹¥È¡¼¥ë¤·¤Þ¤¹¡¥
  72
  73       $ make
  74       $ make install
  75
  76    4) ¥æ¡¼¥¶ÄêµÁ´Ø¿ô¤òÅÐÏ¿¤·¤Þ¤¹¡¥
  77
  78       $ psql -e -f /usr/local/pgsql/share/contrib/pgrowlocks.sql test
  79
  80       ¤³¤ÎÎã¤Ç¤Ï"test"¤È¤¤¤¦¥Ç¡¼¥¿¥Ù¡¼¥¹¤ËÅÐÏ¿¤·¤Æ¤¤¤Þ¤¹¤¬¡¤¤â¤·Â¾¤Î¥Ç¡¼
  81       ¥¿¥Ù¡¼¥¹¤ËÅÐÏ¿¤¹¤ë¾ì¹ç¤Ï¤³¤³¤òÆÉ¤ßÂØ¤¨¤Æ¤¯¤À¤µ¤¤¡¥
  82
  83 3. pgrowlocks¤Î»È¤¤Êý
  84
  85    pgrowlocks¤Î¸Æ¤Ó½Ð¤··Á¼°¤Ï°Ê²¼¤Ç¤¹¡¥
  86
  87    CREATE OR REPLACE FUNCTION pgrowlocks(text) RETURNS pgrowlocks_type
  88      AS 'MODULE_PATHNAME', 'pgrowlocks'
  89      LANGUAGE 'c' WITH (isstrict);
  90
  91    Âè°ì°ú¿ô: ¥Æ¡¼¥Ö¥ëÌ¾
  92
  93    ´Ø¿ô¤ÎÌá¤ê¤Ïpgrowlocks_type·¿¤Ç¤¹¡¥
  94
  95    pgrowlocks¤Ï¥Æ¡¼¥Ö¥ë¤ËAccessShareLock¥í¥Ã¥¯¤ò¤«¤±¡¤1¹Ô¤º¤ÄÆÉ¤ß½Ð¤·
  96    ¤Æ¤Ï¹Ô¥í¥Ã¥¯¤¬¤«¤«¤Ã¤Æ¤¤¤ë¤«¤É¤¦¤«¥Á¥§¥Ã¥¯¤·¤Þ¤¹¡¥°Ê²¼¤ÎÅÀ¤ËÃí°Õ¤·
  97    ¤Æ¤¯¤À¤µ¤¤¡¥
  98
  99    1) ³ºÅö¥Æ¡¼¥Ö¥ë¤ËÇÓÂ¾¥í¥Ã¥¯¤¬¤«¤«¤Ã¤Æ¤¤¤ë¤È¡¤pgrowlocks¤Î¼Â¹Ô¤Ï¥Ö¥í¥Ã
 100       ¥¯¤µ¤ì¤Þ¤¹¡¥
 101
 102    2) pgrowlocks¤Î¼Â¹ÔÃæ¤Ë¿·¤¿¤Ë¤«¤«¤Ã¤¿¤ê¡¤²ò½ü¤µ¤ì¤¿¹Ô¥í¥Ã¥¯¤Ë´Ø¤¹¤ë
 103       ¾ðÊó¤Ïpgrowlocks¤Î¼Â¹Ô·ë²Ì¤ËÈ¿±Ç¤µ¤ì¤Æ¤¤¤Ê¤¤²ÄÇ½À¤¬¤¢¤ê¤Þ¤¹¡¥
 104
 105
 106    pgrowlocks¤Ï¥í¥Ã¥¯¤µ¤ì¤¿¹Ô¤ÎÆâÍÆ¤ÏÉ½¼¨¤·¤Þ¤»¤ó¡¥¹ÔÆâÍÆ¤ò¸«¤¿¤¤¾ì¹ç
 107    ¤Ï¡¤¥Æ¡¼¥Ö¥ë¤òpgrowlocks¤Îlocked_rowsÎó¤Ç·ë¹ç¤·¤Þ¤¹¡¥Îã¤ò¼¨¤·¤Þ¤¹¡¥
 108
 109    SELECT * FROM accounts AS a, pgrowlocks('accounts') AS p WHERE p.locked_ row = a.ctid;
 110
 111
 112 4. pgrowlocks¤Î¥é¥¤¥»¥ó¥¹¾ò·ï¤Ë¤Ä¤¤¤Æ
 113
 114    pgrowlocks.c¤ÎËÁÆ¬¤Ë½ñ¤¤¤Æ¤¢¤ëÄÌ¤ê¤Ç¤¹(½¤ÀµBSD¥é¥¤¥»¥ó¥¹¤Ë½à¤¸¤Æ¤¤
 115    ¤Þ¤¹)¡¥¤Þ¤¿¡¤pgrowlocks ¤Ï´°Á´¤ËÌµÊÝ¾Ú¤Ç¤¹¡¥pgrowlocks ¤ò»ÈÍÑ¤·¤¿¤³
 116    ¤È¤Ë¤è¤Ã¤ÆÀ¸¤¸¤ë¤¤¤«¤Ê¤ë·ë²Ì¤Ë´Ø¤·¤Æ¤âÀÕÇ¤¤òÉé¤¤¤Þ¤»¤ó¡¥
 117
 118 5. ²þÄûÍúÎò
 119
 120    2006/03/21 pgrowlocks ¥Ð¡¼¥¸¥ç¥ó 1.1¥ê¥ê¡¼¥¹(8.2 current¤Ç¥Æ¥¹¥È)
 121    2005/08/22 pgrowlocks ¥Ð¡¼¥¸¥ç¥ó 1.0¥ê¥ê¡¼¥¹