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

celitan id:celitan

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

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

ã¨ã‚ã‚‹ã‚¯ã‚¨ãƒªã‚’2ä¸‡å€é€Ÿã«ã—ãŸè©± -ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ°—æŒã¡ã«ãªã‚‹- å¾Œç·¨ - dwango on GitHub
æŠ€è¡“ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³å®¤ OSSã‚°ãƒ«ãƒ¼ãƒ—ã®é«™ï¨‘ã§ã™ã€‚ æœ¬è¨˜äº‹ã¯ã€ã¨ã‚ã‚‹ã‚¯ã‚¨ãƒªã‚’2ä¸‡å€é€Ÿã«ã—ãŸè©± -ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ°—æŒã¡ã«ãªã‚‹- å‰ç·¨ã®ç¶šãã§ã™ã€‚ å‰å›žã®è¨˜äº‹ã§ãŠè©±ã—ã—ãŸå†…å®¹ãŒPullRequestã‚’ä½œã£ãŸã¨ãã®éŽç¨‹ã ã£ãŸã‚ã‘ã§ã™ãŒã€ ãã®ã‚ˆã†ãªçµæžœã«è‡³ã£ãŸçµŒç·¯ã€Index Only Scanã‚’ä½¿ã‚ãªã‹ã£ãŸPostgreSQLç‰¹æœ‰ã®äº‹æƒ…ã«ã¤ã„ã¦ã€ PostgreSQLã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãªã©ã‚‚äº¤ãˆã‚‚ã†å°‘ã—è©³ã—ããŠè©±ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ è¦ã™ã‚‹ã« å®Ÿè¡Œè¨ˆç”»ã®ã‚³ã‚¹ãƒˆã¨ã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚„indexã®èªã¿è¾¼ã¿ã€ãƒ•ã‚£ãƒ«ã‚¿å‡¦ç†ãªã©ã‹ã‚‰ãã®å®Ÿè¡Œã«ã©ã®ç¨‹åº¦ã®æ™‚é–“ãŒå¿…è¦ã¨ãªã‚‹ã‹ã®æŽ¨å®šå€¤ indexã‚’å¼µã‚‹éš›ã«ã¯ãã®indexãŒã©ã®ã‚ˆã†ã«è¾¿ã‚‰ã‚Œã‚‹ã‹ã‚’æ„è˜ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ ç¯„å›²æ¤œç´¢ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã‚«ãƒ©ãƒ ã¯indexã®å…ˆé ã«ã¯ã‚ã¾ã‚Šé©ã•ãªã„ PostgreSQLã«ãŠã‘ã‚‹Index Only Scanã¯æ–°ã—ã„/æ›´æ–°é »åº¦ã®é«˜ã„ãƒ‡ãƒ¼
celitan 2018/01/20
postgresql
ãƒªãƒ³ã‚¯
ã¨ã‚ã‚‹ã‚¯ã‚¨ãƒªã‚’2ä¸‡å€é€Ÿã«ã—ãŸè©± -ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ°—æŒã¡ã«ãªã‚‹- å‰ç·¨ - dwango on GitHub
æŠ€è¡“ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³å®¤ OSSã‚°ãƒ«ãƒ¼ãƒ—ã®é«™ï¨‘ã§ã™ã€‚ å½“ã‚°ãƒ«ãƒ¼ãƒ—ã§ã¯ã€ãƒžã‚¹ãƒˆãƒ‰ãƒ³ã¨ã„ã†ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®åˆ†æ•£åž‹ãƒžã‚¤ã‚¯ãƒãƒ–ãƒã‚°ã«ã¤ã„ã¦ã€ å¼Šç¤¾ãŒé‹å–¶ã™ã‚‹ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã€Œfriends.nicoã€ã®é‹å–¶ã€ç‹¬è‡ªæ©Ÿèƒ½ã®é–‹ç™ºã€é‹ç”¨ã€ãªã‚‰ã³ã«ãã‚Œã‚‰ã§å¾—ãŸçŸ¥è¦‹ã‚’ä¸Šæµã®ãƒ—ãƒ¬ãƒ¼ãƒ³ãªãƒžã‚¹ãƒˆãƒ‰ãƒ³ã¸contributeã™ã‚‹ã¨ã„ã†æ¥å‹™ã‚’ä¸»ã«è¡Œã£ã¦ã„ã¾ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ã€tableã«é©åˆ‡ãªindexã‚’å¼µã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã¨ã‚ã‚‹ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã®é€Ÿåº¦æ”¹å–„ã‚’è¡Œã£ãŸäº‹ä¾‹ã«ã¤ã„ã¦ã€å®Ÿéš›ã«ä¸Šæµã¸è¡Œã£ãŸPullRequestã‚’ãƒ™ãƒ¼ã‚¹ã«ãŠè©±ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ å†…å®¹ã¨ã—ã¦ã¯åé¢æ•™å¸«ã¨ã™ã‚‹ã¹ãå¤±æ•—ä¾‹ã‚’ä¼´ã£ãŸã€éžå¸¸ã«åŸºç¤Žçš„ãªPostgreSQLã®å®Ÿè¡Œè¨ˆç”»ã®èªã¿æ–¹ãªã‚‰ã³ã«ã‚¯ã‚¨ãƒªã«åˆã‚ã›ãŸindexã®å¼µã‚Šæ–¹ã§ã™ã€‚ ã¾ãŸã€è¡¨é¡Œã®2ä¸‡å€é€Ÿã¨ã„ã†ã®ã¯æ”¹å–„å‰ã®æœ€æ‚ªã®å ´åˆæ¯”ã§ã‚ã‚Šå˜˜ã§ã¯ãªã„ã‚‚ã®ã®ã€é€šå¸¸å•ã„åˆã‚ã›ã•ã‚Œã‚‹ç¯„å›²ã®æ¡ä»¶ã§ã¯ã ã„ãŸã„3ã€œ30å€é€Ÿã§ã‚ã‚‹ã¨ã„ã†
celitan 2018/01/18
postgresql
ãƒªãƒ³ã‚¯
PostgreSQLæŠ€è¡“è€…ã‚’èªå®šã€LPI-JapanãŒã€ŒOSS-DBæŠ€è¡“è€…èªå®šè©¦é¨“ã€é–‹å§‹
Linux æŠ€è¡“è€…èªå®šæ©Ÿé–¢ã®ã‚¨ãƒ«ãƒ”ãƒ¼ã‚¢ã‚¤ã‚¸ãƒ£ãƒ‘ãƒ³ï¼ˆLPI-Japanï¼‰ã¯2011å¹´6æœˆ8æ—¥ã€ã€Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“è€…èªå®šè©¦é¨“ï¼ˆOSS-DB Examï¼‰ã€ã‚’7æœˆ1æ—¥ã‹ã‚‰é–‹å§‹ã™ã‚‹ã¨ç™ºè¡¨ã—ãŸã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆOSS-DBï¼‰ã‚½ãƒ•ãƒˆã€ŒPostgreSQLã€ã«é–¢ã™ã‚‹çŸ¥è˜ã¨ã‚¹ã‚ãƒ«ã‚’å‚™ãˆãŸæŠ€è¡“è€…ã‚’èªå®šã™ã‚‹ã€‚ä¸–ç•Œå…±é€šã®èªå®šåˆ¶åº¦ã§ã‚ã‚‹Linux æŠ€è¡“è€…èªå®šè©¦é¨“ã¨ã¯ç•°ãªã‚Šã€LPI-JapanãŒç‹¬è‡ªã«å®Ÿæ–½ã™ã‚‹è©¦é¨“ã§ã‚ã‚‹ã€‚ ä¸»ãªOSS-DBã«ã¯ã€PostgreSQLã¨ç±³Oracleã®MySQLãŒã‚ã‚‹ãŒã€ã€Œç‰¹å®šãƒ™ãƒ³ãƒ€ãƒ¼ã®ç®¡ç†ä¸‹ã«ã‚ã‚‹ã‚½ãƒ•ãƒˆã¯çœŸã®OSSã¨ã¯è¨€ãˆãªã„ã€ï¼ˆLPI-Japanã®æˆäº•å¼¦ç†äº‹é•·ã€å†™çœŸï¼‰ã¨ã—ã¦ã€ä»Šå›žã‚¹ã‚¿ãƒ¼ãƒˆã™ã‚‹OSS-DB Examã§ã¯PostgreSQLã®ã¿ã‚’å¯¾è±¡ã¨ã—ãŸã€‚ã€ŒãŸã ã—ã€æˆ‘ã€…ã¯PostgreSQLã¨Oracle Databaseã¯ç«¶åˆã™ã‚‹ã‚‚ã®ã§ã¯ãªãè£œå®Œé–¢ä¿‚ã«ã‚ã‚‹ã¨è€ƒ
celitan 2011/06/12
ã€Œç‰¹å®šãƒ™ãƒ³ãƒ€ãƒ¼ã®ç®¡ç†ä¸‹ã«ã‚ã‚‹ã‚½ãƒ•ãƒˆã¯çœŸã®OSSã¨ã¯è¨€ãˆãªã„ã€ã£ã¦ã©ã†ã„ã†ã“ã¨ï¼Ÿã‚“ï¼Ÿpostgresqlä»¥å¤–ã«ã‚‚OSSã®DBã‚ã‚‹ã˜ã‚ƒã‚“

postgresql

oss
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼†ãƒªã‚¹ãƒˆã‚¢æ‰‹æ³•ãã®1
PostgreSQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼†ãƒªã‚¹ãƒˆã‚¢æ‰‹æ³•ãã®1ï¼šä½¿ãˆã°åˆ†ã‹ã‚‹PostgreSQLé‹ç”¨ï¼†ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼ˆ4ï¼‰ï¼ˆ2/3 ãƒšãƒ¼ã‚¸ï¼‰ pg_dumpã®å‡ºåŠ›å½¢å¼ å‡ºåŠ›å½¢å¼ã¯ã‚¹ã‚¯ãƒªãƒ—ãƒˆå½¢å¼ã¨ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–å½¢å¼ãŒé¸æŠžã§ãã¾ã™ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ã‚¹ã‚¯ãƒªãƒ—ãƒˆå½¢å¼ã§ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ™‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¾©å…ƒã™ã‚‹ãŸã‚ã«å¿…è¦ãªSQLæ–‡ã®ç¾…åˆ—ãŒãƒ—ãƒ¬ãƒ¼ãƒ³ãƒ†ã‚ã‚¹ãƒˆã®å½¢ã§å‡ºåŠ›ã•ã‚Œã¾ã™ã€‚ãƒªã‚¹ãƒˆã‚¢ã¯psql ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ã‚¹ã‚¯ãƒªãƒ—ãƒˆå½¢å¼ã®åˆ©ç‚¹ã¯ã€ãªã‚“ã¨ã„ã£ã¦ã‚‚ãƒ—ãƒ¬ãƒ¼ãƒ³ãƒ†ã‚ã‚¹ãƒˆã¨ã„ã†ç‚¹ã§ã™ã€‚ä¾‹ãˆã°ã€ãƒªã‚¹ãƒˆã‚¢ã®éš›ã«ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ãŸå ´åˆã€ãƒ•ã‚¡ã‚¤ãƒ«ã®ä¸èº«ã‚’è¦‹ã¦ã‚¨ãƒ©ãƒ¼ã®åŽŸå› ã‚’æŽ¢ã‚‹ã“ã¨ãŒã§ãã¾ã™ã—ã€PostgreSQLå›ºæœ‰ã®SQLæ–‡ã‚’å¤šå°‘ç·¨é›†ã™ã‚Œã°ã€ã»ã‹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã«ã‚‚ãƒªã‚¹ãƒˆã‚¢ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ä¸€æ–¹ã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–å½¢å¼ã¯ãƒã‚¤ãƒŠãƒªã®å½¢ã§å‡ºåŠ›ã•ã‚Œã¾ã™ã€‚ãƒªã‚¹ãƒˆã‚¢ã¯psqlã§ã¯ãªãã€pg_restore ã¨ã„ã†ãƒªã‚¹ãƒˆã‚¢ç”¨ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—
celitan 2011/04/29
å¿˜ã‚Œã‚‹ã®ã§ãƒ¡ãƒ¢

postgresql
ãƒªãƒ³ã‚¯
DBã®ã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã€ãŒå¿…è¦ãªç†ç”±ã€€ ï¼ˆPostgreSQLã§ï¼Œãƒ•ã‚¡ãƒ³ãƒˆãƒ ãƒ»ãƒªãƒ¼ãƒ‰ã‚’é˜²æ¢ã™ã¹ãã‚µãƒ³ãƒ—ãƒ«äº‹ä¾‹ï¼‰ - ä¸»ã«è¨€èªžã¨ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«é–¢ã—ã¦
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ï¼Œã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã€ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚ ä»¥ä¸‹ã§ã¯ï¼Œãã‚ŒãŒ ãªãœå¿…è¦ãªã®ã‹ï¼Ÿ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒ¬ãƒ™ãƒ«ã§ã¯ï¼Œã©ã†ã—ã¦é§„ç›®ãªã®ã‹ï¼Ÿ PostgreSQLã§ã¯ï¼Œã©ã†ã‚„ã£ã¦ãƒ¬ãƒ™ãƒ«ã‚’å¤‰æ›´ãƒ»ç¢ºèªã™ã‚‹ã®ã‹ï¼Ÿ ãªã©ã‚’å–ã‚Šä¸Šã’ã‚‹ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ« ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã¨ã¯ï¼š è¤‡æ•°ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒåŒæ™‚ã«å®Ÿè¡Œã•ã‚ŒãŸå ´åˆã«ã€ä»–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®å½±éŸ¿ãŒã©ã®ãã‚‰ã„ã€Œåˆ†é›¢ã€ã™ã‚‹ã‹ï¼Œã®ãƒ¬ãƒ™ãƒ«ã€‚ ANSIè¦æ ¼ã§ã¯ï¼Œï¼”ã¤ã®ãƒ¬ãƒ™ãƒ«ãŒã‚ã‚‹ã€‚ READ UNCOMMITTED ï¼ˆä¸€ç•ªä½Žã„ï¼‰ READ COMMITTED REPEATABLE READ SERIALIZABLEï¼ˆä¸€ç•ªé«˜ã„ï¼‰ å¾¹åº•æ¯”è¼ƒ!! PostgreSQL vs MySQLã€€ç¬¬ï¼“å›žï¼šãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®æ¯”è¼ƒ http://thinkit.co.jp/free/article/060... ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã«è©³ã—ã
celitan 2011/01/05
postgresql

ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢
Postgresãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã™ã¹ã¦ã®è²´é‡ãªãƒ‡ãƒ¼ã‚¿ã¯ã€ å®šæœŸçš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã® æ‰‹é †ã¯ç°¡å˜ã§ã™ãŒã€ãã®ä¸‹ã«ã‚ã‚‹ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚„æ¦‚å¿µãªã©ã‚’ç†è§£ã™ã‚‹ å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ Postgres ã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã†ãŸã‚ã« 2ã¤ã®æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ SQL dump ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ãƒ¬ãƒ™ãƒ«ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— 8.1. SQL Dump ã“ã®æ–¹æ³•ã®èƒŒå¾Œã«ã¯ã€SQLã‚³ãƒžãƒ³ãƒ‰ç¾¤ãŒæ›¸ã‹ã‚ŒãŸãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”Ÿæˆã—ã€ ã‚µãƒ¼ãƒã«ãã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã¾ã›ãŸã‚‰ã€ãƒ€ãƒ³ãƒ—ã•ã‚ŒãŸæ™‚ã¨åŒã˜ çŠ¶æ…‹ã‚’å†æ§‹ç¯‰ã™ã‚‹ã€ã¨è¨€ã£ãŸã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ãŸã‚ã€ Postgresã«ã¯ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ãƒ—ãƒã‚°ãƒ©ãƒ ã¨ã—ã¦ pg_dumpã‚’æä¾›ã—ã¦ã„ã¾ã™ã€‚ã“ã®ã‚³ãƒžãƒ³ãƒ‰ã® ä¸€èˆ¬çš„ãªä½¿ç”¨æ–¹æ³•ã¯ä¸‹è¨˜ã®é€šã‚Šã§ã™ã€‚ pg_dump dbname > outfile ãŠåˆ†ã‹ã‚Šé ‚ã‘ã‚‹ã‚ˆã†ã«ã€pg_dumpã¯çµæžœã‚’æ¨™æº–å‡ºåŠ›ã« æ›¸ãå‡ºã—ã¾
celitan 2009/12/14
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€ãƒªã‚¹ãƒˆã‚¢æ‰‹é †

postgresql

tips
ãƒªãƒ³ã‚¯
1