InoHiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ / 2015å¹´12æœˆ20æ—¥ - ã¯ã¦ãªãƒ

ä»–ã‚·ã‚¹ãƒ†ãƒ ã¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é€£æºã«ã¤ã„ã¦ - Qiita

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ã‚·ã‚¹ãƒ†ãƒ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ Advent Calendar 2015 - Qiita 20æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’ã—ã¦ã„ã‚‹ã¨ã€ä»–ã‚·ã‚¹ãƒ†ãƒ ã®ãƒžã‚¹ã‚¿ã‚„ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ãŒå¿…è¦ã¨ãªã‚‹å ´åˆãŒã‚ˆãã‚ã‚Šã¾ã™ãã€‚ ã‚·ã‚¹ãƒ†ãƒ é–“ã®ãƒ‡ãƒ¼ã‚¿é€£æºã¨ã—ã¦ã¯ã€ ãƒªã‚½ãƒ¼ã‚¹å…±æœ‰ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…±æœ‰ã€ãƒ‡ã‚£ã‚¹ã‚¯å…±æœ‰ï¼‰ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é€£æºï¼ˆRPCã€Web APIã€MOM1ï¼‰ ãƒ•ã‚¡ã‚¤ãƒ«é€£æº(CSVé€£æºã€etc) ãªã©ã®æ–¹æ³•ãŒã‚ã‚Šã¾ã™ãŒã€ã“ã“ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…±æœ‰ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é€£æºæ–¹å¼ã«ã¤ã„ã¦è€ƒãˆã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é€£æºæ–¹å¼ã«ã¤ã„ã¦ æ—¢å˜ã‚·ã‚¹ãƒ†ãƒ ãŒ

InoHiro 2015/12/20

ãƒªãƒ³ã‚¯

msgpack-lite ãƒ¡ãƒ¢ãƒªã‚³ãƒ”ãƒ¼ã‚’é˜²ã„ã§é«˜é€ŸåŒ–ã—ãŸè©± - Qiita

ãƒã‚¤ãƒŠãƒªå½¢å¼ã®è»½é‡ãªã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã§ã‚ã‚‹ MessagePackï¼ˆä»¥ä¸‹ã€msgpackï¼‰ã®ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ãƒ»ãƒ‡ã‚³ãƒ¼ãƒ‰ã‚’è¡Œã† JavaScript ãƒ©ã‚¤ãƒ–ãƒ©ãƒª msgpack-lite ã‚’2015å¹´7æœˆã«ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚node.js v0.10 ã‹ã‚‰æœ€æ–°ã® v5.3ã€ã¾ãŸãƒ–ãƒ©ã‚¦ã‚¶ã‚‚å«ã‚ã¦å¹…åºƒã„ç’°å¢ƒã§å‹•ä½œã™ã‚‹ã®ãŒç‰¹å¾´ã§ã€fluent-logger ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚‚ã€msgpack ã«æ›¿ãˆã¦ msgpack-lite ã‚’æŽ¡ç”¨ã—ã¦ã„ã¾ã™ã€‚ ä»¥ä¸‹ã§ã¯ã€msgpack ã‚’å®Ÿè£…ã—ãŸéš›ã«æ³¨æ„ã—ãŸãƒã‚¤ãƒ³ãƒˆã‚’ã€ï¼’ã¤ã”ç´¹ä»‹ã—ã¾ã™ã€‚ C++ ã‚ˆã‚Šã‚‚é«˜é€Ÿãªãƒ”ãƒ¥ã‚¢ JavaScript å®Ÿè£… æœ¬é¡Œã«å…¥ã‚‹å‰ã«ã€ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯çµæžœã‚’æ›´æ–°ã—ã¦ãŠã„ãŸã®ã§ã€ã“ã“ã«è¼‰ã›ã¦ãŠãã¾ã™ã€‚ æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ msgpack-lite 0.1.14 ã® node.js v4.2.3 ã«ãŠã‘ã‚‹ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯çµæžœã§ã™ã€‚ msgpa

InoHiro 2015/12/20

ãƒªãƒ³ã‚¯

Rails 5.0ã§è¿½åŠ ã•ã‚Œã‚‹ä¸»ãªæ–°æ©Ÿèƒ½ï¼ˆRuby on Railså…¬å¼ãƒ–ãƒã‚°ã‚ˆã‚Šï¼‰ - Qiita

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ã¯ã˜ã‚ã« Rails 5.0.0.beta1ãŒ2015å¹´12æœˆ18æ—¥ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ ã¾ãŸã€ãã‚Œã«ã‚ã‚ã›ã¦Ruby on Railsã®å…¬å¼ãƒ–ãƒã‚°ã«ä¸»ãªå¤‰æ›´ç‚¹ãŒã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ï¼ˆæŠ•ç¨¿è€…ã¯ã‚ã®DHHæ°ã®ã‚ˆã†ã§ã™ï¼‰ Rails 5.0.0.beta1: Action Cable, API mode, Rails command beta1ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã¨ã„ã†ã“ã¨ã¯ã€Rails 5.0ã®æ£å¼ãƒªãƒªãƒ¼ã‚¹ã‚‚ãã‚ãã‚è¿‘ã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ï¼ˆã¡ãªã¿ã«Rails 4.0ã§ã¯beta1ã®4ãƒ¶æœˆå¾Œã«æ£å¼ç‰ˆãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ï¼‰ Railsãƒ¦ãƒ¼ã‚¶ãƒ¼

InoHiro 2015/12/20

ãƒªãƒ³ã‚¯

Ruby and PostgresQL, a love story

#RubyKaigi 2015

InoHiro 2015/12/20

ãƒªãƒ³ã‚¯

ç·è¡Œæ•°57,000ã®å·¨å¤§CSSç¾¤ã‚’Lessã«æ›¸ãæ›ãˆãŸè»Œè·¡ - mixi engineer blog

ã“ã‚“ã«ã¡ã¯ï¼ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰é—‡ç¥“ã„ã® Kuniwak ã§ã™ã€‚ ã“ã®æŠ•ç¨¿ã¯mixiã‚°ãƒ«ãƒ¼ãƒ— Advent Calendar 2015ã®20æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ä»Šå¹´ã®9æœˆã«ã€ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ Web ãƒ–ãƒ©ã‚¦ã‚¶ç‰ˆ mixiã€Œmixi Touchã€ã®å·¨å¤§ CSS ã‚’ Less ï¼ˆCSS ãƒ—ãƒªãƒ—ãƒã‚»ãƒƒã‚µãƒ¼ï¼‰ã§ãƒ“ãƒ«ãƒ‰ã™ã‚‹ç’°å¢ƒã¸ã¨ç§»è¡Œã—ã¾ã—ãŸã€‚ æ›¸ãæ›ãˆãŸ CSS ã®è¡Œæ•°ã¯ã€ãªã‚“ã¨ 56,725è¡Œ ã§ã™ã€‚ðŸ˜µ ã¨ã„ã†ã“ã¨ã§ã€ä»Šå›žã¯å¼Šç¤¾ã®å¤§è¦æ¨¡ CSS â†’ Less ç§»è¡Œäº‹ä¾‹ã«ã¤ã„ã¦ãŠè©±ã—ã—ã¾ã™ã€‚ èƒŒæ™¯ ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ç‰ˆ mixi ã¯ã€2010å¹´5æœˆã«å§‹ã¾ã‚Šã¾ã—ãŸã€‚ ã“ã®é ƒã®ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã¯ã€iPhone ç«¯æœ«ã§ã‚ã‚Œã° iPhone 3GSã€Android ç«¯æœ«ã§ã‚ã‚Œã° Nexus One ã¨ã„ã†æ™‚æœŸã§ã™ã€‚ ã¾ãŸã€ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã®ä¸–ç•Œã§ã¯ã€Webkit ãƒ™ãƒ¼ã‚¹ã®ãƒ–ãƒ©ã‚¦ã‚¶ãƒ¼ãŒå¸å·»ã—ã¦ã„ãŸæ™‚ä»£ã¨ã„ã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚

InoHiro 2015/12/20

ã¤ã‚‰ãã†...

css
less

ãƒªãƒ³ã‚¯

What is a CTE scan, and what are its implications for performance?

I'm trying to diagnose a slow query, using EXPLAIN ANALYZE. I'm new to the command so I've read http://www.postgresql.org/docs/9.3/static/using-explain.html . The query plan uses a "CTE scan", but I don't know what that is, compared to, say, a sequential scan - and more importantly, what a CTE scan means in general for query performance.

InoHiro 2015/12/20

postgresql

ãƒªãƒ³ã‚¯

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

2015å¹´12æœˆ20æ—¥ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6ä»¶)

ä»–ã‚·ã‚¹ãƒ†ãƒ ã¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é€£æºã«ã¤ã„ã¦ - Qiita

msgpack-lite ãƒ¡ãƒ¢ãƒªã‚³ãƒ”ãƒ¼ã‚’é˜²ã„ã§é«˜é€ŸåŒ–ã—ãŸè©± - Qiita

Rails 5.0ã§è¿½åŠ ã•ã‚Œã‚‹ä¸»ãªæ–°æ©Ÿèƒ½ï¼ˆRuby on Railså…¬å¼ãƒ–ãƒã‚°ã‚ˆã‚Šï¼‰ - Qiita

Ruby and PostgresQL, a love story

ç·è¡Œæ•°57,000ã®å·¨å¤§CSSç¾¤ã‚’Lessã«æ›¸ãæ›ãˆãŸè»Œè·¡ - mixi engineer blog

What is a CTE scan, and what are its implications for performance?

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

2015å¹´12æœˆ20æ—¥ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6ä»¶)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

2015å¹´12æœˆ20æ—¥ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6ä»¶)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹