[B! postgresql] rekramkoobã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

rekramkoob id:rekramkoob

postgresqlã«é–¢ã™ã‚‹rekramkoobã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (131)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

PostgreSQLã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã¨ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è‡ªå‹•ã§è¡Œã†
æ˜¨æ—¥å°‹å¸¸ã§ã¯ãªã„ä½ã«é£Ÿã¹éŽãŽã¦ã—ã¾ã„ã€ãƒ›ãƒ³ãƒˆåä¾›ã¿ãŸã„ãªè©±ã§ã™ã‘ã©æœ¬æ—¥ã€è…¹ç—›ã§æ»ã«ãã†ã«ãªã£ã¦ãŠã‚Šã¾ã™ã€‚ã€€æ£ç›´ã‚¢ã‚«ãƒã€å‘†ã‚Œã¦ãŸï¼ˆæ¶™ï¼‰ã€‚ ãã‚“ãªã“ã‚“ãªã§ã™ã‹ã‚‰å¯è¾¼ã‚“ã§ã„ãŸã‚“ã§ã™ã‘ã©ã€ãµã¨PostgreSQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è‡ªå‹•åŒ–ã—ã‚ˆã†ã¨ãƒ‘ã‚½ã‚³ãƒ³ã®å‰ã«ã‚„ã£ã¦ããŸè¨³ã§ã™ã€‚ã€€ç¾åœ¨ã®çŠ¶æ³ã§ã¯å®šæœŸçš„ã«dataãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãƒ¼ã‚’ä¸¸ã”ã¨ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¦ã„ã‚‹ã®ã§ã™ï¼ˆãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ãƒ¬ãƒ™ãƒ«ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼‰ã€‚ã€€ãã‚Œã¯ãã‚Œã§å•é¡Œç„¡ã„ã¨æ€ã†ã‚“ã§ã™ã‘ã©ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ä¸ã«æ›¸ãè¾¼ã¿ãŒã‚ã‚‹ã¨æ•´åˆæ€§ãŒä¿ãŸã‚Œãªããªã‚‹ã¨ã„ã†å•é¡ŒãŒã‚ã‚‹ã®ã§ã€ã„ã¤ã‹ã¯pg_dumpã‚’ä½¿ã£ã¦ã¡ã‚ƒã‚“ã¨ã—ãŸãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã„ãŸã„ãªã€ã¨ã¯æ€ã£ã¦ã¾ã—ãŸã€‚ pgAdminã§pg_dumpã‚’å®Ÿè¡Œã™ã‚‹ã¨å®Ÿè¡Œã‚³ãƒžãƒ³ãƒ‰ã‚‚è¡¨ç¤ºã—ã¦ãã‚Œã‚‹ã®ã§ã‚ã‚ŠãŒãŸã„ã§ã™ã€‚ã€€ã“ã‚Œã‚’ãã®ã¾ã¾ä½¿ã„ã¾ã™ã€‚ã€€ã—ã‹ã—ã€DOSçª“ã§ã“ã‚Œã‚’å®Ÿè¡Œã—ã¦ã‚‚ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’æ±‚ã‚ã‚‰ã‚Œã¦ã—ã¾ã„ã€è‡ªå‹•åŒ–ã«ãªã‚Šã¾ã›ã‚“ã€‚ã€€
rekramkoob 2009/03/06
*tips

postgresql

backup
ãƒªãƒ³ã‚¯
PostgreSQL administration - ãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
PostgreSQL ã®ç®¡ç† ãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— æ—¥ã€…ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é‹ç”¨ã—ã€å®‰å…¨é¢ã‚’è€ƒãˆã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯å½“ç„¶å¿…è¦ã¨ãªã£ã¦ãã¾ã™ã€‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®æ–¹æ³•ã«ã¯è¤‡æ•°é€šã‚Šã‚ã‚Šã¾ã™ã€‚ data ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã”ã¨ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã¨ã‚‹ pg_dump ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã† ä¸€ç•ªç›®ã®æ–¹æ³•ã¯ã€éžå¸¸ã«æ‰‹ã£å–ã‚Šæ—©ã„ã‚‚ã®ã§ã™ã€‚PostgreSQL ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€æ™®é€šã®ãƒ•ã‚¡ã‚¤ãƒ«ã§ã™ã®ã§ã€OS ã«ä»˜ã„ã¦ã„ã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã—ã¦ã—ã¾ã†æ–¹æ³•ã§ã™ã€‚tar ã‚³ãƒžãƒ³ãƒ‰ã‚„ã€cp ã‚³ãƒžãƒ³ãƒ‰ã‚„ã€ãã®ä»–ã®ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ PostgreSQL ã® data ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¾ã„ã¾ã™ã€‚ãŸã ã—ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ä¸ã«ãƒ‡ãƒ¼ã‚¿ãŒå¤‰æ›´ã•ã‚Œã‚‹ã¨ã¾ãšã„ã®ã§ã€å¿…ãšãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åœæ¢ã—ãŸçŠ¶æ…‹ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¾ã™ã€‚ã—ãŸãŒã£ã¦ã€ã“ã®æ–¹æ³•ã¯ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ™‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒåœæ¢ã—ã¦ã‚‚ã‹ã¾ã‚ãªã„ã‚ˆã†ãªç’°å¢ƒã§åˆ©ç”¨ã§ãã¾ã™ã€‚
rekramkoob 2009/03/06
*tips

postgresql

backup
ãƒªãƒ³ã‚¯
ä½¿ãˆã‚‹ãã£ã¨ :: ãƒˆãƒ”ãƒƒã‚¯ã‚’è¡¨ç¤º - Postgreã®ãƒªã‚¹ãƒˆã‚¢ã®æ–¹æ³•
rekramkoob 2009/03/06
*tips

postgresql

backup
ãƒªãƒ³ã‚¯
[PHP-users 3002] Re: PEAR+Postgresã§ Ins ert æ™‚ã®ã‚·ãƒªã‚¢ãƒ«ã‚’çŸ¥ã‚ŠãŸã„
æ¸…æ°´ã€€æ˜åš php-users@php.gr.jp Sat, 20 Oct 2001 17:39:02 +0900 (JST) å‰ã®è¨˜äº‹: [PHP-users 3000] Re: PEAR+Postgresã§ Ins ert æ™‚ã®ã‚·ãƒªã‚¢ãƒ«ã‚’çŸ¥ã‚ŠãŸã„ æ¬¡ã®è¨˜äº‹: [PHP-users 3001] php-jp.junbi.net ç›®æ¬¡ã®é †: [ æ—¥ä»˜ ] [ ã‚¹ãƒ¬ãƒƒãƒ‰ ] [ ä»¶å ] [ ç™ºä¿¡è€… ] æ¸…æ°´ã§ã™ On Sat, 20 Oct 2001 16:15:55 +0900 KOYAMA Tetsuji <[email protected]> wrote: > PHP-4.0.6 ã«é™„å±žã™ã‚‹ PEAR ã‹ã‚‰ nextId() ãƒ¡ã‚½ãƒƒãƒ‰ãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ã¦ > ã¾ã™ã€‚ > > $db = DB::conecct('pgsql://localhost/dbname'); > $seqnum
rekramkoob 2008/09/24
*programming

php

postgresql
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿åž‹
ç›®æ¬¡8.1. æ•°å€¤ãƒ‡ãƒ¼ã‚¿åž‹8.1.1. æ•´æ•°ãƒ‡ãƒ¼ã‚¿åž‹8.1.2. ä»»æ„ã®ç²¾åº¦ã‚’æŒã¤æ•°8.1.3. æµ®å‹•å°æ•°ç‚¹ãƒ‡ãƒ¼ã‚¿åž‹8.1.4. é€£ç•ªåž‹8.2. é€šè²¨åž‹8.3. æ–‡å—åž‹8.4. ãƒã‚¤ãƒŠãƒªåˆ—ãƒ‡ãƒ¼ã‚¿åž‹8.5. æ—¥ä»˜/æ™‚åˆ»ãƒ‡ãƒ¼ã‚¿åž‹8.5.1. æ—¥ä»˜/æ™‚åˆ»ã®å…¥åŠ›8.5.2. æ—¥ä»˜/æ™‚åˆ»å‡ºåŠ›8.5.3. æ™‚é–“å¸¯8.5.4. å†…éƒ¨8.6. è«–ç†å€¤ãƒ‡ãƒ¼ã‚¿åž‹8.7. å¹¾ä½•ãƒ‡ãƒ¼ã‚¿åž‹8.7.1. åº§æ¨™ç‚¹8.7.2. ç·šåˆ†8.7.3. çŸ©å½¢8.7.4. çµŒè·¯8.7.5. å¤šè§’å½¢8.7.6. å††8.8. ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚¢ãƒ‰ãƒ¬ã‚¹åž‹8.8.1. inet8.8.2. cidr8.8.3. inetã¨cidrãƒ‡ãƒ¼ã‚¿åž‹ã®é•ã„8.8.4. macaddr8.9. ãƒ“ãƒƒãƒˆåˆ—ãƒ‡ãƒ¼ã‚¿åž‹8.10. é…åˆ—8.10.1. é…åˆ—åž‹ã®å®£è¨€8.10.2. é…åˆ—ã®å€¤ã®å…¥åŠ›8.10.3. é…åˆ—ã«å¯¾ã™ã‚‹ã‚¢ã‚¯ã‚»ã‚¹8.10.4. é…åˆ—ã®å¤‰æ›´8.10.5
rekramkoob 2008/09/22
*server

db

postgresql
ãƒªãƒ³ã‚¯
PostgreSQL ã§é€£ç•ªã®æ•°å—ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œã‚‹æ–¹æ³• (sequence ã«ã¤ã„ã¦) | PostgreSQL | é˜¿éƒ¨è¾°ä¹Ÿã®ãƒ–ãƒã‚°â€•â€•äººç”Ÿã¯ã²ã¾ã¤ã¶ã—ã€‚
ã“ã‚“ãªæ„Ÿã˜ã§ã€ã€ŒLiquorIDã€ã«æ•°å—ã‚’é€£ç•ªã§æŒ¯ã£ã¦ã„ãã€ã¨ã„ã†ã‚±ãƒ¼ã‚¹ã§ã™ãã€‚ ã“ã†ã„ã†é¢¨ã«ã€é †ç•ªã«ç•ªå·ã‚’æŒ¯ã£ã¦ã„ãéš›ã«ä½¿ã†ã®ãŒã€sequence(ã‚·ãƒ¼ã‚±ãƒ³ã‚¹)ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚ sequence (ã‚·ãƒ¼ã‚±ãƒ³ã‚¹) ã®ä½œæˆ sequence (ã‚·ãƒ¼ã‚±ãƒ³ã‚¹) ã¯ã€ã€Œcreate sequence ã‚·ãƒ¼ã‚±ãƒ³ã‚¹å ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€ã¨ã„ã† SQLæ–‡ã§ã€ä½œæˆã§ãã¾ã™ã€‚ ä¾‹ãˆã°ã‚·ãƒ³ãƒ—ãƒ«ã«ã€1 ã‹ã‚‰ã‚¹ã‚¿ãƒ¼ãƒˆã—ã¦ã€1 ãšã¤å¢—åŠ ã—ã¦ã„ãã€ŒLiquorID_seqã€ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ã‚’ä½œã‚‹å ´åˆã¯ã€ä¸‹è¨˜ã®ã‚ˆã†ãª SQLæ–‡ã«ãªã‚Šã¾ã™ã€‚ create sequence LiquorID_seq; åˆæœŸå€¤ã‚’ 1 ã§ã¯ãªãã€ä¾‹ãˆã° 10001 ã«ã—ãŸã„å ´åˆã¯ã€ã€Œstartã€ã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ã¤ã‘ã¦ã€ create sequence LiquorID_seq start 10001; ã¨ã‚„ã‚Œã° OK ã€‚ sequence (ã‚·ãƒ¼ã‚±ãƒ³ã‚¹
rekramkoob 2008/09/10
*server

postgresql

db
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬1å›žï¼šåŒã˜ã‚ˆã†ã§é•ã†ãƒ‡ãƒ¼ã‚¿åž‹ (1/3)
æœ¬é€£è¼‰ã§ã¯ã€ã€Œå¾¹åº•æ¯”è¼ƒ!! PostgreSQL vs MySQLã€ã§å–ã‚Šä¸Šã’ã‚‹ã“ã¨ã®ã§ããªã‹ã£ãŸé …ç›®ã‚’ã„ãã¤ã‹å–ã‚Šä¸Šã’ã€å†ã³PostgreSQLã¨MySQLã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚æœ€å¾Œã¾ã§ãŠä»˜ãåˆã„ã„ãŸã ã‘ã‚‹ã¨å¹¸ã„ã§ã™ã€‚ ãªãŠã€æœ¬é€£è¼‰ã§ã®è§£èª¬å¯¾è±¡ã®PostgreSQLã¨MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚
rekramkoob 2008/09/03
*server

db

mysql

postgresql
ãƒªãƒ³ã‚¯
memcachedï¼‹PostgreSQLã§å®Ÿç¾ã™ã‚‹ãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹ç¯‰ï¼ˆ1/4ï¼‰ â€• ï¼ IT
æœ¬ç¨¿ã®å‰æç’°å¢ƒ memcached 1.2.5 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼šPostgreSQL 8.3.1 OSï¼šCentOS 5ï¼ˆLinux kernel 2.6 ï¼‰ ã‚·ã‚§ãƒ«ï¼šbash CPUï¼šIntel Core2Quad 9660 2.4GHz RAMï¼šPC2-6400 8GBytes memcachedã¯ã€Danga Interactiveã«ã‚ˆã£ã¦é–‹ç™ºã•ã‚ŒãŸã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ¡ãƒ¢ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒã§ã™ã€‚ ãƒ¡ãƒ¢ãƒªä¸Šã«ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã®ã§memcachedã‚’çµ‚äº†ã™ã‚‹ã¨ãƒ‡ãƒ¼ã‚¿ãŒå¤±ã‚ã‚Œã¾ã™ãŒã€ï¼ˆOracleã‚„MySQLã¨ã„ã£ãŸï¼‰RDBMSã¨æ¯”è¼ƒã™ã‚‹ã¨ã‘ãŸé•ã„ã®é«˜é€Ÿãƒ¬ã‚¹ãƒãƒ³ã‚¹æ€§èƒ½ã‚’æœ‰ã—ã€æ•°åƒä¸‡ä»¶ã¨ã„ã†å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã£ã¦ã‚‚ã»ã¨ã‚“ã©æ€§èƒ½ãŒåŠ£åŒ–ã—ãªã„ã¨ã„ã†ç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ æ©Ÿèƒ½ã¯é™ç•Œã¾ã§åˆ‡ã‚Šè©°ã‚ã‚‰ã‚Œã€åŸºæœ¬çš„ã«ã¯ã‚ãƒ¼ã¨ãƒ‡ãƒ¼ã‚¿ã®çµ„ï¼ˆä»¥ä¸‹ã€it emã¨å‘¼ã³ã¾ã™ï¼‰ã®ä¿å˜ã¨æ¤œç´¢ã¨å‰Šé™¤ã—ã‹ã§ãã¾ã›ã‚“ã€‚ ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€me
rekramkoob 2008/08/01
*server

memcached

postgresql

db
ãƒªãƒ³ã‚¯
Sigres MOONGIFT
PostgreSQLã®INSERT/UPDATEã‚’æ•°å€ï½žæ•°åå€é«˜é€ŸåŒ– ã‚·ã‚¹ãƒ†ãƒ ã‚³ãƒ¼ãƒ«éƒ¨åˆ†ã‚’æ”¹è‰¯ã™ã‚‹ã“ã¨ã§ã€INSERT/UPDATEã‚’æ•°å€ï½žæ•°åå€é«˜é€ŸåŒ–ã•ã›ãŸPostgreSQLã§ã™ã€‚ PostgreSQLã®INSERT/UPDATEã‚’æ•°å€ï½žæ•°åå€é«˜é€ŸåŒ– Sigres å•†ç”¨DBã«åŒ¹æ•µã™ã‚‹ç¨‹ã®é«˜æ€§èƒ½ã‚’ã»ã“ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹RDBMSã§ã‚ã‚‹PosgreSQLã€‚å …ç‰¢ã•ã§ã¯PostgreSQLã€é«˜é€Ÿæ€§ã§ã¯MySQLã¨ã„ã£ãŸèªè˜ãŒä¸€èˆ¬çš„ã ãŒã€æžœãŸã—ã¦ãã†ã ã‚ã†ã‹ã€‚ ã‚‚ã—PostgreSQLã«é«˜é€Ÿæ€§ã‚’æ±‚ã‚ã‚‹ãªã‚‰ã°ã€ã“ã†ã—ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒå˜åœ¨ã™ã‚‹ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯Sigresã€INSERT/UPDATEã‚’é«˜é€ŸåŒ–ã—ãŸPostgreSQLã ã€‚ Sigresã¯UPSã®åˆ©ç”¨ã‚’å‰æã¨ã—ã¦é–‹ç™ºã•ã‚Œã¦ã„ã‚‹PostgreSQLã§ã€é€šå¸¸ã®PostgreSQLã«æ¯”ã¹INSERTã‚„UPDATEãŒæ•°å€
rekramkoob 2008/05/26
*software

postgresql
ãƒªãƒ³ã‚¯
åŒ…å¤´å¸‚åˆ›åŠžæˆ’æ¯’å®¶å±žå¦æ ¡â€œç…§äº®â€æˆ’æ¯’äººå‘˜å›žå®¶è·¯ ç¼–è¾‘ï¼šæˆ’æ¯’å®¶å±žå¦çŽ‹ä¸œéœ‡-æ¦å†ˆæ–°æ“žè”¬èœè¡Œæƒ…ç½‘
æœ€æ–°æ–‡ç« 2018-12-26 18:36â–ª åŠæ—¶æ´åŠ©ï¼å•å¦‡é™•è¥¿å—è·¯åœ°é“ç«™å†…ä¸´ç›†åœ°é“å·¥ä½œäººå‘˜æ–½ä»¥æ´æ‰‹ 2018-12-26 18:36â–ª 17æ¡ç”Ÿæ€å»Šé“ç¼–ç»‡å·¨å¤§â€œç»¿é¡¹é“¾â€ä¸Šæµ·æ£®æž—è¦†ç›–çŽ‡å‡è‡³16... 2018-12-26 18:36â–ª å¤§å†¶å‘ç”Ÿä¸€èµ·3äººæ»äº¡çš„å†’é¡¶äº‹æ•…å…¬å¸æ‰€å±žçŸ¿å±±è¿žç»7å¹´å‘ç”Ÿ... 2018-12-26 18:36â–ª å¤®è¡Œï¼šå››å£åº¦88.8%çš„å±…æ°‘è®¤ä¸ºæ”¶å…¥å¢žåŠ æˆ–åŸºæœ¬ä¸å˜ 2018-12-26 18:36â–ª â€œç¬¬ä¸‰å±Šå¤§ä½¿å›¾ä¹¦è§’â€å›¾ä¹¦æèµ åœ¨é‡‘è¾¹ä¸¾è¡Œ 2018-12-26 18:36â–ª çˆ¶æ¯ä¸è®©çŽ©ç”µè„‘ï¼Œå¥¹å°±åœ¨çº¸ä¸Šå†™ä»£ç ï¼9å²å¥³å©ä»Ž4000äººä¸... 2018-12-26 18:36â–ª é«˜ç©ºå è½æ°´æ³¥å—ç ¸ç ´4å²å¥³ç«¥å¤´éƒ¨è¦æ–¹æ•°æœˆå¯»å‡¶ç»ˆç ´æ¡ˆ 2018-12-26 18:36â–ª ä¸å›½è¦ä¼â€œæŠ±å›¢â€æ‰“å‡å‡€åŒ–é…’ç±»å¸‚åœº 2018-12-26 18:36â–ª äº¤å·¡è¦å®¢ä¸²èµ°å¤±å¥³ç«¥â€œæš–çˆ¸â€å®žåŠ›å® å¨ƒå¼•ç½‘å‹ç¾¡æ…•
rekramkoob 2008/05/26
*server

db

postgresql
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬5å›žï¼šé«˜åº¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ´»ç”¨ (1/2)
ã“ã“ã¾ã§ã¯å˜ä¸€ã®åˆ—ã«å¯¾ã—ã¦ä½œæˆã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å‰æã«ãŠè©±ã—ã—ã¦ãã¾ã—ãŸã€‚ã—ã‹ã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯åŒä¸€ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¤‡æ•°ã®åˆ—ã«å¯¾ã—ã¦ã¾ã¨ã‚ã¦è¨å®šã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚æ¤œç´¢æ¡ä»¶ã«è¤‡æ•°åˆ—ã‚’æŒ‡å®šã™ã‚‹å ´åˆãªã©ã¯ã€ã“ã®ã‚ˆã†ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ãˆã°ã•ã‚‰ã«åŠ¹çŽ‡ã‚ˆãå‡¦ç†ã‚’è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚
rekramkoob 2008/05/26
*server

db

postgresql
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬4å›žï¼šã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ´»ç”¨ã«ã‚ˆã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° (1/2)
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆindexï¼‰ã¯æ¤œç´¢å‡¦ç†ã‚’é«˜é€ŸåŒ–ã™ã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã§ã™ï¼ˆæ—¥æœ¬èªžã§ã€Œç´¢å¼•ã€ã¨å‘¼ã°ã‚Œã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ï¼‰ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã†ã¨ã€æ¤œç´¢å‡¦ç†ãŒé«˜é€ŸåŒ–ã™ã‚‹ä¸€æ–¹ã€æ›´æ–°å‡¦ç†æ™‚ã®ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ãŒå¢—åŠ ã—ã¦ã€å‡¦ç†é€Ÿåº¦ã«æ‚ªå½±éŸ¿ã‚’ä¸Žãˆã¾ã™ã€‚ã—ãŸãŒã£ã¦ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ä½œã‚Œã°ã‚ˆã„ã¨ã„ã†ã‚‚ã®ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚å¿…è¦ååˆ†ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã‚‹ã“ã¨ãŒåŸºæœ¬ã§ã™ã€‚ PostgreSQLã«ã¯B-treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ãƒãƒƒã‚·ãƒ¥ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€R-treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ãŒã‚ã‚Šã¾ã™ã€‚R-treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å¹¾ä½•ãƒ‡ãƒ¼ã‚¿åž‹å°‚ç”¨ã§ã™ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ä½¿ç”¨ã•ã‚Œã‚‹ã®ã¯B-treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ã™ã€‚å®Ÿè£…ãŒä¸€ç•ªæ´—ç·´ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç‰¹ã«ç†ç”±ã®ãªã„é™ã‚ŠB-treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ç”¨ã‚’ãŠå‹§ã‚ã—ã¾ã™ã€‚æœ¬ç¨¿ã§ã‚‚ä»¥ä¸‹ã€Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ã¨è¨€ãˆã°B-treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æŒ‡ã™ã“ã¨ã«ã—ã¾ã™ã€‚ B-treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æœ‰åŠ¹ã«åˆ©ç”¨ã™ã‚‹ãŸã‚ã«ã¯ã€ãã®å‹•ä½œåŽŸç†ã‚’ç†è§£ã—ã¦ãŠãã“
rekramkoob 2008/05/26
*server

db

postgresql
ãƒªãƒ³ã‚¯
å¤§é‡ä»¶æ•°ã®INSERT or UPDATE ã‚’ç¹°ã‚Šè¿”ã™ãƒãƒƒãƒã§ã®æ³¨æ„ç‚¹
ï¼‘ï¼Žå‡¦ç†é€Ÿåº¦ å˜ç´”ã«INSERTã§æ¸ˆã‚€å ´åˆã¯COPYæ–‡ã‚„psqlã«ã‚ˆã‚‹æ‰‹ç¶šããŒä¾¿åˆ©ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“ã€‚ UPDATEã¨INSERTãŒã©ã¡ã‚‰ã‚‚å«ã¾ã‚Œã‚‹å ´åˆã€æœ€åˆã«INSERTã¨UPDATEã®äºŒã¤ã«åˆ†ã‘ã¦ã—ã¾ã£ãŸæ–¹ãŒæ—©ã„ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“ã€‚ SELECT primary_column FROM table_name WHERE primary_column IN (ãƒ—ãƒ©ã‚¤ãƒžãƒªãƒ¼ã‚ãƒ¼ã®é…åˆ—ï¼“ä¸‡å‰å¾Œï¼‰; ã¨ã‹ã§ã€‚ PRIMARYã‚ãƒ¼ãŒ40ãƒã‚¤ãƒˆã ã£ãŸã¨ã—ã¦ã‚‚ã€1MBç¨‹åº¦ã®ãƒ¡ãƒ¢ãƒªé‡ã§æ¸ˆã¿ãã†ã§ã™ã€‚ ï¼’ï¼Žãƒ¡ãƒ¢ãƒªä½¿ç”¨æ–™ã«ã¤ã„ã¦ ï¼“ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã¯ãƒ•ã‚¡ã‚¤ãƒ«ã«å…¥ã£ã¦ã„ã‚‹ã¨æ€ã†ã®ã§ã€å˜ç´”ã«fopen+fgetsã«ã—ã¦ã‚„ã‚Œã°ãã‚Œã»ã©ãƒ¡ãƒ¢ãƒªã¯ä½¿ã‚ãªã„ã‚“ã˜ã‚ƒãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ memory_get_usage()é–¢æ•°ã‚’ä½¿ãˆã‚Œã°ã€å®Ÿéš›ã«ãƒ¡ãƒ¢ãƒªé‡ã‚’è¦‹ã¦ã‚„ã‚‹ã¨è‰¯ã„æ°—ãŒã—ã¾ã™ã€‚ ãƒ¡ãƒ¢ãƒªã‚„PHPã®å‡¦ç†ã‚ˆã‚Šã‚‚ã€Postgreå´ã‚„CPUã€
rekramkoob 2008/05/26
*programming

php

postgresql

sql

hatena

search
ãƒªãƒ³ã‚¯
ã€äº‹ä¾‹ã€‘PostgreSQLã®ä¸è¶³æ©Ÿèƒ½ã‚’è‡ªä½œã—ï¼Œ500ä¸‡äººåˆ†ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†---éƒµä¾¿è²¯é‡‘ã‚«ãƒ¼ãƒ‰æ™®åŠå”ä¼šã€Œä¼šå“¡ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã€ï¼ˆä¸‹ï¼‰
å›³2â—ç‹¬è‡ªä½œæˆã—ãŸDBã‚¢ã‚¯ã‚»ã‚¹ãƒ»ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ä¸»ãªæ©Ÿèƒ½ 1ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¤‡æ•°ã®ã‚µãƒ¼ãƒãƒ¼ã«åˆ†å‰²ã™ã‚‹ã€Œã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°æ©Ÿèƒ½ã€ã¨ï¼Œãƒ†ãƒ¼ãƒ—ã‹ã‚‰ãƒªã‚¹ãƒˆã‚¢ã™ã‚‹éš›ã«ãƒ€ã‚¦ãƒ³ç›´å‰ã¾ã§ã®çŠ¶æ…‹ã‚’å¾©å…ƒã™ã‚‹ã€Œãƒãƒ¼ãƒ«ãƒ•ã‚©ãƒ¯ãƒ¼ãƒ‰æ©Ÿèƒ½ã€ã‚’ç‹¬è‡ªã«ä½œæˆã—ãŸ æ¤œç´¢å‡¦ç†ã§æ™‚é–“ãŒã‹ã‹ã‚‹ã®ã¯å…¨ä»¶æ¤œç´¢ã§ã‚ã‚Šï¼Œä¸€èˆ¬çš„ã«å…¨ä»¶æ¤œç´¢ã§ã¯ãƒ‡ã‚£ã‚¹ã‚¯I/OãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚Šã‚„ã™ã„ã€‚NTTãƒ‡ãƒ¼ã‚¿ãŒä½œæˆã—ãŸã€ŒDBã‚¢ã‚¯ã‚»ã‚¹ãƒ»ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã€ã‚’ä½¿ãˆã°ï¼Œãƒ‡ã‚£ã‚¹ã‚¯ã‚’å…±æœ‰ã—ãªã„ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°æ§‹æˆãŒå®Ÿç¾ã§ãï¼Œãƒ‡ã‚£ã‚¹ã‚¯I/Oã‚’åˆ†æ•£ã§ãã‚‹ã€‚DBã‚¢ã‚¯ã‚»ã‚¹ãƒ»ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ï¼Œå‚ç…§æ™‚ã«ã¯è¤‡æ•°ã®ã‚µãƒ¼ãƒãƒ¼ã«SQLæ–‡ã‚’ç™ºè¡Œã—ï¼Œãã‚Œãžã‚Œã®çµæžœã‚’ãƒžãƒ¼ã‚¸ã—ã¦è¿”ã™æ©Ÿèƒ½ãŒã‚ã‚‹ï¼ˆå›³2å·¦[æ‹¡å¤§è¡¨ç¤º]ï¼‰ã€‚ ã¾ãŸï¼ŒDBã‚¢ã‚¯ã‚»ã‚¹ãƒ»ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«ã¯ãƒ‡ãƒ¼ã‚¿ã®æ›´æ–°æ™‚ã«2å°ã®ã‚µãƒ¼ãƒãƒ¼ã«SQLæ–‡ã‚’ç™ºè¡Œã™ã‚‹æ©Ÿèƒ½ãŒã‚ã‚Šï¼Œãƒ‡ãƒ¼ã‚¿ã‚’2é‡åŒ–ã•ã›ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚2é‡åŒ–ã—ã¦ãŠã‘ã°1å°ã®ãƒ‡ã‚£ã‚¹ã‚¯è£…ç½®ãŒå£Šã‚Œã¦ã‚‚ï¼Œã‚‚ã†ä¸€æ–¹ã®ãƒ‡ã‚£ã‚¹ã‚¯ã§å‡¦
rekramkoob 2008/05/22
*server

postgresql

scalability
ãƒªãƒ³ã‚¯
ã€äº‹ä¾‹ã€‘PostgreSQLã®ä¸è¶³æ©Ÿèƒ½ã‚’è‡ªä½œã—ï¼Œ500ä¸‡äººåˆ†ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†---éƒµä¾¿è²¯é‡‘ã‚«ãƒ¼ãƒ‰æ™®åŠå”ä¼šã€Œä¼šå“¡ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã€ï¼ˆä¸Šï¼‰
ã€ŒPostgreSQLã¨Oracleã‚’æ¤œè¨¼ã—ãŸçµæžœï¼Œå·¥å¤«ã™ã‚Œã°PostgreSQLã§ã‚‚å¯èƒ½ã ã¨åˆ¤æ–ã—ãŸã€â€•â€•éƒµä¾¿è²¯é‡‘ã‚«ãƒ¼ãƒ‰æ™®åŠå”ä¼šã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’æ‹…å½“ã—ãŸNTTãƒ‡ãƒ¼ã‚¿ã®æ¸¡éƒ¨åºƒå¿—æ°ã¯ï¼ŒPostgreSQLã®æŽ¡ç”¨ç†ç”±ã‚’ã“ã†èª¬æ˜Žã™ã‚‹ã€‚ ã‚·ã‚¹ãƒ†ãƒ ã§å‡¦ç†ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã®ã¯ï¼Œç´„500ä¸‡äººåˆ†ã®ä¼šå“¡ãƒ‡ãƒ¼ã‚¿ã€‚ä¼šå“¡ã¯ä»Šã‚‚å¢—ãˆã¦ãŠã‚Šï¼Œã‚·ã‚¹ãƒ†ãƒ ã®ä»•æ§˜ã¨ã—ã¦ã¯ä¼šå“¡æ•°1000ä¸‡äººã‚’æƒ³å®šã—ã¦ã„ã‚‹ã€‚PostgreSQLã®æ¤œç´¢æ€§èƒ½ã¯æ¤œè¨¼ã—ãŸçµæžœé«˜ã„ã“ã¨ãŒåˆ†ã‹ã£ãŸãŒï¼Œ1000ä¸‡äººè¦æ¨¡ã®ã‚·ã‚¹ãƒ†ãƒ ã§ä½¿ã†ã«ã¯PostgreSQLã®æ¨™æº–æ©Ÿèƒ½ã ã‘ã§ã¯è¶³ã‚Šãªã‹ã£ãŸã€‚ ã©ã‚“ãªæ¤œç´¢ã§ã‚‚10ç§’ä»¥å†… å›³1â—ã‚·ã‚¹ãƒ†ãƒ æ¦‚è¦ã¨ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ä¸Šã®ãƒã‚¤ãƒ³ãƒˆ ç´„500ä¸‡äººã®ä¼šå“¡ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã€‚å°†æ¥çš„ã«ã¯ä¼šå“¡ãŒ1000ä¸‡äººã«ãªã‚‹ã“ã¨ãŒäºˆæƒ³ã•ã‚Œã‚‹ãŸã‚ï¼Œå¤§é‡ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã™ã‚‹é«˜ã„æ¤œç´¢æ€§èƒ½ãŒæ±‚ã‚ã‚‰ã‚ŒãŸã€‚ã¾ãŸï¼Œã‚ªãƒ³ãƒ©ã‚¤ãƒ³å‡¦ç†ã¯24æ™‚é–“365æ—¥åˆ©ç”¨ã™ã‚‹ãŸã‚ï¼Œé«˜
rekramkoob 2008/05/22
*server

postgresql

scalability
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬1å›žï¼špostgresql.confã«ã‚ˆã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼ˆ1ï¼‰ (1/2)
PostgreSQLã«é™ã‚‰ãšã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã¯å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã®ã§ã€å ´åˆã«ã‚ˆã£ã¦ã¯å‡¦ç†ã«ã‹ãªã‚Šæ™‚é–“ãŒã‹ã‹ã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ãã®ãŸã‚ã€ã§ãã‚‹ã ã‘å‡¦ç†æ™‚é–“ã‚’çŸç¸®ã—ã€å‡¦ç†åŠ¹çŽ‡ã‚’å‘ä¸Šã™ã‚‹ã€Œãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã¨ã„ã†æŠ€è¡“ãŒé‡è¦–ã•ã‚Œã¦ã„ã¾ã™ã€‚ Webã‚·ã‚¹ãƒ†ãƒ ã®ã‚ˆã†ã«æ•°å¤šãã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’åŒæ™‚ã“ãªã•ãªã‘ã‚Œã°ãªã‚‰ãªã„ã‚·ã‚¹ãƒ†ãƒ ã§ã¯ã€å€‹ã€…ã®å•ã„åˆã‚ã›ã®å‡¦ç†æ™‚é–“ã¯æ•°ç™¾ãƒŸãƒªç§’ã¨çŸãã¦ã‚‚ã€å…¨ä½“ã®å‡¦ç†æ™‚é–“ãŒè†¨å¤§ã«ãªã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã§ã¯ã€1ã¤1ã¤ã®å‡¦ç†æ™‚é–“ã‚’ã§ãã‚‹ã ã‘çŸãã™ã‚‹ã“ã¨ãŒé‡è¦ã§ã™ã€‚ ã¾ãŸã€ã€Œãƒãƒƒãƒå‡¦ç†ã€ã«ãŠã„ã¦ã‚‚å‡¦ç†æ™‚é–“ã®çŸç¸®ã¯é‡è¦ã§ã™ã€‚ãƒãƒƒãƒå‡¦ç†ã¨ã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨å¯¾è©±çš„ã«è¡Œã‚ã‚Œã‚‹å‡¦ç†ã§ã¯ãªãã€è‡ªå‹•çš„ã«å®Ÿè¡Œã•ã‚Œã‚‹å‡¦ç†ã§ã™ï¼ˆå¤šãã®å ´åˆã€äººæ‰‹ã‚’ä»‹ã™ã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ï¼‰ã€‚ãŸã¨ãˆã°1æ—¥ã®ãƒ‡ãƒ¼ã‚¿ã‚’å¤œé–“ã«ã¾ã¨ã‚ã‚‹ã€Œæ—¥æ¬¡å‡¦ç†ã€ãªã©ãŒã“ã‚Œã«è©²å½“ã—ã¾ã™ã€‚æ—¥æ™‚å‡¦ç†ãŒæ±ºã‚ã‚‰ã‚ŒãŸæ™‚é–“å†…ã«çµ‚ã‚ã‚‰ãªã‘ã‚Œã°ã€å‡¦ç†è‡ªä½“ãŒç„¡æ„
rekramkoob 2008/05/22
*server

postgresql

tips
ãƒªãƒ³ã‚¯
PostgreSQL / ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©é–¢æ•°ã‚’ä½¿ã†
PostgreSQLã§ã¯ã€ ã„ã‚ã‚†ã‚‹ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ã“ã¨ã‚’ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©é–¢æ•°ã¨å‘¼ã³ã¾ã™ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©é–¢æ•°ã‚’ä½¿ã£ã¦ã„ã‚ã„ã‚ãªãƒ‡ãƒ¼ã‚¿å‡¦ç†ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å´ã«ã‚‚ãŸã›ã¦ãŠãã“ã¨ã§ã€ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å…±é€šã®å‡¦ç†ã‚’ã²ã¨ã¤ã«ã¾ã¨ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ PostgreSQLã§å¤§è¦æ¨¡ãªãƒãƒƒãƒå‡¦ç†ã¨ã„ã†ã®ã¯ã‚ã¾ã‚Šèžãã¾ã›ã‚“ãŒã€ OLTPç³»ã§ã‚‚å¤§è¦æ¨¡ãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¯ä¸å¯æ¬ ã¨ã‚‚è¨€ãˆã‚‹æ©Ÿèƒ½ãªã®ã§ã€ ã“ã“ã§ã‚‚ã‚¼ãƒ’ã‚¼ãƒ’ã”ç´¹ä»‹ã—ã¦ãŠãã¾ã™ã€‚ PostgreSQLã®ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©é–¢æ•°ã¯ã€ è¤‡æ•°ã®è¨˜è¿°è¨€èªžã‚’ä½¿ã†ã“ã¨ãŒã§ãã‚‹ã®ãŒæœ€å¤§ã®ç‰¹å¾´ã§ã€ ç‹¬è‡ªã®è¨˜è¿°è¨€èªžã‚’æè¼‰ã™ã‚‹ã“ã¨ãŒå¤šã„å•†ç”¨RDBMSã‚ˆã‚Šã‚‚é¸æŠžè‚¢ãŒåºƒã„ã¨ã„ãˆã¾ã—ã‚‡ã†ã€‚ æ¨™æº–ã§å…¥ã£ã¦ã„ã‚‹ã‚‚ã®ã ã‘ã§ã‚‚å˜ç´”ãªSQLã¨ï¼£è¨€èªžã€PL/Tcl(Tclè¨€èªž)ã€ PL/Perl(Perlè¨€èªž)ã€ PL/pgSQL(Oracle
rekramkoob 2008/05/22
ã‚¹ãƒˆã‚¢ãƒ‰

*programming

postgresql
ãƒªãƒ³ã‚¯
Belajar Pemrograman Komputer dengan Yang Terbaik
rekramkoob 2008/05/22
*programming

postgresql

sql
ãƒªãƒ³ã‚¯
Oracle ã® MERGE ã«ç›¸å½“ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã‚’ PostgreSQL ã§è¡Œã†ã«ã¯ï¼Ÿ
Oracle ã® MERGE ã«ç›¸å½“ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã‚’ PostgreSQL ã§è¡Œã†ã«ã¯ï¼Ÿ
rekramkoob 2008/05/22
*hatena

search

postgresql

sql
ãƒªãƒ³ã‚¯
41.4. INSERTã€UPDATEã€DELETEã«ã¤ã„ã¦ã®ãƒ«ãƒ¼ãƒ«
rekramkoob 2008/05/22
*programming

postgresql

reference
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 æ¬¡ã®ãƒšãƒ¼ã‚¸