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

nikkoro id:nikkoro

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

${{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ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºåˆ©ç”¨ã®æŒ‡é‡ãŒç¶šã€…å…¬é–‹ã¸ï¼šDatabase Watchï¼ˆ2013å¹´5æœˆç‰ˆï¼‰ï¼ˆ1/2 ãƒšãƒ¼ã‚¸ï¼‰ OSSãªãŒã‚‰ã€å …ç‰¢æ€§ã‚„ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®é¢ã‹ã‚‰ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºç”¨é€”ã§ã‚‚æŽ¡ç”¨ã•ã‚Œã‚‹ã“ã¨ã®å¤šã„PostgreSQLã€‚å¤§è¦æ¨¡é‹ç”¨ã®ãŸã‚ã®æŒ‡é‡ã‚„ç§»è¡Œã®ãƒŽã‚¦ãƒã‚¦ã‚’å…¬é–‹ã™ã‚‹å‹•ããŒæ´»ç™ºåŒ–ã—ã¦ã„ã¾ã™ã€‚ä»Šå›žã¯PGECã®æ´»å‹•æˆæžœã‚’ã‚¦ã‚©ãƒƒãƒï¼ 4æœˆ22æ—¥ã€PostgreSQLã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºãƒ»ã‚³ãƒ³ã‚½ãƒ¼ã‚·ã‚¢ãƒ ï¼ˆä»¥ä¸‹ã€PGECï¼‰ã¯è¨ç«‹1å‘¨å¹´ã‚’è¿Žãˆã‚‹ã¨ã¨ã‚‚ã«ã€2012å¹´åº¦ã®æ´»å‹•æˆæžœã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚æ´»å‹•æˆæžœã¯æ€§èƒ½WGã¨è¨è¨ˆé‹ç”¨WGã‹ã‚‰å ±å‘Šã•ã‚Œã€å ±å‘Šæ›¸ã¯åŒä¼šã‚µã‚¤ãƒˆã«ã¦å…¬é–‹ï¼ˆãƒªãƒ³ã‚¯ï¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ã„ãšã‚Œã‚‚ä¼æ¥ã¸ã®PostgreSQLå°Žå…¥ã§ç›´é¢ã™ã‚‹ç–‘å•ã‚’ãƒ†ãƒ¼ãƒžã¨ã—ã¦ãŠã‚Šã€ã¨ã¦ã‚‚å®Ÿè·µçš„ãªå†…å®¹ã¨ãªã£ã¦ã„ã¾ã™ã€‚ æ€§èƒ½WGï¼šã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ãƒƒãƒ—ã¨ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆæ¤œè¨¼çµæžœ æ€§èƒ½WGã‹ã‚‰ã¯å¤§è¦æ¨¡é‹ç”¨ã‚’æƒ³å®šã—ã€Postg
nikkoro 2013/05/22
postgresql
ãƒªãƒ³ã‚¯
Scaling PostgreSQL With GridSQL
GridSQL is an open source distributed database built on PostgreSQL that allows it to scale horizontally across multiple servers by partitioning and distributing data and queries. It provides significantly improved performance over a single PostgreSQL instance for large datasets and queries by parallelizing processing across nodes. However, it has some limitations compared to PostgreSQL such as lac
nikkoro 2012/11/30
postgresql
ãƒªãƒ³ã‚¯
PostgreSQLã‚¯ãƒ©ã‚¹ã‚¿ã®å‹•å‘
ã“ã®ã‚ˆã†ã«ã€PostgreSQLã®ã‚¯ãƒ©ã‚¹ã‚¿ã¯ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½œæˆæ©Ÿèƒ½ã‚’ä¸å¿ƒã«é€²ã‚ã‚‰ã‚Œã¦ãã¾ã—ãŸã€‚ã¨ã“ã‚ãŒã€ã“ã®ç”¨é€”ä»¥å¤–ã«ã‚‚ã€ä¸¦åˆ—å‡¦ç†ã‚’ç”¨ã„ãŸå¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿è§£æžãŒå¯èƒ½ãªã€ŒGreenplumã€ã‚„ã€ŒGridSQLã€ãªã©ã®ã‚½ãƒ•ãƒˆã‚‚å‡ºç¾ã—ã¾ã—ãŸã€‚ Slonyã ã‘ã§ã¯ã€æ•°ã‚ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¦ä»¶ã‚’ã™ã¹ã¦æº€ãŸã™ã“ã¨ã¯ã§ãã¾ã›ã‚“ã€‚ã“ã®ãŸã‚ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¦æ±‚ä»•æ§˜ã«å¿œã˜ã¦ã€å¤šãã®PostgreSQLã‚¯ãƒ©ã‚¹ã‚¿ãŒé–‹ç™ºã•ã‚Œã¾ã—ãŸã€‚ä¸»ãªPostgreSQLã‚¯ãƒ©ã‚¹ã‚¿ã¯ã€è¡¨1ã®é€šã‚Šã§ã™ã€‚ è¡¨1: ä¸»ãªPostgreSQLã‚¯ãƒ©ã‚¹ã‚¿ ï¼ˆè©³ç´°ã¯http://wiki.postgresql.org/wiki/Clusteringã‚’å‚ç…§ï¼‰ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ æ¦‚è¦
nikkoro 2012/11/30
postgresql
ãƒªãƒ³ã‚¯
ã€ŒPostgreSQL 9.2ã€ãƒªãƒªãƒ¼ã‚¹ã€å¤§å¹…ãªæ€§èƒ½ã‚¢ãƒƒãƒ—ã‚’å®Ÿç¾ ï¼ ï¼ IT
2012/09/11 ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹PostgreSQLã®é–‹ç™ºã‚°ãƒ«ãƒ¼ãƒ—ã¯9æœˆ10æ—¥ã€æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã€ŒPostgreSQL 9.2ã€ã®ãƒªãƒªãƒ¼ã‚¹ã‚’ç™ºè¡¨ã—ãŸã€‚ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã€æŸ”è»Ÿæ€§ã®å¤§å¹…ãªå‘ä¸Šã‚’å®Ÿç¾ã—ãŸã¨ã—ã¦ã„ã‚‹ã€‚ ç™ºè¡¨ã«ã‚ˆã‚‹ã¨ã€PostgreSQL 9.2ã§ã¯JSONã‚’ãƒã‚¤ãƒ†ã‚£ãƒ–ã‚µãƒãƒ¼ãƒˆã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ©Ÿèƒ½ã‚’å¼·åŒ–ã€‚64ã‚³ã‚¢ã¾ã§ã®ãƒªãƒ‹ã‚¢ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã€Index-onlyã‚¹ã‚ãƒ£ãƒ³ã€CPUæ¶ˆè²»é›»åŠ›å‰Šæ¸›ãªã©ã‚’å®Ÿç¾ã—ãŸã€‚ ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®å‘ä¸Šã«ã‚ˆã£ã¦å¤§åž‹ã‚µãƒ¼ãƒã®ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ãƒªã‚½ãƒ¼ã‚¹ã‚’åŠ¹çŽ‡çš„ã«æ´»ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã€ãƒãƒƒã‚¯ç®¡ç†ã‚„Index-onlyã‚¢ã‚¯ã‚»ã‚¹ãªã©ã®æ€§èƒ½æ”¹å–„ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã§ã•ã‚‰ã«å¤§é‡ã®å‡¦ç†ã‚’è¡Œã†ã“ã¨ãŒå¯èƒ½ã«ãªã£ãŸã€‚ å…·ä½“çš„ã«ã¯ã€æœ€å¤§ã§æ¯Žç§’35ä¸‡ä»¶ã®ãƒªãƒ¼ãƒ‰ã‚¯ã‚¨ãƒªï¼ˆå¾“æ¥ã®4å€å¼·ï¼‰ã€ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã‚¯ã‚¨ãƒªã®Index-onlyã‚¹ã‚ãƒ£
nikkoro 2012/11/13
postgresql
ãƒªãƒ³ã‚¯
News Release PostgreXC
nikkoro 2010/05/26
postgresql

cloud computing
ãƒªãƒ³ã‚¯
PostgreSQLã®æ©Ÿèƒ½ã¨ä»–ã®RDBMSã®æ¯”è¼ƒ | Let's POSTGRES
å…¨ã¦ã®æ©Ÿèƒ½ã‚’ç¶²ç¾…ã—ãŸè¡¨ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€PostgreSQLãŒ Oracle Database ã¨åŒæ§˜ã®æ©Ÿèƒ½ãŒã‚ã‚‹ã“ã¨ãŒãŠåˆ†ã‹ã‚Šã„ãŸã ã‘ã‚‹ã§ã—ã‚‡ã†ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ãªã©ã¯ã€PostgreSQL æœ¬ä½“ã¨ã¯åˆ¥ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã‚‹ã‚µãƒ¼ãƒ‰ãƒ‘ãƒ¼ãƒ†ã‚£ãƒ¼ã§ã®æä¾›ã¨ãªã‚Šã¾ã™ãŒã€pgpool-II, Slony-I ã‚’ã¯ã˜ã‚ã¨ã—ãŸå®Ÿç¸¾ã‚‚è±Šå¯Œãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒæä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ PostgreSQLãŒç‰¹ã«å¼·ã¿ã‚’ç™ºæ®ã™ã‚‹åˆ†é‡Žã¨ã—ã¦ã€æœ€å¾Œã®è¡Œã«è¨˜è¼‰ã—ãŸGIS (åœ°ç†æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ) ãŒã‚ã‚Šã¾ã™ã€‚GISã¯ä½ç½®ã«é–¢ã™ã‚‹æƒ…å ±ã‚’æŒã£ãŸãƒ‡ãƒ¼ã‚¿ (ç©ºé–“ãƒ‡ãƒ¼ã‚¿) ã‚’ç®¡ç†ã—ã€ä¸»ã«åœ°å›³ã¨çµ„ã¿åˆã‚ã›ã¦ä½ç½®ã‚’è¡¨ç¤ºã€æ¤œç´¢ã€åˆ†æžã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã§ã™ã€‚PostgreSQLã§ã¯ã€PostGIS ã¨ã„ã†ã‚µãƒ¼ãƒ‰ãƒ‘ãƒ¼ãƒ†ã‚£ãƒ¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã€GISã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ ¼ç´ã—ç©ºé–“ãƒ‡ãƒ¼ã‚¿ã«é©ã—ãŸæ¤œç´¢ã‚’è¡Œã†ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã€GISã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’è§£æžã™
nikkoro 2009/10/29
postgresql
ãƒªãƒ³ã‚¯
PostgreSQLã‚’é…ãã—ã¦ã„ã‚‹çŠ¯äººã¯ã©ã“ã ï¼Ÿ
ã“ã‚Œã«ã‚ˆã‚Šã€3ç§’ä»¥ä¸Šã®æ™‚é–“ãŒã‹ã‹ã‚‹SQLã‚’ã‚ãƒ£ãƒ—ãƒãƒ£ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãŸã ã—ã€ã‚‚ã—å®Ÿè¡Œã•ã‚ŒãŸSQLã®ã»ã¨ã‚“ã©ã§ã“ã®è¨å®šå€¤ä»¥ä¸Šã®æ™‚é–“ãŒã‹ã‹ã‚‹å ´åˆã€ãƒã‚°ã¸ã®å‡ºåŠ›è‡ªèº«ãŒã‚ªãƒ¼ãƒãƒ˜ãƒƒãƒ‰ã¨ãªã‚Šã€ã‹ãˆã£ã¦æ€§èƒ½åŠ£åŒ–ã®å¼•ãé‡‘ã¨ãªã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã®ã§ã€å€¤ã®è¨å®šã«ã¯é…æ…®ãŒå¿…è¦ã§ã™ã€‚é€šå¸¸é‹ç”¨ä¸ã¯ã€10sã‚„20sã¨ã„ã£ãŸã€æ£å¸¸çŠ¶æ…‹ã§ã¯ãŸã©ã‚Šç€ã‹ãªã„ç¨‹åº¦ã®å€¤ã‚’è¨å®šã—ã¦ãŠãã“ã¨ã‚’ãŠå‹§ã‚ã—ã¾ã™ã€‚ ä»Šå›žã€ã“ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’è¨å®šã—ãŸã†ãˆã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿè¡Œã•ã›ã‚‹ã¨ã€ä»¥ä¸‹ã®ã‚ˆã†ãªå‡ºåŠ›çµæžœã‚’å¾—ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ LOG: duration: 9094.865 ms statement: SELECT c_fname, c_lname, c_phone, c_em ail, o_id, o_date, o_sub_total, o_tax, o_total, o_status, cx_type, cx_auth_id FR
nikkoro 2009/05/30
postgresql
ãƒªãƒ³ã‚¯
1