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

pero1 id:pero1

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

${{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}}

ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ»ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ | Let's POSTGRES
ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ»ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ (Streaming Replication) ã¯ã€PostgreSQL 9.0 ä»¥é™ã§åˆ©ç”¨ã§ãã‚‹ã€æœ¬ä½“çµ„ã¿è¾¼ã¿ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã§ã™ã€‚å‚ç…§/æ›´æ–°ãŒå¯èƒ½ãª1ã¤ã®ãƒžã‚¹ã‚¿DBã¸ã®æ›´æ–°æ“ä½œã‚’ã€å‚ç…§ã®ã¿ãŒå¯èƒ½ãªè¤‡æ•°ã®ã‚¹ã‚¿ãƒ³ãƒã‚¤DBã¸è»¢é€ã™ã‚‹ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¤‡è£½ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã‚¹ã‚¿ãƒ³ãƒã‚¤DBã«æ›´æ–°çµæžœãŒåæ˜ ã•ã‚Œã‚‹ã¾ã§ã«ã¯è‹¥å¹²ã®é…å»¶ãŒã‚ã‚Šã¾ã™ãŒã€æ¯”è¼ƒçš„ é…å»¶ã¯å°‘ãªãã€ãƒžã‚¹ã‚¿DBã¸ã®å½±éŸ¿ã‚‚å°ã•ã„ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ–¹å¼ã§ã™ã€‚ ç”¨é€” ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ»ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¯ä»¥ä¸‹ã®ç”¨é€”ãŒã‚ã‚Šã¾ã™ã€‚ å¤šæ•°ã®å‚ç…§ã‚¯ã‚¨ãƒªã®ã‚µãƒ¼ãƒé–“åˆ†æ•£ ãƒžã‚¹ã‚¿DBç•°å¸¸æ™‚ã®è¿…é€Ÿãªãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ (åˆ‡ã‚Šæ›¿ãˆ) ãƒžã‚¹ã‚¿DBã®ãƒ‡ã‚£ã‚¹ã‚¯æ•…éšœã«å‚™ãˆãŸãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ãƒ»ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— PostgreSQL 9.1 ã§ã®å¼·åŒ–ç‚¹ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 9.0 ã®ç›®çŽ‰æ©Ÿèƒ½ã¨ã—ã¦ç™»å ´ã—ãŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã§ã™ãŒã€9.1 ã§ã¯
pero1 2015/03/11
postgresql
ãƒªãƒ³ã‚¯
PostgreSQLã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ç¬¬1å›ž ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®4ã¤ã®æ§‹æˆ | Nedia What's up!
PostgreSQLã‚’ä½¿ã£ã¦ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã—ã¦ã„ã‚‹ã¨ã€ãƒ¬ã‚¹ãƒãƒ³ã‚¹é€Ÿåº¦ã®æ”¹å–„ãŒèª²é¡Œã«ãªã£ã¦ãã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ãã®ã‚ˆã†ãªå ´åˆã€ã¾ãšã¯ã‚·ã‚¹ãƒ†ãƒ è‡ªä½“ã®ã‚¯ã‚¨ãƒªã®è¦‹ç›´ã—ã‚’è¡Œã£ãŸã‚Šã€PostgreSQLè‡ªä½“ã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—æ”¹å–„ã‚’è¡Œã„ã¾ã™ãŒã€ãã‚Œã§ã‚‚ã¾ã é€Ÿåº¦ãŒç‰©è¶³ã‚Šãªã„å ´åˆã«ã¯ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢å¢—å¼·ã‚’æ¤œè¨Žã™ã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢çš„ã«ã¯ã€Œãƒ‡ã‚£ã‚¹ã‚¯ã®I/Oæ€§èƒ½ã®ä¸è¶³ã€ã‹ã€ã€ŒCPUã®å‡¦ç†èƒ½åŠ›ä¸è¶³ã€ã®ã©ã¡ã‚‰ã‹ãŒåŽŸå› ã¨ãªã£ã¦ã„ã‚‹ã“ã¨ãŒå¤šãã€ãã¡ã‚“ã¨ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’è¦‹æ¥µã‚ã¦ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢äº¤æ›ã‚’è¡Œã†ã“ã¨ã§é€Ÿåº¦æ”¹å–„ãŒã§ããŸã‚Šã—ã¾ã™ã€‚ ã¨ã“ã‚ãŒè‘—ã—ãã‚¢ã‚¯ã‚»ã‚¹ãŒå¤šã„å ´åˆã‚„ã€é‡ã„å‡¦ç†ã‚’è¤‡æ•°èµ°ã‚‰ã›ãŸã‚Šã™ã‚‹å ´åˆã«ã¯ã€ãã‚Œã§ã‚‚é€Ÿåº¦ã«ä¸æº€ã‚’æ„Ÿã˜ã‚‹å ´é¢ãŒå‡ºã¦ãã¾ã™ã€‚ ãã‚“ãªã¨ãã®æ”¹å–„ç–ã®1ã¤ã¨ã—ã¦ã€PostgreSQLã‚µãƒ¼ãƒã‚’å‚ç…§æ›´æ–°å¯èƒ½ãªãƒžã‚¹ã‚¿ãƒ¼ã¨å‚ç…§ã®ã¿ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã«åˆ†ã‘ãŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹æˆã§é‹ç”¨ã—è² è·åˆ†æ•£ã‚’è¡Œã†æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚
pero1 2015/03/11
postgresql
ãƒªãƒ³ã‚¯
NTTãƒ‡ãƒ¼ã‚¿ã¨PostgreSQLãŒæŒ‘ã‚“ã ç·åŠ›æˆ¦ã€‚PostgreSQLã‚’æ¥µé™ã¾ã§ä½¿ã„åˆ‡ã£ãŸãã®å…ˆã«è¦‹ãŸã‚‚ã®ã¨ã¯ï¼Ÿï¼ˆå‰ç·¨ï¼‰ NTTãƒ‡ãƒ¼ã‚¿ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹DAY2015 ï¼ Publickey
NTTãƒ‡ãƒ¼ã‚¿ã¨PostgreSQLãŒæŒ‘ã‚“ã ç·åŠ›æˆ¦ã€‚PostgreSQLã‚’æ¥µé™ã¾ã§ä½¿ã„åˆ‡ã£ãŸãã®å…ˆã«è¦‹ãŸã‚‚ã®ã¨ã¯ï¼Ÿï¼ˆå‰ç·¨ï¼‰ NTTãƒ‡ãƒ¼ã‚¿ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹DAY2015 ç¾åœ¨ã®ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã§ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’ä½¿ã†ã“ã¨ã¯å½“ãŸã‚Šå‰ã«ãªã£ã¦ãã¦ã„ã¾ã™ã€‚PostgreSQLã¯ãã†ã—ãŸä¸ã§ä¸»ã«ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ç€å®Ÿã«äº‹ä¾‹ã‚’å¢—ã‚„ã—ã¦ãã¦ã„ã¾ã™ã€‚ ãã®ä¸ã§ã€PostgreSQLã‚’å¤§è¦æ¨¡ãªãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ãªã‚·ã‚¹ãƒ†ãƒ ã®ä¸ã§ä½¿ã†ã«ã¯ã€ã©ã®ã‚ˆã†ãªãƒŽã‚¦ãƒã‚¦ãŒæ±‚ã‚ã‚‰ã‚Œã‚‹ã®ã‹ã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®åˆ©ç”¨ã«ç©æ¥µçš„ãªNTTãƒ‡ãƒ¼ã‚¿ãŒãã®äº‹ä¾‹ã‚’ã€1æœˆ26æ—¥ã«é–‹å‚¬ã•ã‚ŒãŸã‚¤ãƒ™ãƒ³ãƒˆã€ŒNTTãƒ‡ãƒ¼ã‚¿ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹DAY 2015ã€ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒNTTãƒ‡ãƒ¼ã‚¿ã¨PostgreSQLãŒæŒ‘ã‚“ã ç·åŠ›æˆ¦ã€‚PostgreSQLã‚’æ¥µé™ã¾ã§ä½¿ã„åˆ‡ã£ãŸãã®å…ˆã«è¦‹ãŸã‚‚ã®ã¨ã¯ï¼Ÿã€ã§ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚è¬›æ¼”å†…å®¹ã‚’ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆã«ã—ã¾ã—
pero1 2015/02/09
postgresql
ãƒªãƒ³ã‚¯
SQLã®è¦³ç‚¹ã‹ã‚‰ã€ŒOracle Databaseã€ã€ŒPostgreSQLã€ ã€ŒMySQLã€ã®ç‰¹å¾´ã‚’æ•´ç†ã—ã‚ˆã†ï¼
EnterpriseZineï¼ˆã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¸ãƒ³ï¼‰ç·¨é›†éƒ¨ã§ã¯ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ‹…å½“ã®æ–¹ã€…å‘ã‘ã«ã€EnterpriseZine Dayã€Security Online Dayã€DataTechã¨ã„ã†ã€3ã¤ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¦ãŠã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œç·¨é›†éƒ¨ç‹¬è‡ªã®åˆ‡ã‚Šå£ã§ã€æ¥ç•Œãƒˆãƒ¬ãƒ³ãƒ‰ã‚„æœ€æ–°äº‹ä¾‹ã‚’ç¶²ç¾…ã€‚æœ€æ–°ã®å‹•å‘ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹å ´ã¨ã—ã¦ã€å¥½è©•ã‚’å¾—ã¦ã„ã¾ã™ã€‚
pero1 2014/10/07
db

mysql

postgresql
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“ã®ç¾…é‡ç›¤
PostgreSQLã®ãƒãƒ¼ãƒ«ç®¡ç†ã¨ãã®æ³¨æ„ç‚¹ï¼ˆOpen Source Conference 2022 Online/Osaka ç™ºè¡¨è³‡æ–™ï¼‰NTT DATA Techno logy & Innovation
pero1 2013/11/16
db

mysql

postgresql
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã€MariaDBã€PostgreSQLã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶/ã‚¨ã‚¯ã‚¼ã‚ãƒ¥ãƒ¼ã‚¿æ¯”è¼ƒ - interdbâ€™s blog
https://mariadb.com/kb/en/optimizer-switch/ã«ã‚ã‚‹ã‚ˆã†ã«ã€MariaDBã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã¯ã‹ãªã‚Šæ”¹è‰¯ã•ã‚Œã¦ã„ã‚‹ã€‚ ã§ã¯ã€MariaDBã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶/ã‚¨ã‚¯ã‚¼ã‚ãƒ¥ãƒ¼ã‚¿ã¯ã©ã®ç¨‹åº¦å„ªç§€ã‹ã€ï¼”ã¤ã®SELECTæ–‡ã®å®Ÿè¡Œã‚’é€šã—ã¦MySQLã¨(ã¤ã„ã§ã«PostgreSQLã¨)æ¯”è¼ƒã—ã¦ã¿ã‚‹ã€‚ (2014.12.3è¿½è¨˜ï¼šã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã«ã¤ã„ã¦ã¯çœç•¥ã—ã¦ã¾ã™ãŒã€ã“ã‚“ãªæœ¬ãŒã§ã¾ã™ã€‚) çµè«–ã‚’å…ˆã«ã„ãˆã°ã€ŒMySQLã¯æ¤œç´¢ãŒé€Ÿã„ã€ã¨ã„ã†ã®ã¯éƒ½å¸‚ä¼èª¬ã€‚MariaDBã¯ãŒã‚“ã°ã£ã¦ã‚‹ã‘ã©PostgreSQLã«ã¯ã¾ã ã¾ã åŠã°ãšã€‚ ï¼Šå¿µã®ãŸã‚ã€‚ã“ã‚Œã¯ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã˜ã‚ƒãªã„ã‚ˆã€ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶/ã‚¨ã‚¯ã‚¼ã‚ãƒ¥ãƒ¼ã‚¿ã®æ©Ÿèƒ½æ¯”è¼ƒã§ã™ã€‚ è‡ªåˆ†ã§å†ç¢ºèªã—ãŸã„å ´åˆã¯ã“ã¡ã‚‰ã«ã‚¹ã‚¯ãƒªãƒ—ãƒˆç¾¤ã¨å®Ÿé¨“ã®ã‚„ã‚Šæ–¹ã‚’ç°¡å˜ã«æ›¸ã„ãŸã®ã§å‚ç…§ã®ã“ã¨ã€‚ èª¿æŸ»ç’°å¢ƒ åŒä¸€ãƒžã‚·ãƒ³ã«MySQL5.6.14ã€MariaDB10.0.4ã€
pero1 2013/11/10
mysql

postgresql

mariadb
ãƒªãƒ³ã‚¯
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®æ¦‚è¦ã¨æ–¹å¼ä¸€è¦§ â€” Let's Postgres
NTT ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚»ãƒ³ã‚¿ éˆ´æœ¨ å¹¸å¸‚ æœ¬è¨˜äº‹ã§ã¯ã€PostgreSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢æ–¹æ³•ã‚’è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚ ä»Šå›žã¯ã€å„ç¨®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®æ¦‚è¦ã‚’èª¬æ˜Žã—ã€æ¬¡å›žä»¥é™ã§ãã‚Œãžã‚Œã®æ–¹æ³•ã®å…·ä½“çš„ãªæ‰‹é †ã‚’ç¤ºã—ã¦ã„ãã¾ã™ã€‚ ç”¨èªžã®æ•´ç† ã€Œãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€ã¨ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®éšœå®³ã«å‚™ãˆãŸã‚Šã€ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã®éš›ã«ãƒ‡ãƒ¼ã‚¿ã‚’ç§»è¡Œã™ã‚‹ãŸã‚ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã‚’åˆ¥ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«å–ã‚Šå‡ºã™ã“ã¨ã‚’ã„ã„ã¾ã™ã€‚ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’SQLã‚„ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦å–ã‚Šå‡ºã™ã€Œè«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãã®ã¾ã¾ä¿å˜ã™ã‚‹ã€Œç‰©ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€ãŒã‚ã‚Šã¾ã™ã€‚ è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã§ã¯ SQL ã®çµæžœã¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã®ã§ã€ã‚‚ã¡ã‚ã‚“ PostgreSQL ã‚µãƒ¼ãƒã¯å‹•ä½œã—ãŸã¾ã¾ã§ã™ã€‚ ä¸€æ–¹ã€ç‰©ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã§ã¯ã€ã‚µãƒ¼ãƒã‚’åœæ¢ã—ãŸçŠ¶æ…‹ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã†ã€Œã‚ªãƒ•ãƒ©ã‚¤ãƒ³ãƒ»ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€ã¨ã€ã‚µãƒ¼ãƒã‚’èµ·
pero1 2013/10/15
postgresql

db

backup

postgres
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
pero1 2012/09/14
db

postgresql
ãƒªãƒ³ã‚¯
PostgreSQLã«èˆˆå‘³ãŒã‚ã‚‹äººå‘ã‘ã«ã¾ã¨ã‚ã¦ã¿ãŸã€‚ï½œPostgreSQLï½œãŠä»•äº‹ãƒ¡ãƒ¢ï½œPictnotes
PostgreSQL9.2ãŒã§ãŸã®ã¨ã€ä¸€éƒ¨ã§ï¼Ÿã¾ãŸPostgreSQLã‚’ä½¿ã„ãŸã„ã¨æ€ã£ã¦ã‚‹äººãŒå¤šããªã£ãŸã¨ã‹ã‚ã‚‹ã¿ãŸã„ãªã®ã§ 4ã€œ5å¹´è§¦ã£ã¦ãªã‹ã£ãŸã‹ã€å…¨ç„¶çŸ¥ã‚‰ãªã„äººå‘ã‘ã¨ãŠã•ã‚‰ã„ã¨ã—ã¦ã¾ã¨ã‚ã¦ã¿ãŸã€‚ ã–ã£ãã‚Šæ›¸ã„ã¦ã‚‹ã®ã§ã€è©³ã—ã„äººã‹ã‚‰ã¿ã‚‹ã¨ãŠã‹ã—ã„ç‚¹ã‚‚ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ãŒã€æ°—ã«ãªã£ãŸç‚¹ã¯ã‚ˆã‚Šè©³ã—ã„è¨˜äº‹ãŒ ã‚ã‚‹ã¨æ€ã†ã®ã§ã€èª¿ã¹ã¦ã¿ã¦ãã ã•ã„ã€‚ æ˜Žã‚‰ã‹ãªé–“é•ãˆç‰ã€…ã¯ã€ä¿®æ£åŠ ç†ã—ãŸã„ã®ã§ã€ã‚³ãƒ¡ãƒ³ãƒˆã‹ twitterã® @itm_kiyoã¾ã§ã€å¾¡é¡˜ã„ã—ã¾ã™ã€‚ Q. ãªã‚“ã¦èªã‚€ã®ï¼Ÿæ›¸ãã®ï¼Ÿ A. PostgreSQL(ã½ã™ã¨ãã‚Œã™ãã‚…ãƒ¼ãˆã‚‹)ã€Pã¨SQLã¯å¤§æ–‡å—ã€‚ã¡ãªã¿ã«MySQL(yä»¥å¤–ã¯å¤§æ–‡å—)ãªã‚“ã§ã€å°æ–‡å—ã¨å¤§æ–‡å—ã®åŒºåˆ¥ã‚’ãã¡ã‚“ã¨ã™ã‚‹ã¨ãã®ç•Œéšˆã®äººãŒã‚ˆã‚ã“ã³ã¾ã™ã€‚ ã§ã‚‚ã€ã€Œpostgresã€ ã¨ã‹ ã€ã€ŒPostgresã€ã‚„ã€Œãƒã‚¹ã‚°ãƒ¬ã€ã¨ã‹æ›¸ã‹ã‚Œã¦ã‚‹ã“ã¨ã‚‚å¤šã„ã§ã™ã€‚ Q. ã©ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ã†ã®
pero1 2012/09/14
db

postgresql
ãƒªãƒ³ã‚¯
1