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

sylvan_l id:sylvan_l

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

${{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: File Browser
8th February 2024: PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released! Quick Links Downloads Packages Source Software Catalogue File Browser File Browser Top â†’ odbc â†’ versions â†’ msi Directories [Parent Directory] Files psqlodbc-07_01_0007.zip2001-09-24 12:45:42192.1Â KB psqlodbc-07_01_0008.zip2001-10-29 11:24:18192.1Â KB psqlodbc-07_01_0009.zip2001-11-27 09:36:32197.0Â KB psqlodbc-07_01_0010.zip
sylvan_l 2009/11/28
ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã‚ºç”¨ã® odbc ãƒ‰ãƒ©ã‚¤ãƒã¯ã“ã“ã‹ã‚‰å–å¾—

postgresql

driver
ãƒªãƒ³ã‚¯
PostgreSQL ODBC Driver æ—¥æœ¬èªžç‰ˆ
PostgreSQL ODBC Driver æ—¥æœ¬èªžç‰ˆã® Windows ç”¨ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ— ãƒ—ãƒã‚°ãƒ©ãƒ Last updated: Thursday, April 11, 2002 PostgreSQL ã¯ã€UNIX ç³»ã® OS ã§å‹•ä½œã™ã‚‹ã€ãƒ•ãƒªãƒ¼ã§é«˜æ©Ÿèƒ½ãª RDBMSï¼ˆãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼‰ã§ã™ã€‚åŒã˜ããƒ•ãƒªãƒ¼ã® MySQL ã¨æ¯”è¼ƒã™ã‚‹ã¨ã€é«˜æ©Ÿèƒ½ãªåˆ†ã€é«˜é€Ÿæ€§ã«ã¯æ¬ ã‘ã¾ã™ãŒã€ãã‚Œã§ã‚‚æ•°åä¸‡ä»¶ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å®Ÿç”¨çš„ãªã‚¹ãƒ”ãƒ¼ãƒ‰ã§æ¤œç´¢ã§ãã‚‹ãªã©ã€ãƒ•ãƒªãƒ¼ã¨ã—ã¦ã¯ååˆ†ãªã‚‚ã®ã‚’å‚™ãˆã¦ã„ã¾ã™ã€‚ åŸºæœ¬ä»•æ§˜ã®ã»ã¨ã‚“ã©ã¯ SQL92 ã«æº–æ‹ ã—ã¦ã„ã‚‹ãŸã‚ã€æ¨™æº–çš„ãªä»•æ§˜ã‚’æŒã¤ RDBMS ã¨ã—ã¦ä½¿ç”¨ã§ãã€é«˜ä¾¡ãªå•†ç”¨ RDBMS ã¨æ¯”ã¹ã¦ã‚‚éœè‰²ãªã„å®Œæˆåº¦ã‚’èª‡ã£ã¦ã„ã¾ã™ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã§ã¯ã€Windows ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯çµŒç”±ã§ PostgreSQL ã«æŽ¥ç¶šã™ã‚‹ã¨ãã«å¿…è¦ã¨ãªã‚‹ã€PostgreS
sylvan_l 2009/11/28
postgresql

driver
ãƒªãƒ³ã‚¯
PostgreSQLã§ä½¿ã†ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã‚½ãƒ•ãƒˆã‚’A5:SQL Mk-2ã«ä¹—ã‚Šæ›ãˆãŸ
ã“ã‚“ã«ã¡ã¯ã€å²¡æœ¬ã§ã™ çªç„¶ã§ã™ãŒæ˜Žæ—¥ã‹ã‚‰ã‚¢ã‚·ã‚¢ãƒ«æ’ä¾‹ã€ã‚·ãƒªã‚³ãƒ³ãƒãƒ¬ãƒ¼ç ”ä¿®æ—…è¡Œã«è¡Œã£ã¦ã¾ã„ã‚Šã¾ã™ã€‚ åˆã‚ã¦ã®æµ·å¤–æ—…è¡Œã§ä¸å®‰ã ã‚‰ã‘ã§ã™ãŒã€ å¯èƒ½ãªé™ã‚Šã€å‘ã“ã†ã®ãƒ“ã‚¸ãƒã‚¹ã®ã‚„ã‚Šæ–¹ãƒ»åƒãæ–¹ã‚’å¦ã‚“ã§ã“ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ãã‚Œã¯ã•ã¦ãŠãã€å…¨å›½æŽ¨å®šï¼‘åƒä¸‡äººã®PostgreSQLæ„›å¥½å®¶ã®çš†æ§˜ã€ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã‚½ãƒ•ãƒˆã¯ä½•ã‚’ãŠä½¿ã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ æœ€è¿‘ã€DBDesignerã®PostgreSQLå¯¾å¿œç‰ˆã‹ã‚‰ã€ ã€ŒA5:SQL Mk-2ã€ã«ä¹—ã‚Šæ›ãˆãŸã®ã§ã€ä»Šæ—¥ã¯A5ã«ä¹—ã‚Šæ›ãˆã¦è‰¯ã‹ã£ãŸã“ã¨ã‚’æ›¸ã“ã†ã¨æ€ã„ã¾ã™ã€‚ å°šã€ï¼‘å¹´åŠå‰ã«ã‚¢ã‚·ã‚¢ãƒ«ãƒ–ãƒã‚°ã§ ãƒ•ãƒªãƒ¼ã§ä½¿ãˆã‚‹DBã®ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚ ã‚’å…¬é–‹ã—ãŸæ™‚ã€å¼Šç¤¾æ£®å·ã¯Postgresç”¨ã«ã€ŒClayã€ã‚’ãŠå‹§ã‚ã—ã¦ãŠã‚Šã¾ã—ãŸãŒã€ A5ã®æ–¹ãŒç„¡æ–™ã§å…¨ã¦ã®æ©Ÿèƒ½ã‚’ä½¿ãˆã‚‹ã®ã§å°Žå…¥ã—ã‚„ã™ã„ã‹ã¨æ€ã„ã¾ã™ã€‚ â– ä½¿ã£ã¦ã¿ã¦è‰¯ã‹ã£ãŸç‚¹ ãƒ»æ“ä½œæ€§ãŒéžå¸¸ã«è‰¯ã„ å…¨ä½“çš„ã«ã‚µã‚¯ã‚µã‚¯å‹•ãã¾ã™ï¼ˆDBD
sylvan_l 2009/11/28
postgresql

tool
ãƒªãƒ³ã‚¯
sfPropel13Pluginã‚’å°Žå…¥ã—ãŸã¨ãã®æ³¨æ„ç‚¹ã¾ã¨ã‚ - ãƒ¢ãƒŽãƒŽãƒ•æ—¥è¨˜
symfony1.0.Xã§Propel1.3ã®DBãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒä½¿ã„ãŸã„ï¼ã¨ã„ã†ç†ç”±ã ã‘ã§sfPropel13Pluginã‚’å°Žå…¥ã—ã¦ã¿ãŸã®ã§ç°¡å˜ã«æ‰‹é †ã‚’ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« SVNãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ãƒ—ãƒ©ã‚°ã‚¤ãƒ³æœ¬ä½“ã‚’ã‚²ãƒƒãƒˆã™ã‚Œã°çµ‚äº†ã§ã™ã€‚ãƒã‚§ãƒƒã‚¯ã‚¢ã‚¦ãƒˆã§ã‚‚ã„ã„ã¨æ€ã„ã¾ã™ãŒã€1.2ã§ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§Propel1.3ãŒå°Žå…¥ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‹ã‚‰ã€ã‚‚ã†æ›´æ–°ã¯ãŠãã‚‰ãç„¡ã„ã®ã§è‡ªåˆ†ã®ãƒªãƒã‚¸ãƒˆãƒªã«å…¥ã‚Œã‚‹ã‚ˆã†ã«exportã—ã¦ã¾ã™ã€‚ $ svn export http://svn.symfony-project.com/plugins/sfPropel13Plugin/ plugins/ å°Žå…¥(åŸºæœ¬ç·¨) ã¾ãšdatabase.ymlã‚’Propel1.3ä»•æ§˜ã«æ›¸ãæ›ãˆã¾ã™ã€‚dsnã®ä»•æ§˜ã¯PHP: PDO_MYSQL DSN - Manualã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ all: propel: class:
sylvan_l 2009/10/21
postgresql ã§ addGenericMutators = true ãŒãªã„ã¨ setByPosition ãŒãªã„ã£ã¦æ€’ã‚‰ã‚Œã‚‹

postgresql

symfony
ãƒªãƒ³ã‚¯
postgresql configure 8.3 - Google æ¤œç´¢
2019/12/28 Â· PostgreSQL 11. JITå¯¾å¿œã«é–¢é€£ã™ã‚‹ with-llvm ã®è¿½åŠ ã¨ã€ init db ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¨ã—ã¦æŒ‡å®šå¯èƒ½ã«ãªã£ãŸã€ with-wal-segsize ãŒå‰Šé™¤ã•ã‚ŒãŸã€‚
sylvan_l 2009/10/14
postgresql

install
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: PostgreSQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•
å…ˆæ—¥æ›¸ã„ãŸã€ŒMySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•ã€ã«ã¤ã„ã¦ã€PostgreSQL ã§ã‚‚ pg_stat_activity ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ã£ã¦å®Ÿè¡Œä¸ã®ã‚¯ã‚¨ãƒªä¸€è¦§ã‚’å–å¾—ã§ãã‚‹ã¨ higepon ã•ã‚“ã«æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸã®ã§ã€ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ % ppdump > ppdump.txt ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªã‚’ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚° (ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§100ç§’é–“ç¨‹åº¦) ã—ã¦ã€ % ppfilter < ppdump.txt | ppreport ã®ã‚ˆã†ã«ã™ã‚‹ã¨ã€å¹³å‡è² è·ã®é«˜ã„ã‚¯ã‚¨ãƒªã‹ã‚‰é †ã«ã‚½ãƒ¼ãƒˆã•ã‚Œã¦è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚è©³ã—ã„ä½¿ã„æ–¹ã‚„è€ƒãˆæ–¹ã«ã¤ã„ã¦ã¯ã€mprofile ã®ã‚¨ãƒ³ãƒˆãƒªã‚’ã”å‚ç…§ãã ã•ã„ã€‚ pprofile ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ã€/platform/postgresql/pprofile â€“ CodeRepos::Share â€“ Tracã«ç½®ã„ã¦ã‚ã‚Šã¾ã™ã€‚è² è·ãŒé«˜ã„ PostgreSQL ç’°å¢ƒãŒæ‰‹å…ƒã«ãªã„ã®
sylvan_l 2009/08/04
postgresqlã‚’ä½¿ã†å ´åˆã¯å‚è€ƒã«ã™ã‚‹

postgresql

performance

sql

tuning

db

database
ãƒªãƒ³ã‚¯
ç¬¬3å›žã€€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã€ŒPostgreSQLã€ã®åˆ©ç”¨ãƒŽã‚¦ãƒã‚¦
ä»Šå›žã¯ï¼ŒPostgreSQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã«ã¤ã„ã¦è§£èª¬ã™ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼ˆä»¥å¾Œãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼‰ã¨ã¯ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚·ã‚¹ãƒ†ãƒ ã«å•åˆã‚ã›ã‚’æŠ•ã’ã¦è¿”ã£ã¦æ¥ã‚‹ã¾ã§ã®æ™‚é–“ï¼ˆå¿œç”æ€§ï¼‰ã‚„ï¼Œå¹³å‡çš„ãªå‡¦ç†ã‚¹ãƒ”ãƒ¼ãƒ‰ï¼ˆã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆï¼‰ã‚’æ”¹å–„ã™ã‚‹ä½œæ¥ã‚’æŒ‡ã™ã€‚åŽ³å¯†ã«ã¯å¿œç”æ€§ã‚’æ”¹å–„ã™ã‚‹ã®ã‹ï¼Œã¨ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã‚’æ”¹å–„ã™ã‚‹ã®ã‹ã§ã¯ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°å†…å®¹ãŒç•°ãªã‚‹ã“ã¨ãŒã‚ã‚‹ãŒï¼Œã“ã“ã§ã¯ã‚ã¾ã‚Šç´°ã‹ã„ã“ã¨ã«ã¯ã“ã ã‚‰ãªã„ã“ã¨ã«ã™ã‚‹ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã¯PostgreSQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã£ã¦ã‚‚å¤‰åŒ–ã™ã‚‹ãŒï¼Œæœ¬ç¨¿ã§ã¯PostgreSQL 8.4ã‚’å‰æã¨ã™ã‚‹ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆã¯ä¸»ã«ä»¥ä¸‹ã§ã‚ã‚‹ã€‚ 1ï¼‰PostgreSQLè¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã®èª¿æ•´ 2ï¼‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç‰©ç†è¨è¨ˆ ã“ã‚Œã‚‰ã‚’é †ã«è§£èª¬ã™ã‚‹ã€‚ PostgreSQLè¨å®šãƒ•
sylvan_l 2009/07/26
postgresql

database

db

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š - ã‚ˆãã®ã¯ã¦ãª
ã“ã“ã®ã¨ã“ã‚ã€javaccã¨awsã«é…äº†ã•ã‚Œã¦ã„ã‚‹ç±³æž—ã§ã™ã€‚ ã‚ˆãä½¿ã†DB(Oracle/MySQL/PostgreSQL/SQLServer)ã«ãŠã‘ã‚‹è¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Šã§ä½¿ã†ã‚µã‚¤ãƒˆã®å‚™å¿˜éŒ²ã€‚ ã‚ã¨ã¯ã€Oracleã‹ã‚‰ã®Pythonæƒ…å ±ã€‚ Oracle Oracle ç‰©ç†è¨è¨ˆ http://www.oracle.com/techno logy/global/jp/columns/skillup/oracle9i/index.html é ˜åŸŸã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š http://otn.oracle.co.jp/document/estimate/index.html OTNã«ãƒã‚°ã‚¤ãƒ³ã™ã‚‹å¿…è¦ã‚ã‚Šã¾ã™ãŒã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§è¦‹ç©ã‚‚ã‚ŠãŒå‡ºæ¥ã¾ã™ã€‚ ã‚¢ã‚«ã‚¦ãƒ³ãƒˆæŒã£ã¦ã„ãªã„äººã¯ã€ã“ã®è¦‹ç©ã‚‚ã‚Šãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ç›®çš„ã§ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½œã£ã¦ã¿ã¦ã¯ã„ã‹ãŒã§ã—ã‚‡ã†ã‹ã€‚ OLTPç³»ã¨DWHç³»ã«ãŠã„ã¦ãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºã‚’è€ƒæ…®ã—ã€DWHç³»ã¯ãƒ–
sylvan_l 2009/05/14
oracle

db

mysql

postgresql

database

size
ãƒªãƒ³ã‚¯
æ•™ãˆã¦ï¼ Watch postgresã«æŽ¥ç¶šã§ããªã„
sylvan_l 2009/05/13
listen_addressesã¨pg_hba.conf

postgresql

network
ãƒªãƒ³ã‚¯
dfltweb1.onamae.com â€“ ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ãŠåå‰.comã§å–å¾—ã•ã‚Œã¦ã„ã¾ã™ã€‚
ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ ãŠåå‰.com ã‹ã‚‰å–å¾—ã•ã‚Œã¾ã—ãŸã€‚ ãŠåå‰.com ã¯ GMOã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‚°ãƒ«ãƒ¼ãƒ—(æ ª) ãŒé‹å–¶ã™ã‚‹å›½å†…ã‚·ã‚§ã‚¢No.1ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ç™»éŒ²ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ â€»è¡¨ç¤ºä¾¡æ ¼ã¯ã€å…¨ã¦ç¨Žè¾¼ã§ã™ã€‚ â€»ã‚µãƒ¼ãƒ“ã‚¹å“è³ªç¶æŒã®ãŸã‚ã€ä¸€æ™‚çš„ã«å¯¾è±¡ã¨ãªã‚‹æ–™é‡‘ã¸ä¸€å®šå‰²åˆã®ã€Œã‚µãƒ¼ãƒ“ã‚¹ç¶æŒèª¿æ•´è²»ã€ã‚’åŠ ç®—ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ â€»1 ã€Œå›½å†…ã‚·ã‚§ã‚¢ã€ã¯ã€ICANN(ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®ãƒ‰ãƒ¡ã‚¤ãƒ³åãªã©ã®è³‡æºã‚’ç®¡ç†ã™ã‚‹éžå–¶åˆ©å›£ä½“)ã®å…¬è¡¨æ•°å€¤ã‚’ã‚‚ã¨ã«é›†è¨ˆã€‚gTLDãŒé›†è¨ˆã®å¯¾è±¡ã€‚ æ—¥æœ¬ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ç™»éŒ²æ¥è€…(ãƒ¬ã‚¸ã‚¹ãƒˆãƒ©)ï¼ˆã€ŒICANNãŒãƒ¬ã‚¸ã‚¹ãƒˆãƒ©ã¨ã—ã¦èªå®šã—ãŸä¼æ¥ã€ä¸€è¦§ï¼ˆInterNICæä¾›ï¼‰å†…ã«ã€ŒJapanã€ã®è¨˜è¼‰ãŒã‚ã‚‹ã‚‚ã®ï¼‰ã‚’å¯¾è±¡ã€‚ ãƒ¬ã‚¸ã‚¹ãƒˆãƒ©ã€ŒGMO Internet Group, Inc. d/b/a Onamae.comã€ã®ã‚·ã‚§ã‚¢å€¤ã‚’é›†è¨ˆã€‚ 2024å¹´5æœˆæ™‚ç‚¹ã®èª¿æŸ»ã€‚
sylvan_l 2009/02/01
postgresql

db

database

pgpool-ll

php
ãƒªãƒ³ã‚¯
ã©ã†ã‚‚ä¸–é–“ã§ã¯ã€æ€ã£ãŸã‚ˆã‚ŠDBã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒä¸è¶³ã—ã¦ã„ã‚‹æ§˜ã : ä¸å€’åŸŽ
ã¡ã‚‡ã£ã¨æŠ€è¡“çš„ãªè©±ã€‚oracleåˆ†ã‹ã‚‹äººã«ã—ã‹åˆ†ã‹ã‚‰ãªã„ã‹ã‚‚ã€‚ æœ€è¿‘å–å¼•å…ˆã®ã‚·ã‚¹ãƒ†ãƒ ã‚’è¦‹ã‚‹æ©Ÿä¼šãŒä½•åº¦ã‹ã‚ã£ãŸã®ã ãŒã€æ˜¨æ—¥ã™ã‚“ã”ã„ã¨ã“è¦‹ãŸã€‚ DBãŒé‡ãã¦æ¥å‹™ã«ãªã‚‰ãªã„ã¨ã„ã†ã‹ã‚‰ã€ã¡ã‚‡ã£ã¨ä¸ã‚’è¦—ã‹ã›ã¦ã‚‚ã‚‰ã£ãŸã‚‰ã‚‚ã†ã‚¨ãƒ©ã„ã“ã£ã¡ã‚ƒã€‚ ãƒ»æ¥å‹™ãƒã‚¸ãƒƒã‚¯ã®æ®†ã©ã‚’ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ãƒ»ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã§æ§‹æˆã—ã¦ã„ã‚‹ã€‚ãªã®ã«ã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ’ãƒƒãƒˆçŽ‡ãŒå¦™ã«ä½Žã„ã€‚ ãƒ»èª¿ã¹ã¦ã¿ã‚ˆã†ã¨æ€ã£ãŸã‚‰ä¸€å›žã‚‚statspackãŒå–å¾—ã•ã‚Œã¦ã„ãªã„ã€‚(æ‹…å½“è€…ã«ã¯ã€ã€Œstatspack?syslogãªã‚‰ã¨ã£ã¦ã‚ã‚‹ã‚“ã§ã™ãŒâ€¦ã€ã¨è¨€ã‚ã‚ŒãŸ) ãƒ»å„ãƒ†ãƒ¼ãƒ–ãƒ«ã®indexãŒã©ã†ã„ã†è¨³ã‹å…¨åˆ—ã«è²¼ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ã¡ãªã¿ã«indexã¯å…¨ãƒ†ãƒ¼ãƒ–ãƒ«ä¾‹å¤–ãªããã®ä¸€å€‹ã ã‘(ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‚’é™¤ã‘ã°ã ãŒ)ã€‚ ãƒ»ã¨æ€ã£ãŸã‚‰ã€PKãŒæ–‡å—åˆ—ã ã£ãŸã‚Šã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã¡ã‚‰ã“ã¡ã‚‰ã«ã‚ã‚‹ã€‚ ãƒ»è©¦ã—ã«ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä¸€ã¤äºŒã¤è¦‹ã¦ã¿ãŸã‚‰ã€ãªã‚“ã‹æ™®é€šã«ã‚¯ãƒã‚¹çµåˆã•ã‚Œã¾ãã£ã¦ã„ã¦ã¡ã‚‡ã£ã¨ãã‚‰ã£
sylvan_l 2009/01/21
database

db

oracle

vacuum

postgresql
ãƒªãƒ³ã‚¯
MYCOMã‚¸ãƒ£ãƒ¼ãƒŠãƒ« - ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º - ã‚³ãƒ©ãƒ - Yet Anotherä»•äº‹ã®ãƒ„ãƒ¼ãƒ«
Copyright (C) Mainichi Communications Inc. All rights reserved. æŽ²è¼‰è¨˜äº‹ã®ç„¡æ–è»¢è¼‰ã‚’ç¦ã˜ã¾ã™
sylvan_l 2008/11/26
imported

PostgreSQL

php

tips
ãƒªãƒ³ã‚¯
http://plnet.jp/komagata/940699
sylvan_l 2008/11/25
ã‹ã‚“ãŸã‚“ãƒã‚¹ã‚°ãƒ¬ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

imported

postgresql

tuning
ãƒªãƒ³ã‚¯
PostgreSQLã‚’ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§æ“ä½œã™ã‚‹
ä»Šå›žã®ãŠã‚‚ãªå†…å®¹ ã‚½ãƒ¼ã‚¹ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã¨ãƒã‚¤ãƒŠãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« PostgreSQLã®åˆæœŸåŒ– ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’æ“ä½œã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ selectæ–‡ã§æ¤œç´¢ psqlã§ä½¿ãˆã‚‹ã‚³ãƒžãƒ³ãƒ‰ä¸€è¦§ PostgreSQLã¯ã€Linuxã‚„FreeBSDãŠã‚ˆã³ä¸€éƒ¨ã®å•†ç”¨UNIXã§ã¯ã€ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚·ã‚¹ãƒ†ãƒ ã‚’ç”¨ã„ã¦ç°¡å˜ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ã€‚ãŸã ã—RedHatç³»ã®Linuxï¼ˆRedHatã‚„Turbo Linuxã€Vine Linuxãªã©ï¼‰ã§ã¯ã€/usrç›´ä¸‹ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªï¼ˆ/usr/binã‚„/usr/libï¼‰ã«ãƒ•ã‚¡ã‚¤ãƒ«ãŒé…ç½®ã•ã‚Œã¦ã€å¾Œã§ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã™ã‚‹å ´åˆãªã©ã«å°‘ã—æˆ¸æƒ‘ã„ã‚’æ„Ÿã˜ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ï¼ˆå˜ã«ç†è€…ã ã‘ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒ^^;;ï¼‰ã€‚ ãã†ã„ã†ã¨ãã¯ã€ãœã²ã¨ã‚‚PostgreSQLã‚’ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¾ã—ã‚‡ã†ã€‚ãã®æ‰‹é †ã‚’ç´¹ä»‹ã—
sylvan_l 2008/11/25
imported

postgresql

pgsql
ãƒªãƒ³ã‚¯
PostgreSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã«ã€€ï½žé‡ã„SQLã®è¦‹ã¤ã‘æ–¹ï½ž : ã‚¢ã‚·ã‚¢ãƒ«ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ç‰§é‡Žã§ã™ã€‚ å…ˆæ—¥ã€ã‚ã‚‹ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã§ä½¿ç”¨ã—ã¦ã„ã‚‹PostgreSQLã‚’è¦‹ç›´ã™æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚ PostgreSQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ‰‹è»½ã«ä¸Šã’ã‚‹ã«ã¯ã€ ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’å¤‰æ›´ã™ã‚‹ ãƒ»ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ–¹ã§é‡ã„SQLã‚’ç™ºè¡Œã—ã¦ã„ã‚‹å ´æ‰€ã‚’è¦‹ã¤ã‘ã¦ã€ãã®éƒ¨åˆ†ã‚’ç›´ã—ã¦ã„ã ãƒ»vaccumã‚’å®Ÿè¡Œã™ã‚‹ ãªã©ã€ã„ãã¤ã‹æ–¹æ³•ãŒè€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ ä»Šå›žã¯ã€PostgreSQLã§å®Ÿè¡Œæ™‚é–“ãŒé•·ã„SQLã‚’è¦‹ã¤ã‘ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ æœ¬é¡Œã«å…¥ã‚‹å‰ã«ã€ã¾ãšã¯ãƒ†ã‚¹ãƒˆç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã£ã¦ãŠãã¾ã™ã€‚ <?php $dbÂ =Â pg_connect('dbname=test'); $sqlÂ =Â " CREATEÂ TABLEÂ artistÂ ( artist_idÂ serialÂ primaryÂ key, nameÂ textÂ notÂ null ) "; pg_query($sql); $sq
sylvan_l 2008/11/25
postgresql

tuning
ãƒªãƒ³ã‚¯
Enterprise Postgres Query Analyser
sylvan_l 2008/11/25
postgresql

analyser
ãƒªãƒ³ã‚¯
1