[B! PostgreSQL] pmakinoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

pmakino id:pmakino

PostgreSQLã«é–¢ã™ã‚‹pmakinoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (77)

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

PostgreSQL 20å¹´å²ï½œã‚³ãƒŸãƒƒã‚¿ãƒ¼çŸ³äº•é”å¤«ãŒæŒ¯ã‚Šè¿”ã‚‹å¤‰é·ã¨é€²åŒ–ã®æ´å²ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
PostgreSQLÂ 20å¹´å²ï½œã‚³ãƒŸãƒƒã‚¿ãƒ¼çŸ³äº•é”å¤«ãŒæŒ¯ã‚Šè¿”ã‚‹å¤‰é·ã¨é€²åŒ–ã®æ´å² ä¸–ç•Œä¸ã§ä½¿ç”¨ã•ã‚Œã‚‹RDBMSã§ã‚ã‚‹PostgreSQLã®é•·ã„æ´å²ã«ã¯ã€ã©ã®ã‚ˆã†ãªå¤‰é·ãŒã‚ã£ãŸã®ã§ã—ã‚‡ã†ã‹ã€‚é•·ãã€PostgreSQLã«é–¢ã‚ã‚Šç¶šã‘ã‚‹çŸ³äº•é”å¤«ã•ã‚“ã«ã€åŒã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®é€²åŒ–æ´å²ã®ä¸ã«ã‚ã‚‹ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã‚’ã‚‚ã¨ã«æŒ¯ã‚Šè¿”ã£ã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®RDBMSã§ã‚ã‚‹PostgreSQLã¯ã€ã„ã¾ã‚„ä¸–ç•Œä¸ã®äººã€…ãŒåˆ©ç”¨ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¨ãªã‚Šã¾ã—ãŸã€‚ãã®æ´å²ã¯é•·ãã€ãƒ«ãƒ¼ãƒ„ã¯30å¹´ä»¥ä¸Šã‚‚å‰ã«ã•ã‹ã®ã¼ã‚Šã¾ã™ã€‚ PostgreSQLã®å‰èº«ã¯ã€ã‚«ãƒªãƒ•ã‚©ãƒ«ãƒ‹ã‚¢å¤§å¦ãƒãƒ¼ã‚¯ãƒ¬ãƒ¼æ ¡ã§1986å¹´ã«å§‹ã¾ã£ãŸPOSTGRESãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã™ã€‚ãã®å¾Œã€1994å¹´ã«Andrew Yuæ°ã¨Jolly Chenæ°ãŒPOSTGRESã«SQLè¨€èªžã‚¤ãƒ³ã‚¿ãƒ—ãƒªã‚¿ã‚’è¿½åŠ ã—ã€ç¿Œå¹´ã«Postgres95ã‚’ãƒªãƒªãƒ¼ã‚¹ã€‚1996å¹´ã«ã‚ˆã†ã‚„ãPostgreSQLã¨ã„
pmakino 2019/08/15
OpenSource

ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼

PostgreSQL

DB
ãƒªãƒ³ã‚¯
ãƒ•ãƒ«ãƒ‘ãƒ¯ãƒ¼ã§åŠ é€Ÿã™ã‚‹GPUã®å’†å“®ã‚’èžã‘!æœ€å…ˆç«¯GPUã§PostgreSQLã‚’20å€é«˜é€ŸåŒ–!?:é›»è„³ãƒ’ãƒƒãƒãƒã‚¤ã‚¯ã‚¬ã‚¤ãƒ‰:é›»è„³ç©ºé–“ã‚«ã‚¦ãƒœãƒ¼ã‚¤ã‚ºZZ(é›»è„³ç©ºé–“ã‚«ã‚¦ãƒœãƒ¼ã‚¤ã‚º) - ãƒ‹ã‚³ãƒ‹ã‚³ãƒãƒ£ãƒ³ãƒãƒ«:ç”Ÿæ´»
GPUã£ã¦ã‚ã‚‹ã ã‚? ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ãƒ»ãƒ—ãƒã‚»ãƒƒã‚·ãƒ³ã‚°ãƒ»ãƒ¦ãƒ‹ãƒƒãƒˆã€‚ ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã®ä¸ã§æœ€ã‚‚é«˜é€Ÿãªéƒ¨å“ã¯ãªã‚“ã¨ã„ã£ã¦ã‚‚GPUã ã€‚ ãŸã¨ãˆã°nViditaã®æœ€æ–°SoCã§ã‚ã‚‹Tegra K1ã€‚ CPUéƒ¨ã¯å˜ç²¾åº¦ã§73.6ã‚®ã‚¬FLOPS(ãƒ•ãƒãƒƒãƒ—ã‚¹)ã€ã ãŒGPUéƒ¨ã¯364.8ã‚®ã‚¬FLOPSã ã€‚ ã“ã‚ŒãŒ30ä¸‡å††ã™ã‚‹æœ€æ–°ã®GPUãƒœãƒ¼ãƒ‰ã€GeForce GTX TITAN Zã«ãªã‚‹ã¨ã€ãªã‚“ã¨ã³ã£ãã‚Šã€8ãƒ†ãƒ©FLOPSã ã€‚ ã“ã‚Œã¯Intelã®æœ€é«˜ç´šIA-64ãƒãƒƒãƒ—ã€Xeon ES-2687Wã®198.4ã‚®ã‚¬FLOPSã‚’å¤§ããä¸Šå›žã‚‹ã€‚ Core i7ã¯92ã‚®ã‚¬FLOPSã«éŽãŽãªã„ã€‚ ã¡ãªã¿ã«ã‹ã¤ã¦æ•°å„„å††ã—ãŸã‚¹ãƒ¼ãƒ‘ãƒ¼ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã€Cray-2ã¯ã‚ãšã‹1.9ã‚®ã‚¬FLOPSã«éŽãŽãšã€ä»Šã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãŒã©ã‚Œã ã‘é€Ÿã„ã‹çªºã„çŸ¥ã‚Œã‚‹ã€‚JAMSTECã®åœ°çƒã‚·ãƒŸãƒ¥ãƒ¬ãƒ¼ã‚¿ã¯131ãƒ†ãƒ©FLOPSã ãŒã€è¿½ã„ã¤ã‹ã‚Œã‚‹ã®ã¯æ™‚é–“ã®å•é¡Œã ã‚
pmakino 2014/06/18
CPU

DB

PostgreSQL

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
SRA OSSæ—¥æœ¬æ”¯ç¤¾ã¨TISã€Zabbixã§PostgreSQLã‚’ç›£è¦–ã™ã‚‹ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚’å…¬é–‹
SRA OSSæ—¥æœ¬æ”¯ç¤¾ã¨TISã¯2013å¹´11æœˆ5æ—¥ã€PostgreSQLã®ç¨¼åƒçŠ¶æ³ã¨æ€§èƒ½ã‚’ç›£è¦–ã™ã‚‹ãŸã‚ã®Zabbixç”¨ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã€ŒPostgreSQL monitoring template for Zabbixã€ï¼ˆpg_monzã€å†™çœŸï¼‰ã‚’OSSï¼ˆã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ï¼‰ã¨ã—ã¦å…¬é–‹ã—ãŸã¨ç™ºè¡¨ã—ãŸã€‚ã“ã‚Œã‚’ä½¿ãˆã°ã€PostgreSQLã‚„Zabbixã«è©³ã—ããªã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã‚‚PostgreSQLã®é‹ç”¨ç›£è¦–ãŒå¯èƒ½ã«ãªã‚‹ã¨ã—ã¦ã„ã‚‹ã€‚ ä¸¡ç¤¾ãŒä»Šå›žãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚’é–‹ç™ºã—ãŸZabbixã¯ã€OSSã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯/ã‚·ã‚¹ãƒ†ãƒ ç›£è¦–ã‚½ãƒ•ãƒˆã€‚ãƒªãƒ¢ãƒ¼ãƒˆã‹ã‚‰ã®ãƒãƒ¼ãƒˆç›£è¦–ã‚„SNMPç›£è¦–ã®ã»ã‹ã€ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆã‚’ç”¨ã„ãŸãƒ—ãƒã‚»ã‚¹ç›£è¦–ãŒã§ãã‚‹ã€‚ã—ãã„å€¤ã«ã‚ˆã‚‹ã‚¢ãƒ©ãƒ¼ãƒˆé€šçŸ¥ã‚„ã€è“„ç©ã—ãŸç›£è¦–ãƒ‡ãƒ¼ã‚¿ã®å‹•å‘åˆ†æžãªã©ãŒå¯èƒ½ã€‚ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã®pg_monzã¯ã€Zabbixã§PostgreSQLã‚’ç›£è¦–ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã€‚ pg_monzã§ç›£è¦–å¯èƒ½ãªé …ç›®ã¯ã€ä»¥ä¸‹
pmakino 2014/02/16
ã‚·ã‚¹ãƒ†ãƒ é‹ç”¨

PostgreSQL

DB
ãƒªãƒ³ã‚¯
Tuning Your PostgreSQL Server/ja - PostgreSQL wiki
ä½œè€… Greg Smithã€Robert Treatã€ãŠã‚ˆã³Christopher Browne PostgreSQLã¯æ€§èƒ½ã‚ˆã‚Šã‚‚å¹…åºƒã„äº’æ›æ€§ã‚’ç›®çš„ã«è¨å®šã•ã‚ŒãŸã€åŸºæœ¬è¨å®šã§é…å¸ƒã•ã‚Œã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã§ã¯ã€ä½¿ç”¨ä¸ã®ã‚·ã‚¹ãƒ†ãƒ ã‚’éŽå°è©•ä¾¡ã—ã¦ã—ã¾ã†å¯èƒ½æ€§ãŒé«˜ã„ã§ã™ã€‚ æœ€çµ‚çš„ã«æŠŠæ¡ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„é …ç›®ã®ã™ã¹ã¦ï¼ˆå¿…è¦ãªã‚‰ã°GUC Three Hour Tourã‚’å‚ç…§ã—ã¦ãã ã•ã„ï¼‰ã«å¼•ããšã‚Šè¾¼ã¾ã‚Œãªã„ã‚ˆã†ã«ã€ã“ã“ã§åŸºæœ¬ã‚’ç°¡å˜ã«ç´¹ä»‹ã™ã‚‹ã“ã¨ã§ãŠåŠ©ã‘ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ã“ã‚Œã‚‰ã¯PostgreSQLã®åˆå¿ƒè€…ã¯æ°—ã«ã—ãªã„ã€ã‚‚ã£ã¨ã‚‚ä¸€èˆ¬çš„ãªã‚‚ã®ã®ã‚ˆã†ã§ã™ã€‚ ã“ã“ã§ç´¹ä»‹ã—ãŸæ¦‚è¦ã‚’èªã‚“ã å¾Œã«ã‚ˆã‚Šè©³ã—ãçŸ¥ã‚ŠãŸã‘ã‚Œã°ã€å„ç¯€ã«ã¦ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®åå‰ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ æœ€æ–°ã®PostgreSQLã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã®é–¢é€£æ–‡æ›¸ã«ãƒªãƒ³ã‚¯ã—ã¦ã„ã¾ã™ã€‚ ã•ã‚‰ã«Server Configuration Tuningã«ã¯ã€ã“
pmakino 2010/07/17
DB

PostgreSQL

é«˜é€ŸåŒ–

è³‡æ–™
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
å°åŒ—å¸‚ç«‹å‹•ç‰©åœ’ã¨è¿ªåŒ–è¡—ã‚ãã‚Š åé€£ã‚Œå°æ¹¾#5 å¹´è¶Šã—å°æ¹¾ æ—…è¡Œ5æ—¥ç›®ã€ãƒ¬ã‚¸ãƒ£ãƒ¼ã‚„å‹äººã¨ã®é£Ÿäº‹ã‚’æ¥½ã—ã‚€æ—¥ã§ã™ã€‚å‰æ—¥ã®æ§˜åã¯ã“ã¡ã‚‰ www.oukakreuz.com å°åŒ—å¸‚ç«‹å‹•ç‰©åœ’ã¸ ãƒ‘ãƒ³ãƒ€é¤¨ ãƒ‘ãƒ³ãƒ€ãŒè¦‹ã‚‰ã‚Œã‚‹ãƒ¬ã‚¹ãƒˆãƒ©ãƒ³ è¿ªåŒ–è¡—ã¸ æž—èŒ‚æ£®èŒ¶è¡Œã§ãŠèŒ¶ã‚’è³¼å…¥ å°èŠ±åœ’ã§åˆºç¹ã‚°ãƒƒã‚ºã‚’è³¼å…¥ é»’æ¦å£«ç‰¹è‰²è€ç«é‹ã§å¤•é£Ÿ å°åŒ—å¸‚ç«‹å‹•ç‰©åœ’ã¸ æ¾â€¦
pmakino 2010/07/12
PostgreSQL

DB

é«˜é€ŸåŒ–

ã¾ã¨ã‚

Tips
ãƒªãƒ³ã‚¯
Installing DBD::Pg on Windows - Computer Help Forum
pmakino 2010/04/05
Perl

Windows

PostgreSQL

CPAN
ãƒªãƒ³ã‚¯
textsearch_senna
N-gram ã‚’ä½¿ç”¨ã—ãŸã€çµ„ã¿è¾¼ã¿åž‹ã®æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ã§ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ : ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã®ã»ã‹ã€Windows ç”¨ãƒã‚¤ãƒŠãƒªã‚‚ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆ ãƒ¡ãƒ¼ãƒªãƒ³ã‚°ãƒªã‚¹ãƒˆ ã¸ã®å‚åŠ æ¦‚è¦ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ãƒ†ã‚ã‚¹ãƒˆæ¤œç´¢æ©Ÿèƒ½ %% æ¼”ç®—å @@ æ¼”ç®—å ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ (senna) ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒ»ã‚ªãƒ—ã‚·ãƒ§ãƒ³ (WITH) ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ senna.drop_index() senna.reindex_index() ä¸è¦ãƒ•ã‚¡ã‚¤ãƒ«ã®èª¿æŸ» TODO æ¦‚è¦ æ—¥æœ¬èªžãƒ†ã‚ã‚¹ãƒˆã®å…¨æ–‡æ¤œç´¢ã‚’è¡Œã„ã¾ã™ã€‚ å½¢æ…‹ç´ è§£æžãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ textsearch-ja ã¨ã¯ç•°ãªã‚Šã€textsearch_senna ã§ã¯ N-gram ãƒ™ãƒ¼ã‚¹ã®å…¨æ–‡æ¤œç´¢ã‚’è¡Œã„ã¾ã™ã€‚ æ¤œç´¢ã«ã¯ã€å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ Senna ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚ åˆ©ç‚¹ã¨ã—ã¦ã€æ–‡å—ã™ã¹ã¦ã‚’ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹åŒ–ã™ã‚‹ãŸã‚ LIKE ä¸é–“ä¸€è‡´æ¤œç´¢ã«è¿‘ã„çµæžœ
pmakino 2010/02/22
Senna

PostgreSQL

å…¨æ–‡æ¤œç´¢

DB
ãƒªãƒ³ã‚¯
Ywcafe.net
Ywcafe.net This Page Is Under Construction - Coming Soon! Why am I seeing this 'Under Construction' page? Related Searches: Work from Home Accident Lawyers Anti Wrinkle Creams 10 Best Mutual Funds Free Credit Report Trademark Free Notice Review our Privacy Policy Service Agreement Legal Notice Privacy Policy
pmakino 2010/02/20
ãã†ã ã£ãŸã‚“ã â€¦>ã€ŒLudiaã¯ã€ PostgreSQL8.3.5(ã‚‚ã—ã‹ã—ã¦8.3.xå…¨éƒ¨ï¼Ÿï¼‰ã‚ãŸã‚Šã‹ã‚‰ã‚‚ã†å‹•ã‹ãªã„ã€‚8.4ä»¥é™ã‚‚ãƒ€ãƒ¡ã§ã€ã‚µãƒãƒ¼ãƒˆã•ã‚Œã‚‹æ°—é…ã‚‚ãªã„ã€‚ã€

DB

å…¨æ–‡æ¤œç´¢

PostgreSQL

Senna

Ludia
ãƒªãƒ³ã‚¯
http://neta.ywcafe.net/001031.html
pmakino 2009/11/23
PostgreSQL

Tips

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
PostgreSQL 8.5 ã®æ–°æ©Ÿèƒ½ â€” Let's Postgres
NTT ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚»ãƒ³ã‚¿ æ¿åž£ è²´è£• 2009å¹´10æœˆ24æ—¥ã€PostgreSQL 8.5 ã®é–‹ç™ºãƒžã‚¤ãƒ«ã‚¹ãƒˆãƒ¼ãƒ³ç‰ˆã§ã‚ã‚‹ Alpha 2 ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ã‚¢ãƒ«ãƒ•ã‚¡ç‰ˆã¯ "Alpha Information" ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ æ³¨ç›®ã®æ–°æ©Ÿèƒ½ã§ã‚ã‚‹ã€Œå‚ç…§è² è·åˆ†æ•£ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã¯ã¾ã å–ã‚Šè¾¼ã¾ã‚Œã¦ã„ã¾ã›ã‚“ãŒã€ãã‚Œä»¥å¤–ã«ã‚‚æ—¢ã«æ•°å¤šãã®æ–°æ©Ÿèƒ½ãŒæŽ¡ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯ã€å®Œæˆé–“è¿‘ã®å‚ç…§è² è·åˆ†æ•£ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ¦‚è¦ã¨ã€ãã®ä»–ã® PostgreSQL 8.5 ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ å‚ç…§è² è·åˆ†æ•£ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ PostgreSQL 8.5 ã§ã¯ã€ã€Œãƒ›ãƒƒãƒˆãƒ»ã‚¹ã‚¿ãƒ³ãƒã‚¤ã€ã¨ã€Œã‚¹ãƒˆãƒªãƒ¼ãƒ ãƒ»ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ãŒé–‹ç™ºä¸ã§ã™ã€‚ã“ã‚Œã‚‰ã‚’çµ„ã¿åˆã‚ã›ã‚‹ã“ã¨ã§ã€PostgreSQL ã§ã‚·ãƒ³ã‚°ãƒ«ãƒžã‚¹ã‚¿ - ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒ¼ãƒ–åž‹ã®å‚ç…§è² è·åˆ†æ•£ã‚¯ãƒ©ã‚¹ã‚¿ãŒæ‰‹è»½ã«çµ„ã‚ã‚‹ã‚ˆã†ã«ãªã‚‹è¦‹
pmakino 2009/10/30
PostgreSQL
ãƒªãƒ³ã‚¯
</title> <meta name="Author" content=""> <meta name="Creator" content="PowerPoint ç”¨ Acrobat PDFMaker 8.1"> <meta name="Producer" content="Acrobat Distiller 8.1.0 (Windows)"> <meta name="CreationDate" content=""> </head> <body> <pre> PostgreSQLã‚»ãƒŸãƒŠï¿½
PostgreSQLã‚»ãƒŸãƒŠãƒ¼ 2009æ˜¥ ã€œã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£äº‹æ•…ã®ã‚±ãƒ¼ã‚¹ã‚¹ã‚¿ãƒ‡ã‚£ã€œ ç‹¬ç«‹è¡Œæ”¿æ³•äºº æƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼ˆï¼©ï¼°ï¼¡ï¼‰ ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚»ãƒ³ã‚¿ãƒ¼ ç›¸é¦¬ åŸºé‚¦ Copyright Â© 2008 ç‹¬ç«‹è¡Œæ”¿æ³•äºº æƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ å¯¾è±¡ãƒ»ãƒã‚¤ãƒ³ãƒˆ â€¢ å¯¾è±¡ â€“ ä¼æ¥ç‰ã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆå…¬é–‹ã«ãŠã‘ã‚‹å®‰å…¨æ€§å‘ä¸Š ã«ã¤ã„ã¦ç†è§£ã‚’æ·±ã‚ãŸã„æ–¹ â€¢ ãƒã‚¤ãƒ³ãƒˆ â€“ ä¸»ã«ä¼æ¥ã‚¦ã‚§ãƒ–ã«é–¢é€£ã—ãŸã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£äº‹æ•…ã® ã‚±ãƒ¼ã‚¹ã‚¹ã‚¿ãƒ‡ã‚£ã«ã‚ˆã‚‹è„…å¨ã¨å¯¾ç–ã®æŠ€è¡“çš„è§£èª¬ Copyright Â© 2008 ç‹¬ç«‹è¡Œæ”¿æ³•äºº æƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ 2 æœ¬è¬›ã®å†…å®¹ 1. 2. 3. 4. SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ï¼Ÿ äº‹ä¾‹:ã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã‚µã‚¤ãƒˆã§ã‚¦ã‚¤ãƒ«ã‚¹æ„ŸæŸ“ï¼Ÿ SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®å¯¾ç– å®‰å…¨ãªã‚¦ã‚§ãƒ–é–‹ç™ºã®ãŸã‚ã®è³‡æ–™ Copyright Â© 2008 ç‹¬ç«‹è¡Œæ”¿æ³•äºº æƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ 3 1. SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ï¼Ÿ
pmakino 2009/05/09
ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

è„†å¼±æ€§

è³‡æ–™

DB

PostgreSQL

IPA
ãƒªãƒ³ã‚¯
PostgreSQLã‚’æœ¬å½“ã«é«˜é€ŸåŒ–ã—ãŸã„äººã®ãŸã‚ã®10ã®ãƒã‚¤ãƒ³ãƒˆ | ç‹¬ã‚Šè¨€v6
ç©ºæ°—ã‚’èªã¾ãšã«PostgreSQLã®ã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®ãƒã‚¤ãƒ³ãƒˆ - è±¡ã¨æˆ¯ã‚Œ -ç©ºæ°—ã‚’èªã¾ãšã«PostgreSQLã®ã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®ãƒã‚¤ãƒ³ãƒˆ - è±¡ã¨æˆ¯ã‚Œ - postgresqlã‚°ãƒ«ãƒ¼ãƒ—.ã®å…ƒã‚¨ãƒ³ãƒˆãƒªã‚’èªã‚“ã§æ€ã†ã¨ã“ã‚ãŒã‚ã£ãŸã®ã ãŒã€ PostgreSQLã‚’é«˜é€ŸåŒ–ã™ã‚‹16ã®ãƒã‚¤ãƒ³ãƒˆ ã ã‹ã‚‰ãã‚“ãªã›ã¾ã£ãã‚‹ã—ã„ã¨ã“ã‚ã§ãƒˆãƒ³ãƒãƒ³ã‚«ãƒ³ã«disã‚‹æš‡ã‚ã‚‹ã‚“ã ã£ãŸã‚‰è‡ªåˆ†ã®ãƒ–ãƒã‚°ã§ãŠå¥½ã¿ã®è°è«–ã‚’æ›¸ãã‹ã•ã‚‚ãªãã‚ƒ/dev/nullã«ã§ã‚‚åã‘ã¨ã‚„ã‚“ã‚ã‚Šã¨è¨€ã£ã¦ã‚‹ã‚“ã ã‚ˆãƒã‚²ã€‚ ã¨ã„ã†ã‚ã‘ã§ï½—ã€‚ ã ã‚ˆãï½—ã€‚ ã¾ã‚æ£ç›´ã€ä¸Šè¨˜å…ƒãƒã‚¿ã®ã»ã†ã«ã¯è‰²ã€…çªã£è¾¼ã¿ã©ã“ã‚æº€è¼‰ãªã®ã ãŒã€ãã‚Œã¯ç½®ã„ã¦ãŠãã¨ã—ã¦L.starãªã‚Šã®é«˜é€ŸåŒ–ãƒã‚¤ãƒ³ãƒˆã‚’ä¸€åº¦æ›¸ã„ã¦ãŠã‹ãªã„ã¨ã€ã¨æ€ã£ãŸã®ã§è¨˜ã™ã€‚ãŸã ã€L.starã¯ã‚‚ã†PostgreSQLç•Œéšˆã‹ã‚‰é›¢ã‚Œã¦ä¹…ã—ã„ã®ã§ã€å¿…ãšã—ã‚‚æœ€æ–°ã®å†…å®¹ã‚’ç¶²ç¾…ã—ã¦ã„ãªã„ã“ã¨ã«æ³¨æ„ã•ã‚ŒãŸã—ã€‚ã¾ãŸã€å‡ºæ¥ã‚‹ã ã‘Pos
pmakino 2009/03/02
DB

é«˜é€ŸåŒ–

PostgreSQL
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
pmakino 2009/03/02
DB

é«˜é€ŸåŒ–

PostgreSQL
ãƒªãƒ³ã‚¯
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
pmakino 2009/03/02
DB

é«˜é€ŸåŒ–

PostgreSQL
ãƒªãƒ³ã‚¯
memcachedï¼‹PostgreSQLã§å®Ÿç¾ã™ã‚‹ãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹ç¯‰ï¼ˆ1/4ï¼‰ â€• ï¼ IT
æœ¬ç¨¿ã®å‰æç’°å¢ƒ memcached 1.2.5 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼šPostgreSQL 8.3.1 OSï¼šCentOS 5ï¼ˆLinux kernel 2.6 ï¼‰ ã‚·ã‚§ãƒ«ï¼šbash CPUï¼šIntel Core2Quad 9660 2.4GHz RAMï¼šPC2-6400 8GBytes memcachedã¯ã€Danga Interactiveã«ã‚ˆã£ã¦é–‹ç™ºã•ã‚ŒãŸã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ¡ãƒ¢ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒã§ã™ã€‚ ãƒ¡ãƒ¢ãƒªä¸Šã«ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã®ã§memcachedã‚’çµ‚äº†ã™ã‚‹ã¨ãƒ‡ãƒ¼ã‚¿ãŒå¤±ã‚ã‚Œã¾ã™ãŒã€ï¼ˆOracleã‚„MySQLã¨ã„ã£ãŸï¼‰RDBMSã¨æ¯”è¼ƒã™ã‚‹ã¨ã‘ãŸé•ã„ã®é«˜é€Ÿãƒ¬ã‚¹ãƒãƒ³ã‚¹æ€§èƒ½ã‚’æœ‰ã—ã€æ•°åƒä¸‡ä»¶ã¨ã„ã†å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã£ã¦ã‚‚ã»ã¨ã‚“ã©æ€§èƒ½ãŒåŠ£åŒ–ã—ãªã„ã¨ã„ã†ç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ æ©Ÿèƒ½ã¯é™ç•Œã¾ã§åˆ‡ã‚Šè©°ã‚ã‚‰ã‚Œã€åŸºæœ¬çš„ã«ã¯ã‚ãƒ¼ã¨ãƒ‡ãƒ¼ã‚¿ã®çµ„ï¼ˆä»¥ä¸‹ã€it emã¨å‘¼ã³ã¾ã™ï¼‰ã®ä¿å˜ã¨æ¤œç´¢ã¨å‰Šé™¤ã—ã‹ã§ãã¾ã›ã‚“ã€‚ ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€me
pmakino 2008/08/01
Memcached

PostgreSQL
ãƒªãƒ³ã‚¯
Windows ç‰ˆ DBD::Pg, TrackBack spam - [ã´](2007-05-02)
_ [Perl] Windows ç‰ˆ DBD::Pg DBD::PgPP ã ã¨ã©ã†ã‚‚è¤‡æ•°è¡Œã«æ¸¡ã‚‹ãƒ‡ãƒ¼ã‚¿ãŒå…¥ã£ãŸã‚»ãƒ«ã‚’ SELECT ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ execute failed ã™ã‚‹ã‚ˆã†ã§ä½¿ã„ç‰©ã«ãªã‚‰ã‚“ã®ã§ã€DBD::Pg ã‚’æŽ¢ã™ã€‚ theoryx5 ãƒ¬ãƒã‚¸ãƒˆãƒªã® DBD::Pg 1.45 PPM ã¯ã¾ã¨ã‚‚ã«å‹•ä½œã›ãš (ã‚¨ãƒ©ãƒ¼ã‚‚ç™ºç”Ÿã›ãš1ä»¶ã‚‚ SELECT ã•ã‚Œãªã„) drkkojima@Tsukuba Life: DBD-Pg on Windows (DBD::Pg ã‚’è‡ªåŠ› make å‚™å¿˜éŒ²) How to get a working DBD::Pg on Windows è‡ªåŠ›ã§ make ã™ã‚‹ã®ã¯é¢å€’ã ã€‚ ã“ã“ã‚®ã‚³ï¼: ppmã‚’ä½¿ã£ãŸDBD::Pgã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã“ã‚ŒãŒæœ¬å‘½ã£ã½ã„ã€‚ PgFoundry: DBD-Pg PPM Binaries: Project Info ppm ins
pmakino 2008/06/15
ã‚»ãƒ«ã‚¯ãƒžã€‚

PostgreSQL

Perl

CPAN

Library
ãƒªãƒ³ã‚¯
PostgreSQLã‚’é…ãã—ã¦ã„ã‚‹çŠ¯äººã¯ã©ã“ã ï¼Ÿ
PostgreSQLã‚’é…ãã—ã¦ã„ã‚‹çŠ¯äººã¯ã©ã“ã ï¼Ÿï¼šLinuxãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æŽ¢åµå›£ï¼ˆ3ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ NTTã‚°ãƒ«ãƒ¼ãƒ—ã®å„ç¤¾ã§é³´ã‚‰ã—ãŸä¿ºãŸã¡Linuxãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æŽ¢åµå›£ã¯ã€å„ç¤¾ã§åŸ¹ã£ãŸOSSé–¢é€£æŠ€è¡“ã‚’æ‰‹ã«ã€NTT OSSã‚»ãƒ³ã‚¿ã«é›†ã‚ã‚‰ã‚ŒãŸã€‚æ™®æ®µã¯åŸºæœ¬çš„ã«NTTã‚°ãƒ«ãƒ¼ãƒ—ã®ã¿ã‚’ç›¸æ‰‹ã«æ´»å‹•ã—ã¦ã„ã‚‹ãŒã€ãã‚Œã ã‘ã§çµ‚ã‚ã‚‹ä¿ºãŸã¡ã˜ã‚ƒã‚ãªã„ã€‚å¼•ãç¶šãOSSã«é–¢ã™ã‚‹ãƒˆãƒ©ãƒ–ãƒ«ã®è§£æ±ºéŽç¨‹ã‚’ï¼ ITã§é€£è¼‰ã—ã¦ã„ããœã€‚ ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã•ãˆã‚ã‚Œã°ã©ã‚“ãªãƒˆãƒ©ãƒ–ãƒ«ã§ã‚‚è§£æ±ºã™ã‚‹å‘½çŸ¥ã‚‰ãšã€ä¸å¯èƒ½ã‚’å¯èƒ½ã«ã—ã€å¤šãã®ãƒã‚°ã‚’ç²‰ç •ã™ã‚‹ã€ä¿ºãŸã¡Linuxãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æŽ¢åµå›£ï¼ã€€åŠ©ã‘ã‚’å€Ÿã‚ŠãŸã„ã¨ãã¯ã€ã„ã¤ã§ã‚‚ã„ã£ã¦ãã‚Œï¼ OSï¼šé«˜ç”°å“²ç”Ÿ ä¿ºã¯ãƒªãƒ¼ãƒ€ãƒ¼ã€é«˜ç”°å“²ç”Ÿã€‚Linuxã®é”äººã€‚ä¿ºã®ã‚ˆã†ã«ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ™ãƒ«ã§OSã‚’ç†è§£ã—ã¦ã„ã‚‹äººé–“ã§ãªã‘ã‚Œã°ã€ç™¾æˆ¦éŒ¬ç£¨ã®Linuxãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æŽ¢åµå›£ã®ãƒªãƒ¼ãƒ€ãƒ¼ã¯å‹™ã¾ã‚‰ã‚“ã€‚
pmakino 2008/06/15
DB

PostgreSQL

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
SQLã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã«ãŠã‘ã‚‹ã€Œ\ã€ã®å–ã‚Šæ‰±ã„
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚å…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2008å¹´6æœˆ2æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š æ˜¨æ—¥ã®ã‚¨ãƒ³ãƒˆãƒª(å¾³ä¸¸æµ©ã®æ—¥è¨˜ - ãã‚ãã‚SQLã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã«é–¢ã—ã¦ä¸€è¨€ã„ã£ã¨ãã‹ - SQLã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å†è€ƒ)ã¯æ€ã„ãŒã‘ãšå¤šãã®æ–¹ã«èªã‚“ã§ã„ãŸã ã„ãŸã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ãã®ä¸ã§é«˜æœ¨æµ©å…‰æ°ã‹ã‚‰ãƒ–ã‚¯ãƒžã‚³ãƒ¡ãƒ³ãƒˆã‚’é ‚æˆ´ã—ãŸã€‚ \ãŒescapeç”¨æ–‡å—ã®DBã§\ã®escapeãŒå¿…é ˆã«ãªã‚‹ç†ç”±ãŒæ˜Žç¢ºã«æ›¸ã‹ã‚Œã¦ãªã„ã€‚\'ãŒä¸Žãˆã‚‰ã‚ŒãŸã¨ã'ã ã‘escapeã™ã‚‹ã¨â€¦ã€‚è‡ªä½œescapeã¯å±ã†ã„ã€‚ã€Œå®‰å…¨ãªâ€¦ä½œã‚Šæ–¹ã€3ç‰ˆã§è¿½åŠ ã®ã€Œ3.å¤±æ•—ä¾‹ã€ã§ã¯DBã§ç”¨æ„ã•ã‚ŒãŸescapeæ©Ÿèƒ½ã—ã‹æŽ¨å¥¨ã—ã¦ã„ãªã„ ã“ã®ã†ã¡ã€ã¾ãšã€Œ\ã€ã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãŒå¿…
pmakino 2008/06/05
DB

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

PostgreSQL

MySQL

Perl
ãƒªãƒ³ã‚¯
PostgreSQL ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚ - å¾’ç„¶ãªã‚‹ã¾ã¾ã«Blog
PostgreSQLã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ ãã®æ™‚ã«èª¿ã¹ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é …ç›®ã‚’å‚™å¿˜éŒ²ã¨ã—ã¦æ®‹ã—ã¦ãŠãã¾ã™ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®é•ã„ã‚„ã‚µãƒ¼ãƒã®è¦æ¨¡ãªã©ã«ã‚ˆã£ã¦ã‚‚ åŠ¹æžœã¯å¤‰ã‚ã£ã¦ãã‚‹ã¨æ€ã†ã®ã§ã‚ãã¾ã§å‚è€ƒç¨‹åº¦ã®ã‚‚ã®ã§ã™ãŒã€‚ ãƒ»shared_buffers 7ç³»ã§ã¯8000ã€œ10000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ 8ç³»ã§ã¯150000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ã“ã¨ãŒå¯èƒ½ã€100000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ã“ã‚Œã«å¤šãå‰²ã‚Šå½“ã¦ã‚‹ã‚ˆã‚ŠOSã®ãƒãƒƒãƒ•ã‚¡é ˜åŸŸã¨ã—ã¦ä½¿ã†æ–¹ãŒæ€§èƒ½ãŒå‘ä¸Šã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã‚’å‰²ã‚Šå‡ºã—ã¦è¨å®šã™ã‚‹ã®ãŒãƒ™ã‚¹ãƒˆ ç°¡å˜ã«è¨å®šã™ã‚‹ãªã‚‰æè¼‰ãƒ¡ãƒ¢ãƒªé‡ã®1/4ã€æè¼‰ãƒ¡ãƒ¢ãƒªãŒå¤šã‘ã‚Œã°1/2ãã‚‰ã„ã§ã‚‚å¯ ãƒ»max_connections 7ç³»ã§ã¯256ç¨‹åº¦ã€8ç³»ã§ã¯1000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ãƒ»work_mem(sort_mem) é©åˆ‡ãªã‚µã‚¤ã‚ºã«èª¿æ•´ã™ã‚‹ã€2048ã€œ4096ç¨‹åº¦ ãƒ—ãƒã‚»ã‚¹æ¯Ž
pmakino 2008/04/18
DB

PostgreSQL

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

PostgreSQL

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸