OSSã³ãã¥ããã£ã¨ã®å調
OSSã®ã³ãã¥ããã£ã®åå¦ã¨ä¼æ¥ã®åå¦ãã¾ã£ããå¥ã
ã®åå¦ã§åãã¦ããã®ã ããããããæãããã¨ã¯é£ããããã©ãã ããã¨è¨ã£ã¦ã¾ã£ããååã§ããªãã¨è¨ãããã§ããªãããã¶ã¼ã«ã®ãã£ãã®ä¸ã«ä¼æ¥ãå
¥ã£ã¦ãã¦ãæã¾ãããã¨ã¯ãªãã
OSSã®ã©ã®åéã®éçºãé²ãã§ãã©ã®åéã®éçºãé²ã¿ã«ããã®ãï¼
OSSã¯è¶£å³ã§ä½ã£ã¦ãããã ããå¥ã«éçºãé²ã¾ãªãããããå¿
è¦ã¨ãã¦ãã人ãå¿
è¦ã¨ãã¦ããã¨ãã«éçºããã°ããã®ã§ãã»ã£ã¨ãã¦ãããã¨ããç«å ´ãããããªãããªãããããããã®åéã誰ããéçºãã¦ãèªåã¯èå³ããªãã ãããéªéã«ã¯ãªãã¾ããã¨ããããããæ¶æ¥µçãªç«å ´ã«ãªã£ã¦ãã¾ãã®ã ãã©ããã®ã¹ã¿ã³ã¹ã§è©±ãé²ããã
ã«ã¼ãã«2.2ã®ããLinusã¯SMPãªãã¦èå³ããªãã®ã§ãããã人ããã£ã¦ããã¿ãããªãã¨ãè¨ã£ã¦ãããï¼å¤§æã®è©±ã§ãã¾ãï¼ã¹ã±ã¼ã©ããªãã£ãã©ãã ããã ã¨ããã®ã¯ãèªåã®ã¯ã¼ã¯ã¹ãã¼ã·ã§ã³ã§ã¯ããã¾ãé¢ä¿ãªãããã¼ãã¼åéã¯å¿
è¦ã¨ãã¦ããä¼æ¥ããããããéçºãã¦ãããã¿ãããªãã¨ã§ããã
å®éIBMãã¯ããã¨ãã大æãã¼ãã¦ã§ã¢ãã³ããLSE (Linux Scalability Effort) http://lse.sourceforge.net/ ã§ããããéçºããããä¼æ¥ã«ã¨ã£ã¦ã¯Linuxãã¹ã±ã¼ã©ããªãã£ã®å¿
è¦ãªåéã«æå
¥ãããã¨ã¯çµæ¸çãªã¤ã³ã»ã³ãã£ããããã®ã§èªç¤¾å
ã®OSå°é家ãå¤æ°æå
¥ãã¦Linuxéçºãå éãããè¯ãç¥ããã¦ããä¾ã§ããã°ãã«ã¼ãã«ã®ã°ãã¼ãã«ããã¯ãå¾¹åºçã«è¦ç´ãã¦ããç²åº¦ã®å°ããããã¯ã«ããããããã¯ãã®ãã®ããªãããããã¦ãããIOã¹ã±ã¸ã¥ã¼ãªã³ã°ã«ã¤ãã¦ãããããæ¹è¯ãéããããã®ãããªåéã¯ã³ãã¥ããã£ã¨è¨ãããä¼æ¥ã®å¾æã¨ãã¦ããã¨ããã§ããã
PostgreSQLã®ã«ã³ãã¡ã¬ã³ã¹ã«è¡ã£ã¦ãã³ã¢ã¡ã³ãã¼ã¨ã親ç¦ãæ·±ãããPostgreSQLã®å®è£
ãããããã®å人çãªå°è±¡ã§ã¯ãããã©ãã¡ã¢ãªã®ä½¿ãæ¹ã貧弱ãªæãããããshared_buffersã¨ãããã¼ã¿ãã¼ã¹ãµã¼ããå©ç¨ããå
±ç¨ã¡ã¢ãªãããã¡ã®ãµã¤ãºããã¦ããããã©ã¡ã¼ã¿ã®ããã©ã«ãå¤ãä½ããããã¨ãããããªäºãããã¼ã ãã¼ã è°è«ããããæè¿ã®ãµã¼ããªããã¯4GBãããå¹³æ°ã§ã¤ãã§ãããã ãããshared_buffersãªãã¦ãã©ã¡ã¼ã¿ãªããããå¿
è¦ãªãã§ããããããã ãã¡ã¢ãªã©ãã©ã使ããããªå®è£
ã«ããã¹ãã£ããããããã¼ãããã ã¼ã¢ã®æ³åã¤ãã®ã¯ã¡ã¢ãªãã³ã³ã¹ã¿ã³ãã«å®ããªãæ³åãªãã ãããã¡ã¢ãªããã£ã±ãç©ãã ã¨ããä¸åå®è£
ãå¤ããªãã§èªåçã«éããªããããªå®è£
ã«ããã¹ãã§ãããããã®ããã«shared_buffersã¿ãããªã¡ã¢ãªå©ç¨ãå¶éãããã©ã¡ã¼ã¿ã¯ãããã§ãããããããæå³ãªãããããã¼ãããã ã£ã¦ãããã§ããããæ§è½ã§ãªããããããã¡ã¢ãªã追å ããããã¡ã¢ãªå®ããã§ããããããã¼ããã§ãã³ã¢ãã¼ã ã®ã¡ã³ãã®PCã¯è²§å¼±ã ããããã¼ãã¼å®è£
ãããã¾ãè©ä¾¡ã§ããªããã§ããããã
ã¤ã¾ããã¼ãã¼åéã¯ä¼æ¥ãããã°ããã®ã§ããã
ä»ã¾ã§ã¯ãã³ãã¥ããã£ã¨ä¼æ¥ãç¸äºè£å®é¢ä¿ãæã£ã¦çºå±ãã¦ããã®ã§ãããä¼æ¥ã«ã¨ã£ã¦ãå¹çããéçºãé²ãã§å©çããã£ãã
ä¸æ¹ã§OSSãã®ãã®ã®ãã¼ã±ãã£ã³ã°ãªã©ã¯åç¨è£½åã§ã¯ãªã以ä¸èª°ããçµ±ä¸çãªã¤ã¡ã¼ã¸æ¦ç¥ããã£ã¦æ¨é²ããã¨ãããããªãã¨ã¯åççã«ä¸å¯è½ã§ãããä¸å¯è½ã§ã¯ãããå¿
è¦ã§ãªãã¨è¨ããã¨ã¯ãªããOSSã®ä¾¡å¤ãæ£ããå©ç¨è
ã«å±ããã¨è¨ãæå³ã§ã®ãã¼ã±ãã£ã³ã°æ´»åã¯å¿
è¦ã ã¨æããåã
ã®ä¼æ¥ãã°ãã°ãã«ãã£ã¦ããã¨ããã®ãéè¤ãçºçãå¹ççã§ã¯ãªããããã§æ¥çã§OSDLã®ãããªNPOãè¨ç«ãå
±éã®èª²é¡ã«ã¤ãã¦è°è«ã解決çãæ¢ãã¨è¨ããã¨ãéè¦ã«ãªã£ã¦ãããæå½ã§ã¯ãããæ¥æ¬OSSæ¨é²ãã©ã¼ã©ã ã¨ããç£å®å¦ã®ä»»æå£ä½ãè¡ã£ã¦ãããå¥ã«æ¥æ¬OSSæ¨é²ãã©ã¼ã©ã ã ãããã®ãããªæ´»åããã¦ããããã§ã¯ãªããæ¥æ¬Linuxåä¼ã¨ãä¼¼ããããªå£ä½ã¯ããã¤ãããã
ã³ãã¥ããã£ããè¦ãã°åæã«ãã£ã¦ãã¨ããæããããããªãããã¨ã³ã·ã¹ãã ã¨ãã¦ã価å¤ã®åµé ã®ãµã¤ã¯ã«ãå éãããã¨ã¯ã³ãã¥ããã£ã«ã¨ã£ã¦æªããã¨ã§ã¯ãªããä¸ã¤ã¯ãã¸ãã¹ã¨ãã¦æç¶å¯è½ãªãµã¤ã¯ã«ãçããã°ãä»ã¾ã§ä»äºã¨ãã¦è©ä¾¡ãããªãã£ããã®ããä»äºã¨ãã¦è©ä¾¡ãããããã«ãªããå¤ä¸ã®ããã¯ããæ¼éã®çµ¦ä¸ã稼ãæ段ã¨ãªããå¥ã«å¤ä¸ã«å¥½ããªãã¨ããã£ã¦ãããã§ããã§æºè¶³ã ã¨è¨ã人ã¯å¥ã«ããã§ããããã§ããã¼ãã¼äººãã¨ãããè¨ãã¤ããã¯ãªããèªåã®å¥½ããªãã¨ããã£ã¦çµ¦æãè²°ããã¨ãããã¨ã¯ãããã¨ã ã¨æãã®ã ãã©ãããã¯ã¾ã人ãããããªã®ã§æ·±ãã¯çªã£è¾¼ã¾ãªãã
OSSã®ä¾¡å¤ã課é¡ãæ´çãã¦æ
å ±ã¨ãã¦ä¼ããã¨è¨ãä½æ¥ã¯è¨ããã¨ã¯ç°¡åã ãå®éã¯ãªããªã大å¤ã§ãããä¾ãã°OSSãµãã¼ããã©ããªã£ã¦ãããã¨ãã©ã®ãããªèª²é¡ããããã¨ãã¯ãããã£ã¦ããããã§ãã¦å¤ãã®ã¦ã¼ã¶ã¼ã«ããããããå½¢ã§ç¤ºããã¦ããªãã£ãããããOSSãã®ãã®ã®éçºã®ä»çµã¿ã¨ãã³ãã¥ããã£ã¨ãã®åçãããç¨åº¦ç解ãã¦ããªãã¨ãµãã¼ããã©ã®ããã«ãªããããã¨ãããããªç¹ã«ã¤ãã¦ãç解ã¯é£ãããåOSSã®éçå¤ã§ã®æ§è½ã¨ãä¿¡é ¼æ§ãªã©ãå社ã°ãã°ãã®åºæºã§ãã£ã¦ããããããããã®ãããªä½æ¥ãå®ã®ã¨ããç¡é§ã§ããããçµ±ä¸çãªæé ããªãã®ã§ä»ç¤¾ãå®æ½ããè©ä¾¡ã¨æ¯è¼ãããã¨ãã§ããªãã£ãããããOSSãªãã ããè©ä¾¡æé ããã¼ã«ãªã©ãå
±éåããã°ç¡é§ãªä½æ¥ãæ¸ããã³ã¹ããä¸ããããã¦ãã¦ãå
±æã§ãã¦ã¿ããªã«å¾ã§ãããOSSã ããå調ããããã¨ãã話ã§ãããåç¨ã½ããã®å ´åããã³ããã¼ã¯çµæãå
±æãããªãã¦ãã¨ã¯ãé常ã¯ã©ã¤ã»ã³ã¹ä¸ç¦æ¢ããã¦ãããããã®ã§ãã»ã¨ãã©ä¸å¯è½ã§ããããã®ããããã³ãã¼æä¾ã®æ
å ±ãéµåã¿ã«ããããæ¹æ³ããªãã
OSSã ããããã§ããå調ã®ä»çµã¿ãæ§ç¯ãããã¨ãã¿ãªã«ã¨ã£ã¦å©çã«ãªãã¨ããæ§å³ã§ããã
PostgreSQL Conference 2006
PostgreSQL Conference 2006ã«è¡ã£ã¦æ¥ããéææ¥åææ¥ã¨2æ¥éè¡ãããã®ã ããéææ¥ã¯å¥ä»¶ããã£ãã®ã§åææ¥ã ãã®åå ã«ãªã£ããhttp://www.postgresql.jp/misc/seminar/2006-02-17_18/index.html
ç³äºããã®ããã¾ããèããªãããã¯ã¢ããã®åºæ¬ããéä¸ããèããããã¯ã¢ããã¯éè¦ãããã¯ã¢ããã®æé ãææ¸åããã®ã¯é常ã«éè¦ããã®æé æ¸ãå
ã«ä¸åº¦äºè¡æ¼ç¿ãããã®ã¯ãã£ã¨éè¦ãããã¯ã¢ããã§ãã¦ããæé ã©ãããªã¹ãã¢ã§ããªããã°å
¨ç¶æå³ããªãããããããã®ãããåã®ãã¨ããã£ã¦ããªãã¨è¨ãã®ãä¸ã®å¸¸ãªã®ã§ããã
ç岡ããã®ãSQLãã¥ã¼ãã³ã°ããåºæ¬çãªãã¨ãããããæãã¦ããã£ããè³æã¯ãã®ãã¡ãã¦ã¼ã¶ã¼ä¼ã®ãã¼ã ãã¼ã¸ã«ã¢ãããããããããæå¾
ãããã
大å£ããã®ãWebã¢ããªã±ã¼ã·ã§ã³æ»æã®å¾åã¨å¯¾çããé«æ©ã¡ã½ããããï¼ç¬ï¼ããããWebãµã¼ãã¹ãæä¾ããå´ã¯å¤§å¤ã§ããã
æ親ä¼ã
ãããããã¥ãç±ãèªããèªããèªããããããæ¥æ¬ã®PostgreSQLçéï¼ï¼ï¼ã¯ã©ãããªã¤ã¸åº¦é«ããªããè¥ã人ãå°ãªãã女åãããªããï¼ã©ã¼ãã¼ãã¨ã ï¼ãã¯ãRDBMSã¨ããå°å³ãªæè¡ã®éã¾ããªã®ã§ãããããéã¾ã£ã¦ããé£ä¸ãå°å³ããããLLçï¼ï¼ï¼ã®ããã«20代ãããããæ´»èºãã¦ããã¨è¨ãæãã§ããªãããã¯ãPHPã¦ã¼ã¶ã¼ä¼ãããã«é客ããé¡ãããããªã©ã¨ãã«è©±ã«è©±ãããããã
ããã¯ããã¨ãã¯ãã¯ã©ã¹ã¿ãã¡ã¤ã«ã·ã¹ãã ã ãããåæ£ããã¯ããã¼ã¸ã£ã ããããå©ç¨ãã¦ã¯ã©ã¹ã¿ã®å®è£
æ±ãã¨è¥è
ã«ã¯ã£ã±ããããã
å®´ä¼ã®ã¨ãã¾ã¨ããç²ãæ§ã§ããï¼æ°¸å®ããã