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

uchiuchiyama id:uchiuchiyama

performanceã¨postgresqlã«é–¢ã™ã‚‹uchiuchiyamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

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

Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
uchiuchiyama 2012/09/12
database

postgresql

mysql

performance
ãƒªãƒ³ã‚¯
ç”˜è‚ƒç©ºæ°”ä¼˜è‰¯å¤©æ•°é€¾ä¹æˆæ°´è´¨åœŸå£¤çŽ¯å¢ƒè´¨é‡æ˜Žæ˜¾æå‡ çˆ†å‘å‹’æ–¯å¦äººåœ°å·´ä¸Žå½“å†²çª-æ¦å†ˆæ–°æ“žè”¬èœè¡Œæƒ…ç½‘
æœ€æ–°æ–‡ç« 2018-12-26 07:29â–ª ä¸€ç”·åé«˜é€Ÿâ€œé£™è½¦â€åŽæ‹è§†é¢‘æ™’å¾®ä¿¡ç¾¤å› æ¶‰å«Œå±é™©é©¾é©¶ç½ªè¢«æ‹˜... 2018-12-26 07:29â–ª å˜‰å®šä¼˜åŒ–è¥å•†çŽ¯å¢ƒä¸ºä¼ä¸šåŠžäº‹æé€Ÿå¢žæ•ˆ 2018-12-26 07:29â–ª â€œè®ºè¯è¥¿æ¸¸è®°æ˜¯è‡ªå·±æ‰€å†™â€ï¼Œæœ‰äº›å¥‡è‘©è€ƒé¢˜ä¸å€¼å¾—æå€¡ 2018-12-26 07:29â–ª ï¼Ÿå…ƒæ—¦æ˜¥èŠ‚å°†è‡³å¹²éƒ¨èŒå·¥å¯äº«æœ‰æ£å¸¸ç¦åˆ©å¾…é‡æ¯äººæ¯å¹´å¯é¢†... 2018-12-26 07:29â–ª ç½‘ç»œå¥³ä¸»æ’ä¸Žâ€œé˜”ç»°â€ç²‰ä¸æˆæ‹äººè¢«éª—25ä¸‡å…ƒ 2018-12-26 07:29â–ª ç¦å»ºé¾™å²©ä¸€å…¬äº¤è½¦è¢«æ¹å¾’åŠ«æŒå†²æ’žè¡Œäººå·²è‡´5æ»21ä¼¤ 2018-12-26 07:29â–ª é›·å¯’ã€æŽæ´ªè¢«æ’¤é”€é‡åº†å¸‚æ”¿åå§”å‘˜èµ„æ ¼ 2018-12-26 07:29â–ª è¥¿åŒç‰ˆçº³å…¬å¼€é”€æ¯é€¾2000ä»¶éžæ³•æžªæ”¯ã€çŒŽå…·ã€æ¯æž—å™¨å…· 2018-12-26 07:29â–ª â€œå¸‚æ°‘äº‘â€æˆå…¨å›½é¦–ä¸ªç”¨æˆ·é€¾åƒä¸‡æ”¿åŠ¡APPï¼Œæœ‰235é¡¹æœåŠ¡ 2018-12-
uchiuchiyama 2010/08/04
postgresql

performance
ãƒªãƒ³ã‚¯
Ywcafe.net
Ywcafe.net This Page Is Under Construction - Coming Soon! Why am I seeing this 'Under Construction' page? Related Searches: Free Credit Report music videos Migraine Pain Relief Best Mortgage Rates Credit Card Application Trademark Free Notice Review our Privacy Policy Service Agreement Legal Notice Privacy Policy
uchiuchiyama 2009/08/04
postgresql

performance

database
ãƒªãƒ³ã‚¯
Performance Tuning PostgreSQL
Introduction PostgreSQL is the most advanced and flexible Open Source SQL database today. With this power and flexibility comes a probl em. How do the PostgreSQL developers tune the default configuration for everyone? Unfortunately the answer is they can't. The probl em is that every database is not only different in its design, but also its requirements. Some systems are used to log mountains of da
uchiuchiyama 2008/02/09
postgresql

performance

tips
ãƒªãƒ³ã‚¯
Collection of PostgreSQL Performance Tips
This is a collection of many performance tips that we've gathered together at Affymetrix, and I thought it would be useful to post them to the PostgreSQL news group. The single most helpful trick has been the "Partial index trick" at the bottom and the use of temp tables. Most of these tricks came from either this news group, or from my colleagues in the bioinformatics department, so I'd like to t
uchiuchiyama 2008/02/09
postgresql

performance

tips
ãƒªãƒ³ã‚¯
PostgreSQL tuning technique
PostgreSQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯é›† SELECT ... WHERE foo = 100 ORDER BY barã‚’SELECT ... WHERE foo = 100 ORDER BY i, jã«æ›¸ãæ›ãˆã‚‹(2004/08/18æŽ²è¼‰) SELECT * FROM t1 WHERE i = 100 ORDER BY j; ã®ã‚ˆã†ãªãƒ‘ã‚¿ãƒ¼ãƒ³ã®æ¤œç´¢ã§ã¯ï¼Œiã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã“ã¨ã§ã‚ã‚‹ç¨‹åº¦ã®é«˜ é€ŸåŒ–ãŒã§ãã¾ã™ãŒï¼Œãã®å¾Œã§ã‚½ãƒ¼ãƒˆãŒç™ºç”Ÿã—ï¼Œé€Ÿåº¦ä½Žä¸‹ã®è¦å› ã«ãªã‚Šã¾ã™ï¼Ž SELECT * FROM t1 WHERE i = 100 ORDER BY j LIMIT 5; ã®ã‚ˆã†ã«ï¼Œå‡ºåŠ›çµæžœä»¶æ•°ã‚’åˆ¶é™ã—ã‹ã¤jã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã¨ï¼Œä»Šåº¦ã¯jã®ã‚¤ ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã†ã‚ˆã†ã«ãªã‚Šã¾ã™ï¼Ž ã—ã‹ã—ï¼Œã‚ˆãè€ƒãˆã¦ã¿ã‚‹ã¨ï¼Œiã§æ¤œç´¢ã—ï¼Œjã§ã‚½ãƒ¼ãƒˆã™ã‚‹ã®ã¯iã¨jã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ ã‚¹ã®ä¸¡æ–¹ã‚’ä½¿ãˆã°ä¸€åº¦ã«ã§ãã‚‹ã¯ãšã§ã™
uchiuchiyama 2008/02/09
postgresql

performance

tips
ãƒªãƒ³ã‚¯
postgresql ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ã“ã®ã‚µã‚¤ãƒˆã¯ã€ã‚‚ã¨ã‚‚ã¨ä½œè€…ã®è‡ªåˆ†ç”¨ãƒ¡ãƒ¢ã¨ã—ã¦æ›¸ãå§‹ã‚ãŸã‚‚ã®ã§ã™ã€‚æ›¸ã„ã¦ã‚ã‚‹ã“ã¨ãŒå…¨ã¦æ£ã—ã„ã¨ã¯é™ã‚Šã¾ã›ã‚“ã€‚ä»–ã®æ–‡çŒ®ã€ã‚ªãƒ•ã‚£ã‚·ãƒ£ãƒ«ãªã‚µã‚¤ãƒˆã‚‚ç¢ºèªã—ã¦ã€è‡ªå·±è²¬ä»»ã«ã¦åˆ©ç”¨ã—ã¦ãã ã•ã„ã€‚ æ•°åä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒ‡ãƒ¼ã‚¿ã‚’æŒã¤å¤§è¦æ¨¡ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ‰±ã†ã‚ˆã†ã«ãªã‚‹ã¨ã€ã‚¯ã‚¨ãƒªã«ã‚ˆã£ã¦ã¯å›žç”ãŒå¾—ã‚‰ã‚Œã‚‹ã¾ã§ã«æ•°ç§’ã‹ã‹ã‚‹ã‚±ãƒ¼ã‚¹ã‚‚å‡ºã¦ãã‚‹ã€‚ã“ã‚Œã¯ã€ã‚ˆã‚Šå¤šãã®ãƒ¡ãƒ¢ãƒªã‚„ãƒ‡ã‚£ã‚¹ã‚¯ã®ä½¿ç”¨ã‚’ PostgreSQL ã«è¨±ã™ã“ã¨ã§æ”¹å–„ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒé«˜ã„ã€‚ãŸã ã—ã€æ‰±ã£ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå°ã•ã„æ™‚ã«ã¯å¤§ã—ãŸåŠ¹æžœã¯æœ›ã‚ãªã„ã€‚ã¾ãŸã€ãã‚‚ãã‚‚ã®å®Ÿè£…ãƒ¡ãƒ¢ãƒªãŒ 256M ã¨ã‹ 128M ã¨ã„ã†è²§å¼±ãªçŠ¶æ…‹ã§ã¯ã€èª¿æ•´ã®ä½™åœ°ã•ãˆãªãã€å˜ãªã‚‹æ‚ªã‚ãŒãã ã€‚ä»¥ä¸‹ã¯æè¼‰ãƒ¡ãƒ¢ãƒª 1 ã‚®ã‚¬ã‚’ç›®å®‰ã«æ›¸ã„ã¦ã„ã‚‹ã€‚æ›´ã«ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®ç´ æ€§ã¨ã‚¯ã‚¨ãƒªãƒ‘ã‚¿ãƒ¼ãƒ³ã«ã‚ˆã£ã¦ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«è‡ªä½“ã®ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ãŒåŠ é€Ÿã‚’ä¸Šä¹—ã›ã—ã¦ãã‚Œã‚‹ã‹ã‚‚ã—ã‚Œãªã„ -- ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã‚„é©åˆ‡ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆã¯ã€ãƒ¡
uchiuchiyama 2007/09/04
postgresql

performance

tips
ãƒªãƒ³ã‚¯
Page not found - ãƒ•ã‚¡ã‚¤ãƒ¤ãƒ¼ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ
The page you are trying to reach does not exist, or has been moved. Please use the menus or the search box to find what you are looking for.
uchiuchiyama 2007/08/29
postgresql

database

performance

development
ãƒªãƒ³ã‚¯
HOMMEZå…¬å¼ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚·ãƒ§ãƒƒãƒ—
HOMMEZ(ã‚ªãƒ ã‚º)ã¯ç”·æ€§ã®å¿ƒã¨èº«ä½“ã®å¥åº·ã‚’æ”¯æ´ã—ã€ä¸€äººã§ã‚‚å¤šãã®äººãŒåä¾›ã‚’å¾—ã‚‹å¹¸ã›ã‚„ç”·æ€§ã¨ã—ã¦ã®å–œã³ã‚’äº«å—ã§ãã‚‹ç¤¾ä¼šã®å®Ÿç¾ã‚’ç›®æŒ‡ã—ã¦ã„ã¾ã™ã€‚ç”·æ€§ã®å¦Šæ´»ã€æ´»åŠ›ã«ã¾ã¤ã‚ã‚‹æƒ…å ±ã‚„å•†å“ã®åŠ›ã§æ€§ã‚„å¦Šæ´»ã«æ‚©ã‚€ç”·æ€§ãŒåŠ¹çŽ‡çš„ã«ç´å¾—æ„Ÿã‚’æŒã£ã¦æ´»å‹•ã§ãã‚‹æ©Ÿä¼šã‚’å‰µå‡ºã—ã¾ã™ã€‚
uchiuchiyama 2007/08/29
postgresql

performance

development

database
ãƒªãƒ³ã‚¯
zuzara.com ï¿½ PostgreSQLã«å·¨å¤§ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã¨ãã®TIPS
1ã¤ç›®ãŒã€Œindexã¯å¾Œã‹ã‚‰ã¤ã‘ã‚‹ã€ create table test ( id integer, title varchar(255) );ã“ã‚“ãªãƒ†ãƒ¼ãƒ–ãƒ«ã«COPYã§ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ã¨ãã€ create index test_idx on test(title);ã“ã†ã„ã£ãŸindexã‚’å…ˆã«ã¤ã‘ã¦ã‹ã‚‰å®Ÿè¡Œã™ã‚‹ã¨30ä¸‡è¡Œã®ãƒ‡ãƒ¼ã‚¿ã§10åˆ†ç¨‹åº¦ã€‚6000ä¸‡è¡Œã‚ã‚‹ã¨72æ™‚é–“ç¨‹åº¦çµŒã£ã¦ã‚‚çµ‚ã‚ã‚‰ãšã€‚ indexãªã—ãªã‚‰10åˆ†ã§6000ä¸‡è¡Œã„ã‘ã¾ã—ãŸã€‚ãƒ‡ãƒ¼ã‚¿ãŒå…¥ã£ãŸå¾Œã®create indexã«ã¯1ï½ž2æ™‚é–“ã€‚ å‹•ä½œç’°å¢ƒã¯CPU 2.80GHzã€Memory 1Gã§FedoraCore5ã«PostgreSQL8.1.4ã€‚ 2ã¤ç›®ãŒã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã”ã¨ã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã™ã‚‹ã¨ãã¯pg_dumpã§ã¯ãªãã¦COPYã€ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ç”¨ã®pg_dumpã‚’ä½¿ã†ã¨ç°¡å˜ã§ã™ãŒã€-tã§ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æŒ‡å®šã™ã‚‹ã¨COPYæ–‡ã«ãªã‚‰ãšã«
uchiuchiyama 2007/07/20
postgresql

performance

tips
ãƒªãƒ³ã‚¯
ã€ãƒ¬ãƒãƒ¼ãƒˆã€‘8.3ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯åŠ‡çš„ã«å‘ä¸Šã™ã‚‹ - ã‚³ã‚¢ãƒ¡ãƒ³ãƒãƒ¼ãŒèªžã‚‹PostgreSQLã®ä»Š (2) PostgreSQL 8.3ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒã™ã”ã„! - æ–°æ©Ÿèƒ½ã¯"HOT"! | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
PostgreSQLã®é–‹ç™ºã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ« æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®PostgreSQL 8.3ã¯ã™ã§ã«4æœˆã«ãƒ•ãƒªãƒ¼ã‚ºã•ã‚Œã¦ãŠã‚Šã€ã€Œã‚ã¨ã¯ç´°ã‹ãªãƒã‚°ã‚„ã€ã©ã®ãƒ‘ãƒƒãƒã‚’é©ç”¨ã™ã‚‹ã‹(ã‚ã‚‹ã„ã¯å¤–ã™ã‹)ã¨ã„ã£ãŸã“ã¨ã‚’æ±ºã‚ã‚‹ã ã‘ã€(Berkusæ°)ã¨ã„ã†ã€‚Berkusæ°ã®å‘¨å›²ã§ã¯ã€Œã‚‚ã†8.3ã®ä½œæ¥ã¯ã»ã¨ã‚“ã©çµ‚ã‚ã£ã¦ã„ã‚‹ã®ã§ã€ã¿ã‚“ãª8.4ã®è©±ã—ã‹ã—ãªã„ã‚“ã ã‚ˆ(ç¬‘)ã€ã¨ã„ã†çŠ¶æ…‹ã ã¨ã‹ã€‚ã»ã¼ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«é€šã‚Šã«8.3ã®é–‹ç™ºã‚’é€²ã‚ã¦ã“ã‚ŒãŸã“ã¨ã«ã¤ã„ã¦ã€Berkusæ°ã¯ã€Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®é–‹ç™ºã§ã‚ã£ã¦ã‚‚ã€ã§ãã‚‹ã ã‘å½“åˆã®ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«é€šã‚Šã«é€²è¡Œã§ãã‚‹ã‚ˆã†ã«åŠªåŠ›ã™ã¹ãã ã€‚8.3ã®é–‹ç™ºã‚’äºˆå®šé€šã‚Šé€²ã‚ã‚‰ã‚ŒãŸã“ã¨ã«ã¤ã„ã¦ã¯æº€è¶³ã—ã¦ã„ã‚‹ã€‚ãŸã ã—8.4ã¯è‹¥å¹²é…ã‚Œæ°—å‘³ã‹ã‚‚ã—ã‚Œãªã„ã€‚é€²æ—ã«é–¢ã—ã¦ã¯éšæ™‚å ±å‘Šã—ã¦ã„ããŸã„ã¨æ€ã†ã€ã¨èªžã‚Šã€ä»–ã®OSSã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã‚‚ã‚‚ã£ã¨é–‹ç™ºã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’æ°—ã«ã™ã¹ãã€ã¨ã—ãŸã€‚ æ°—ã«ãªã‚‹8.3ã®æ€§èƒ½ã ãŒã€Ber
uchiuchiyama 2007/06/18
postgresql

database

performance
ãƒªãƒ³ã‚¯
ã€Œã™ã§ã«OSSãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã®æ€§èƒ½ååˆ†ã€ã€IPAãŒè©•ä¾¡çµ‚äº† ï¼ ï¼ IT
2007/02/07 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã¨ã„ã£ãŸOSSãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢é©ç”¨ã«ãŠã‘ã‚‹èª²é¡Œã¯ã€ã‚‚ã¯ã‚„æ€§èƒ½ã§ã¯ãªã„â€•â€•ã€‚ ç‹¬ç«‹è¡Œæ”¿æ³•äººæƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼ˆIPAï¼‰ã®å§”è¨—ã§ã€å¤§æ‰‹SIãƒ™ãƒ³ãƒ€ã‚„ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ãƒ™ãƒ³ãƒ€ãªã©9ç¤¾ãŒä¸å¿ƒã¨ãªã£ã¦2004å¹´ã‹ã‚‰å®Ÿæ–½ã—ã¦ã„ã‚‹ã€ŒOSSï¼ˆã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼‰æ€§èƒ½ãƒ»ä¿¡é ¼æ€§è©•ä¾¡ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã€ã®ç¬¬4å›žç›®ã®æˆæžœãŒç™ºè¡¨ã•ã‚ŒãŸã€‚PostgreSQLã‚„MySQLã¨ã„ã£ãŸOSSã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯CPUæ•°ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ãŒæ ¼æ®µã«å‘ä¸Šã—ã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ¬¡ç¬¬ã§å¤§å¹…ãªé«˜é€ŸåŒ–ã‚„å¤§è¦æ¨¡å¯¾å¿œãŒå¯èƒ½ã¨ã„ã†ã€‚ 3å¹´ã§çŠ¶æ³ã¯ä¸€å¤‰ã€ã‚‚ã¯ã‚„OSSãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã¯æ€§èƒ½é¢ã¯ååˆ† ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒæ´»å‹•æˆæžœã‚’ç™ºè¡¨ã™ã‚‹ã®ã¯ä»Šå›žã§4å›žç›®ã€‚OSSã®æ€§èƒ½é™ç•Œã‚’æ˜Žã‚‰ã‹ã«ã—ã€é©ç”¨å¯èƒ½é ˜åŸŸã‚’æ˜Žç¢ºã«ã™ã‚‹ã®ãŒç›®æ¨™ã®1ã¤ã ã€‚OSã®Linuxã¯ã€ã‚«ãƒ¼ãƒãƒ«2.4ç³»ã«ã‚ã£ãŸãƒãƒƒã‚¯ç«¶åˆã®å•é¡Œã¯ã‚«ãƒ¼ãƒãƒ«2.6ç³»ã§è§£æ¶ˆã•ã‚Œã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“
uchiuchiyama 2007/02/08
@it

news

postgresql

performance
ãƒªãƒ³ã‚¯
1