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

ziguzagu id:ziguzagu

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

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

[ThinkIT] ç¬¬3å›žï¼šæ€§èƒ½ã‹å®‰å®šã‹ï¼Ÿãƒ©ã‚¤ã‚¿ãƒ¼ãƒ—ãƒã‚»ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° (1/3)
ã“ã‚Œã¾ã§ã®2å›žã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§ã¯ã€å…±æœ‰ãƒãƒƒãƒ•ã‚¡ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒã‚°ãƒãƒƒãƒ•ã‚¡ã®èª¿æ•´ã‚’å–ã‚Šä¸Šã’ã¾ã—ãŸã€‚ã“ã®2ã¤ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é …ç›®ã¯PostgreSQLã®ãƒ‡ã‚£ã‚¹ã‚¯I/Oã‚’æ¸›ã‚‰ã™ãŸã‚ã«é‡è¦ãªå½¹å‰²ã‚’æžœãŸã—ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚ã€ã“ã‚Œã‚‰ã®è¨å®šã‚’é©åˆ‡ã«èª¿æ•´ã—ã¦ã‚ã’ã‚‹ã“ã¨ã§æ€§èƒ½ã‚’å¤§ããæ”¹å–„ï¼ˆ16ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆæ™‚ã§48tpsã‹ã‚‰90tpsï¼‰ã§ãã¾ã—ãŸã€‚ ã•ã¦ä»Šå›žã¯ã€PostgreSQL 8.0ã‹ã‚‰å°Žå…¥ã•ã‚ŒãŸã€Œãƒ©ã‚¤ã‚¿ãƒ¼ãƒ—ãƒã‚»ã‚¹ã€ã‚’å–ã‚Šä¸Šã’ãŸã„ã¨æ€ã„ã¾ã™ã€‚ PostgreSQLã§ã¯å…±æœ‰ãƒãƒƒãƒ•ã‚¡ã‚’ãƒ‡ã‚£ã‚¹ã‚¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ã—ã¦ä½¿ã£ã¦ã„ã¾ã™ã€‚ã“ã®ãŸã‚ãƒ‡ãƒ¼ã‚¿ã®æ›´æ–°ã¯å…±æœ‰ãƒãƒƒãƒ•ã‚¡ä¸Šã§è¡Œã‚ã‚Œã‚‹ã®ã¿ã§ã€ã™ãã«ã¯ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã«æ›¸ãè¾¼ã¾ã‚Œã¾ã›ã‚“ã€‚ã§ã™ãŒã“ã‚Œã¯å¾Œã§å¿…ãšæ›¸ãè¾¼ã¾ãªã‘ã‚Œã°ãªã‚‰ãªã„ãƒ‡ãƒ¼ã‚¿ã§ã™ã€‚å…±æœ‰ãƒãƒƒãƒ•ã‚¡ã¯ã€Œãƒšãƒ¼ã‚¸ã€ã¨ã„ã†8Kãƒã‚¤ãƒˆã®å˜ä½ã§ç®¡ç†ã•ã‚Œã¦ãŠã‚Šã€å¾Œã§ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã«æ›¸ãè¾¼ã¾ãªã‘ã‚Œã°ãªã‚‰ãªã„ãƒšãƒ¼ã‚¸ã®ã“ã¨ã‚’ç‰¹ã«ã€Œãƒ€ãƒ¼ãƒ†ã‚£
ziguzagu 2007/07/12
ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ãƒ©ã‚¤ã‚¿ãƒ¼ã®èª¿æ•´

postgresql
ãƒªãƒ³ã‚¯
http://www.ipa.go.jp/software/open/forum/development/download/051115/README.pgbench_jis
pgbench README 2003/11/26 Tatsuo Ishii ([email protected]) â– pgbench ã¨ã¯ï¼Ÿ pgbench ã¯ TPC-Bã«ä¼¼ãŸãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã‚’è¡Œãªã†ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã™ï¼Žä»Šã®ã¨ ã“ã‚ PostgreSQL å°‚ç”¨ã§ã™ï¼Ž pgbench ã¯ select/update/insert ã‚’å«ã‚€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å®Ÿè¡Œã—ï¼Œå…¨ä½“ã® å®Ÿè¡Œæ™‚é–“ã¨å®Ÿéš›ã«å®Œäº†ã—ãŸãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®æ•°ã‹ã‚‰ 1 ç§’é–“ã«å®Ÿè¡Œã§ããŸãƒˆ ãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ•° (tps) ã‚’è¡¨ç¤ºã—ã¾ã™ï¼Žå‡¦ç†ã®å¯¾è±¡ã¨ãªã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ãƒ‡ãƒ•ã‚© ãƒ«ãƒˆã§ã¯ 10ä¸‡ã‚¿ãƒ—ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’å«ã¿ã¾ã™ï¼Ž å®Ÿéš›ã®è¡¨ç¤ºã¯ä»¥ä¸‹ã®ã‚ˆã†ãªæ„Ÿã˜ã§ã™ï¼Ž number of clients: 4 number of transactions per client: 100 number of processed transactions: 400/
ziguzagu 2007/07/12
pgbenchãƒžãƒ‹ãƒ¥ã‚¢ãƒ«

postgresql
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯MySQLã‚’å‡ŒãŽOracleã«è‚‰è¿« | ã‚¹ãƒ©ãƒ‰
ãƒ¬ãƒãƒ¼ãƒˆã§ä¸€ç•ªé•ã„ãŒè¦‹ãˆã‚‹ã®ã¯ã“ã®ã¸ã‚“ã‹ã¨æ€ã„ã¾ã™ã€‚ PostgreSQL Storage Requirement Info: The 85 minute run for this submission required less than 4GB of database storage. This extrapolates to less than 70GB for a 24 hour period. The Sun StorageTek 2540 Array drive capacity is 876GB of available storage when configured for RAID 1. Oracle Storage Requirement Info: A 75 min run at Injection Rate of 670 increased storage by 1
ziguzagu 2007/07/11
postgresql
ãƒªãƒ³ã‚¯
ã€ŒPostgreSQLã¯é…ã„ã€ã¯æœ¬å½“ã‹ï¼Ÿï¼šOSSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¯”è¼ƒ - CNET Japan
å°åˆ·ã™ã‚‹ ãƒ¡ãƒ¼ãƒ«ã§é€ã‚‹ ãƒ†ã‚ã‚¹ãƒˆ HTML é›»åæ›¸ç± PDF ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ãƒ†ã‚ã‚¹ãƒˆ é›»åæ›¸ç± PDF ã‚¯ãƒªãƒƒãƒ—ã—ãŸè¨˜äº‹ã‚’Myãƒšãƒ¼ã‚¸ã‹ã‚‰èªã‚€ã“ã¨ãŒã§ãã¾ã™ LAMPã‚„LAPPã¨ã„ã£ãŸè¨€è‘‰ãŒç¤ºã—ã¦ã„ã‚‹ã‚ˆã†ã«ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆOSSï¼‰ã§ã®ä»£è¡¨çš„ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã¨ã„ãˆã°ã€ã€ŒMySQLã€ã¨ã€ŒPostgreSQLã€ã ã€‚ã“ã®2ã¤ã®RDBMSã¯åŒç‰ã§ã‚ã‚‹ã‹ã®ã‚ˆã†ã«æ€ã‚ã‚Œã¦ã„ã‚‹ãŒã€ã—ã‹ã—PostgreSQLã®ãƒ¦ãƒ¼ã‚¶ãƒ¼å›£ä½“ã€Œæ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼šã€ã§ç†äº‹é•·ã‚’å‹™ã‚ã‚‹ç‰‡å²¡è£•ç”Ÿæ°ã«ã‚ˆã‚Œã°ã€ã€ŒPostgreSQLã¯ã‚ã¾ã‚Šä¿¡ç”¨ã•ã‚Œã¦ã„ãªã„ã€ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ãã†ã ã€‚ ã€Œååˆ†ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚ŒãŸMySQLã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ãªã„PostgreSQLã‚’æ¯”è¼ƒã—ãŸã‚Šã€åå¯¾ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚ŒãŸPostgreSQLã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ãªã„MySQLã‚’æ¯”è¼ƒã—ãŸã‚Šã€ã‚ã‚‹ã„ã¯æ¯”
ziguzagu 2007/04/12
mysql

postgresql
ãƒªãƒ³ã‚¯
http://neta.ywcafe.net/000646.html
ziguzagu 2006/09/21
postgresql
ãƒªãƒ³ã‚¯
PostgreSQL 8.1æ£å¼ãƒªãƒªãƒ¼ã‚¹ï¼Œæ€§èƒ½å‘ä¸Šã‚„åˆ†æ•£DBã§ã®2ç›¸ã‚³ãƒŸãƒƒãƒˆãªã©å®Ÿç¾
PostgreSQL Global Development Groupã¯11æœˆ8æ—¥ï¼ˆç¾åœ°æ™‚é–“ï¼‰ï¼Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹DBMSã®æ–°ç‰ˆPostgreSQL 8.1ã‚’æ£å¼ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€‚æ€§èƒ½ã®å‘ä¸Šã‚„åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã®2ç›¸ã‚³ãƒŸãƒƒãƒˆï¼ˆ2ãƒ•ã‚§ãƒ¼ã‚ºãƒ»ã‚³ãƒŸãƒƒãƒˆï¼‰ãªã©ï¼Œ8.0ã‹ã‚‰120ç‚¹ä»¥ä¸Šã®æ”¹è‰¯ã‚„æ©Ÿèƒ½è¿½åŠ ãŒè¡Œã‚ã‚ŒãŸã¨ã„ã†ã€‚ æ–°æ©Ÿèƒ½ã¯ï¼Œ2ç›¸ã‚³ãƒŸãƒƒãƒˆã‚„ãƒãƒ¼ãƒ«ï¼ŒIN/OUTãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãªã©ã€‚2ç›¸ã‚³ãƒŸãƒƒãƒˆã¯ï¼Œè¤‡æ•°ã®ã‚µãƒ¼ãƒãƒ¼ã«åˆ†æ•£ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã§ãƒ‡ãƒ¼ã‚¿ã«ä¸æ•´åˆãŒç”Ÿã˜ãªã„ã‚ˆã†ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å®Ÿè¡Œã™ã‚‹æ©Ÿèƒ½ã€‚ãƒãƒ¼ãƒ«ã¯å€‹ã€…ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã ã‘ã§ã¯ãªãï¼Œå½¹å‰²ã«ã‚¢ã‚¯ã‚»ã‚¹æ¨©é™ã‚’è¨å®šã§ãã‚‹ã€‚ã¾ãŸPostgreSQLã®é–¢æ•°ãŒIN/OUT/INOUTãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ã‚µãƒãƒ¼ãƒˆã—ãŸã“ã¨ã«ã‚ˆã‚Šï¼ŒJavaã‚„.NETã¨ã®é€£æºãŒã‚ˆã‚Šå‘ä¸Šã—ãŸã€‚ æ€§èƒ½é¢ã§ã¯ãƒžãƒ«ãƒãƒ—ãƒã‚»ã‚µç’°å¢ƒã§ã®æ€§èƒ½ãŒæ”¹å–„ã—ãŸã»ã‹ï¼Œãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨å‘¼ã¶æ‰‹æ³•ã«ã‚ˆã‚ŠOLAPãªã©ãƒ‡ãƒ¼ã‚¿è§£æž
ziguzagu 2005/11/10
ç›®æŒ‡ã›Oracleã€‚ã§ã™ã‹ã€‚

postgresql
ãƒªãƒ³ã‚¯
1