Google Cloud Platform Advent Calendar 2014ã®12æ¥ç®ã®è¨äºã§ãã 1ãæã»ã©åã«Betaçããªãªã¼ã¹ãããGoogle Compute Engine (GCE)ã®Local SSDã試ãã¦ã¿ãã®ã§ããã£ããã¬ãã¼ããããã Local SSDã£ã¦ä½ï¼ GCEã§ã¯ããã¾ã§ãPersistent Diskã¨ãããããã¯ã¼ã¯ ãã£ã¹ã¯ã®ã¿ãæä¾ããã¦ããããã¼ãããã¼ã¿ãPDã ãã§ã¾ããªããã¦ãããPDä¸ã®ãã¼ã¿ã¯ãã¹ã¦åé·åããã¦ããã®ã§ãä¸è¬çãªåä½ãã£ã¹ã¯ãããé«ãå¯ç¨æ§ãæä¾ããã ä¸æ¹ã§ãå¯ç¨æ§ã¯æ®éã§ããã®ã§ã¨ãããé«ã帯åã¨IOPSå¤ããã¨ãããã¼ãºã«å¿ããã¹ãæ°ãã«æä¾ãããã®ãLocal SSDã ãç¹é·ãã¾ã¨ããã¨ã 375GB SSDã1 VMãããæ大4å°ã¾ã§è£ çå¯è½ 4å°ä½¿ç¨æã¯680K IOPS (4K random read)
å ¨ææ¤ç´¢ã®é度è¨æ¸¬ãããéã«æ¡ç¨ããããæ¹ãã¡ã¢ãã¦ããã ã¨ããããDebian Squeezeã§ãã£ããã¡ããã¨åããã sudo service postgresql stop sudo su - -c "echo 3 > /proc/sys/vm/drop_caches" sudo service postgresql start ãã®å¾ã«psqlã¨ãã§SQLå®è¡ããã°OKã 2è¡ç®ã§ããããsuã³ãã³ããå©ãã¦ããã®ã¯ãsudoã§ç´æ¥å®è¡ãã¦ãä¸æããããªãã£ãã®ã§ã æ£ç´ãªã«ãã£ã¦ããã®ãããããªããã©ããã¡ããã¨ãã£ãã·ã¥ãã¯ãªã¢ããã¦ããæ§ãªçµæã«ãªã£ãã®ã§è¯ãã¨ããã åèãµã¤ã [pgsql-jp: 40643] Re: PostgreSQLãã£ãã·ã¥ã¯ãªã¢æ¹æ³ã«ã¤ãã¦ã質å
ããã«ã¡ã¯èç´ã§ãã -ç®æ¬¡- 100åã§ããã¤ãã®URLãã¾ã¨ãããã¦ãã»ãã®äººã«75åã§ããããªã©ã¤ããããï¼? ã¾ã å°ããã®ã§å¼ç¨ãã¾ãã ããªãããä¾é ¼ãã¦æçµçã«è²¬ä»»ãç¡ãã£ã¦â¦ ç¡è²¬ä»»ãããªãã§ããï¼ ãã¯ã»ã»å¼ç¨ããå ã«å¯¾ãã¦ã失礼極ã¾ããªãã§ãã èç´çã¾ã¨ã ã追è¨ããã¥ã¬ã¼ã·ã§ã³ã¡ãã£ã¢ééå¾ã«ã¤ã㦠ã追è¨ãBUZZNEWSã®æ¡ç¨è ã®ååãå²ãå§ãã¦ãã¾ãã ã追è¨ããªã©ã¤ããæ¨å¥¨ãã¦ããã¯ã©ã¦ãã¯ã¼ã¯ã¹ãã©ã³ãµã¼ãºã«ã¤ã㦠----------------------------- æè¿è©±é¡ã«ãªã£ã¦ããã¥ã¬ã¼ã·ã§ã³ã¡ãã£ã¢ã ç§ãã¦ã§ãã®ã³ã³ãµã«ããã£ã¦ãã®ã§ãããæ¥ã ã¯ã©ã¤ã¢ã³ãæ§ã«æããã¦ã¾ãã ãæãç©é¡ã§ãã社ã®1次æ å ±ããã¯ãã®ã¯ã©ãã«ããªããã®ãï¼ãããæ¤ç´¢ã§æããã¦ããï¼ã 㨠æè¿ãã®ãã¥ã¬ã¼ã·ã§ã³ã¡ãã£ã¢ããã¯ãããªã©ã¤ãããããããªãæã®è¾¼ãã å¼
ã¡ãããã§ãã gamy.jp åæ¥ã¯ã第ä¸åFRESH!æ¯ãã«åå ãã¦ãã¾ãããçµæããè¨ãã¨åªåã§ãã¾ãããâ大åâã ã£ãã®ã¨ãå¿æ´ãã¦ããã ããçæ§ã®ãããã§ãããããã¨ããããã¾ãã ä»åã¯ãã®å¤§ä¼ã«åå ãã¦ããã¤ãæãããã¨ããã£ãã®ã§ãåå ã®çµç·¯ããæ¯ãè¿ã£ã¦ãã©ãããæµãããã£ã¦åããããã表æ ã§åªåãããã«ã¤ãã¦æ¸ããã¨æãã¾ãããããã¨ãç¥ããããªã¿ã¯ã®äººã ã¯ãè¿æ¥ä¸ã«å¥ã®ã¨ããã«è¨äºãä¸ãããã¨æãã®ã§ãTwitterããã§ãã¯ãã¦ãã¦ãã ããã åå ã«è³ã£ãçµç·¯ ããã¨ãç¥ãåãã®æ¹ããããããã大ä¼ããããã¨ãããã¨ã§ä¸è¨ã®ãã¼ã¸ã®URLãæãã¦ããã ãã¾ããã確èªãã¦ã¿ãã¨ããæ¥ç¨çã«ã¯åé¡ãªãããã ã£ãããã©ããè³åãã®ã¨ããã«ããªã¢ã«ããã¢ã«ã¼ããå ¨8種é¡ã»ãããã¨ããæ¸ããã¦ãã¾ããã§ããã ãé ä¿¡ããããé åçã§ã¯ãããã©ãæ£ç´è³åã¯ã¤ãã¤ãã ããåæ¥ã使
gamy.jp ããã§ã¯åãä¸å½ã«è©ä¾¡ãããããªãã¨æããç¹ã«ã®ã¿è¨åãã¾ãã â è³éã«é¢ãã¾ã㦠å½åã大ä¼åç¥æç¹ï¼11æ17æ¥ï¼ã§ã¯ãè³é10ä¸åï¼æ¤è¨ä¸ï¼ãã¨è¡¨è¨ãã¦ããã¾ããããæ¶è²»è åºã¨ã®åè°ã®å ãæ¯å表示æ³ã®è¦³ç¹ãããè³éãåºããã¨ãã§ããªããã¨ããå¼ç¤¾æ³åå¤æï¼11æ18æ¥ï¼ããããã¾ããã ãã®å¾ã大ä¼åå è ã«è©³ããçµç·¯ã®èª¬æããªãè³éå 容ã®å¤æ´ã®é£çµ¡ããããã¾ãããï¼SNSä¸ï¼11æ22æ¥ãã¡ã¼ã«ï¼11æ25æ¥ï¼ äºåã®ç¢ºèªãä¸è¶³ãã¦ããä¸ã§å¤§ä¼åç¥ãå®æ½ãããã¨ã§ãåå è ã®çæ§ã®æå¾ ãè£åããããªçµæã«ãªã£ã¦ãã¾ã£ããã¨ããæ·±ããè©«ã³ç³ãä¸ãã¾ãã ã¾ãããSNSä¸ï¼11æ22æ¥ã«ãè³éå 容ã®å¤æ´ã®é£çµ¡ããããã¾ããããã¨ããã¾ããã ãè¨æ£ã第ï¼åFRESH!æ¯ã #ã·ã£ãã¦ãã¼ã¹ ç·¨ãã®è©³ç´°ãå¤æ´è´ãã¾ããã ã»è³é10ä¸åâ¡ï¸ãªã ã»ðåå è å ¨å¡ã«ãªã¢ã«ããã¢
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}