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

terurou id:terurou

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

${{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äº’æ›ç‰ˆâ€Amazon Auroraã®æ€§èƒ½ã¯RDSã®ä½•å€ï¼Ÿ (1/2)
ã‚¢ãƒžã‚¾ãƒ³ ã‚¦ã‚§ãƒ– ã‚µãƒ¼ãƒ“ã‚¹ ã‚¸ãƒ£ãƒ‘ãƒ³ï¼ˆAWSJï¼‰ãŒ7æœˆ5æ—¥ã€AWSä¸Šã§ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰æŠ€è¡“ã‚’ãƒ†ãƒ¼ãƒžã¨ã—ãŸã‚¤ãƒ™ãƒ³ãƒˆã€ŒAWS Solution Days 2017 ï½žAWS DB Dayï½žã€ã‚’é–‹å‚¬ã—ãŸã€‚åŸºèª¿è¬›æ¼”ã§ã¯4åã®ã‚²ã‚¹ãƒˆãŒç™»å£‡ã—ã€Amazon Aurora/RDSã€PostgreSQLã€MySQL/MariaDBã€Oracle DBã€SQL Serverã€Kinesis Firehoseãªã©ã®AWSä¸Šã§ã®æ€§èƒ½æ¤œè¨¼çµæžœã‚„DBç§»è¡Œã€æ´»ç”¨äº‹ä¾‹ãªã©ã‚’æŠ€è¡“çš„å´é¢ã‹ã‚‰ç´¹ä»‹ã—ãŸã€‚ åŸºèª¿è¬›æ¼”ãƒ¬ãƒãƒ¼ãƒˆå‰åŠã§ã¯ã¾ãšã€SRA OSS, Inc.ã®çŸ³äº•é”å¤«æ°ã«ã‚ˆã‚‹ã€ŒAmazon Aurora with PostgreSQL Compatibilityã€ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¤œè¨¼çµæžœå ±å‘Šã€ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã®å°å¹¡ä¸€éƒŽæ°ã«ã‚ˆã‚‹OSSã®ã‚«ãƒ©ãƒ åž‹DBã‚¨ãƒ³ã‚¸ãƒ³ã€ŒMariaDB ColumnStoreã€ç´¹ä»‹ã‚’ãŠå±Šã‘ã™ã‚‹
terurou 2017/07/07
ãƒžãƒãƒ¼ã‚¸ãƒ‰PostgreSQLã¨ã—ã¦è€ƒãˆã‚Œã°ååˆ†ã£ã½ã„ãªã€‚ãŸã ã€Read Replicaã®ã¨ã“ã‚ã¯æ¥å‹™ç¨®åˆ¥ã«ã‚ˆã£ã¦äº‹å‰èª¿æŸ»ãŒå¿…è¦ã«ãªã‚‹ã‹ã€‚

postgresql

AWS

AmazonAurora
ãƒªãƒ³ã‚¯
PostgreSQLã‚¢ãƒ³ãƒãƒã‚šã‚¿ãƒ¼ãƒ³
37. ç©ã¿é‡ãªã‚‹WHEREå¥ -- æœ‰åŠ¹ãªã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒ–ãƒã‚°ã‚’å–ã£ã¦ããŸã„å ´åˆ SELECT * FROM blog INNER JOIN users ON users.id = blog.user_id AND users.delete_ï¬‚ag = 0 WHERE blog.delete_ï¬‚ag = 0 38. ç©ã¿é‡ãªã‚‹WHEREå¥ -- æœ‰åŠ¹ãªã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒ–ãƒã‚°ã‚’å–ã£ã¦ããŸã„å ´åˆ SELECT * FROM blog INNER JOIN users ON users.id = blog.user_id AND users.delete_ï¬‚ag = 0 WHERE blog.delete_ï¬‚ag = 0 ãƒ¦ãƒ¼ã‚¶ã®å‰Šé™¤ãƒ•ãƒ©ã‚°ã‚’è¦‹ã‚‹ 39. ç©ã¿é‡ãªã‚‹WHEREå¥ -- æœ‰åŠ¹ãªã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒ–ãƒã‚°ã‚’å–ã£ã¦ããŸã„å ´åˆ SELECT * FROM blog INNER JOIN users
terurou 2017/06/27
postgresql

è¨è¨ˆ
ãƒªãƒ³ã‚¯
Â» PostgreSQL ã«é–¢ã™ã‚‹æŠ€è¡“æƒ…å ± | æŠ€è¡“æƒ…å ± - SRA OSS
SRA OSS ã§ã¯ã€PostgreSQL ã®æ™®åŠä¿ƒé€²æ´»å‹•ã®ä¸€ç’°ã¨ã—ã¦æŠ€è¡“æƒ…å ±ã‚’å…¬é–‹ã—ã¦ãŠã‚Šã¾ã™ã€‚ çš†æ§˜ã® PostgreSQL æ´»ç”¨ã«æ˜¯éžãŠå½¹ç«‹ã¦ãã ã•ã„ã€‚
terurou 2016/10/14
postgresql
ãƒªãƒ³ã‚¯
PostgreSQL 9.5 æ–°æ©Ÿèƒ½ç´¹ä»‹
â– Java KÃ¼eche å‹‰å¼·ä¼š ã€ŒRDBæœ€å‰ç·šã€ in æ²–ç¸„ è¬›æ¼”è³‡æ–™ ã€ŽPostgreSQL 9.5 æ–°æ©Ÿèƒ½ç´¹ä»‹ã€ NTT DATA æ¾¤ç”° é›…å½¦ @sawada_masahikoRead less
terurou 2015/10/16
FDWãŒã¤ã‚ˆã„ãªâ€¦

postgresql
ãƒªãƒ³ã‚¯
æ˜Žæ—¥ã‹ã‚‰ä½¿ãˆã‚‹Postgre sqlé‹ç”¨ç®¡ç†ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯(ç›£è¦–ç·¨)
3. æœ¬æ—¥ã®ãŠè©± â— é‹ç”¨ç®¡ç†ã® ç›£è¦– ã«ç‰¹åŒ–ã—ãŸè©±ã§ã™ â— ç›£è¦–ã«é‡è¦ã¨ãªã‚‹è€ƒãˆæ–¹ã€è¦³ç‚¹ã¨ã¨ã‚‚ã«ã€ åŸºæœ¬çš„ãªè¨å®šã‚„ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ä¸å¿ƒã«ç´¹ä»‹ã—ã¾ã™ â€“ ã¾ãšã¯ã€Œã“ã‚Œã ã‘ã¯ã‚„ã£ã¦ãŠã“ã†ã€ã¨ã„ã†ã‚¢ãƒ¬ã‚³ãƒ¬ â— PostgreSQLã‚’ä½¿ã†(ä½¿ã£ã¦ã¿ãŸã„)ã“ã¨ã«ãªã£ ãŸã‘ã©ã€ã‚ˆãã‚ã‹ã‚‰ãªãã¦å›°ã£ã¦ã„ã‚‹æ–¹ã®æ‰‹åŠ© ã‘ã«ãªã‚Œã°å¹¸ã„ã§ã™ â— ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ä¾å˜ã—ãŸè©±ã§ã¯ã‚ã‚Šã¾ã›ã‚“ â€“ æ©Ÿèƒ½ä¸Šã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’æ„è˜ã—ãŸè©±ã¯æ³¨é‡ˆã‚’å…¥ã‚Œã¦ã„ ã¾ã™ 4. (ã¡ã‚‡ã£ã¨å¯„ã‚Šé“) æœ€è¿‘ã®PostgreSQL 2011 2012 2013 9.0 9.1 9.2 2010 8ç³» -2009 9.3 2013.9.9 ã«æœ€æ–°ç‰ˆã¨ãªã‚‹ Ver 9.3.0 ãƒªãƒªãƒ¼ã‚¹ï¼ éžåŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ãƒ›ãƒƒãƒˆã‚¹ã‚¿ãƒ³ãƒã‚¤ SQLæ§‹æ–‡å¼·åŒ– åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ UNLOGGED TABLE SQL/MED ã‚«ã‚¹ã‚±ãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ IndexOnl
terurou 2015/03/16
postgresql
ãƒªãƒ³ã‚¯
PostgreSQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®åŸºæœ¬
2. è‡ªå·±ç´¹ä»‹ â€¢ æ°¸å®‰ æ‚Ÿå² ï¼ˆãªãŒã‚„ã™ ã•ã¨ã—ï¼‰ â€¢ ç•¥æ´ â€“ 1997å¹´ã‚ˆã‚Šãƒãƒƒãƒˆãƒ™ãƒ³ãƒãƒ£ãƒ¼ã«ã¦ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºãƒ»é‹ç”¨ã«å¾“äº‹ã€‚ â€“ 2004å¹´ã‚ˆã‚Šï¼ˆæ ªï¼‰ï¼®ï¼´ï¼´ãƒ‡ãƒ¼ã‚¿ã«ã¦ã€ä¸¦åˆ—åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç ”ç©¶é–‹ç™ºã€æŠ€è¡“æ”¯æ´ãƒ»ä¿å®ˆ ã‚µãƒãƒ¼ãƒˆæ¥å‹™ã‚’çµŒã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ã®æ–°è¦ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºã€é‹ç”¨ãƒãƒ¼ãƒ ã®ç«‹ã¡ä¸Šã’ãªã© ã«å‚ç”»ã€‚ â€“ 2009å¹´ã€ã‚¢ãƒƒãƒ—ã‚¿ã‚¤ãƒ ãƒ»ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚ºã‚’å‰µæ¥ã€‚ â€¢ å°‚é–€åˆ†é‡Ž â€“ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã€ä¸¦åˆ—åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã€ã‚¯ãƒ©ã‚¹ã‚¿ã‚·ã‚¹ãƒ†ãƒ â€“ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚¤ãƒ³ãƒ•ãƒ©æŠ€è¡“ â€“ ï¼©ï¼´ã‚µãƒ¼ãƒ“ã‚¹ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆï¼ˆITILï¼‰ã€ITã‚¤ãƒ³ãƒ•ãƒ©é‹ç”¨ç®¡ç†ï¼ˆé‹ç”¨è¨è¨ˆï½žé‹ç”¨ï¼‰ â€¢ æœ¬æ¥ï¼ ã‚¢ãƒƒãƒ—ã‚¿ã‚¤ãƒ ãƒ»ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚º â€“ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹å°Žå…¥ã‚µãƒãƒ¼ãƒˆã‚µãƒ¼ãƒ“ã‚¹ã®æä¾› â€“ ã‚»ãƒŸãƒŠã€ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚°ã®æä¾› â€“ å¦ç¿’ç”¨ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³è²©å£² â€“ ãã®ä»–ã€OSSãŠã‚ˆã³DBç³»æŠ€è¡“ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚° Copyright 20
terurou 2015/03/15
backup

postgresql
ãƒªãƒ³ã‚¯
ã¾ãšã‚„ã£ã¨ãPostgreSQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
1. Copyright Â© 2014 K.K.Ashisuto All Rights Reserved. 1 ã¾ãšã‚„ã£ã¨ã PostgreSQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° æ—¥æœ¬PostgeSQLãƒ¦ãƒ¼ã‚¶ä¼šã€€å–œç”° ç´˜ä»‹ 2014/07/13ç¬¬4å›ž ä¸å›½åœ°æ–¹DBå‹‰å¼·ä¼š 2. Copyright Â© 2014 K.K.Ashisuto All Rights Reserved. 2 è‡ªå·±ç´¹ä»‹ â— åå‰ â— å–œç”° ç´˜ä»‹(ãã ã“ã†ã™ã‘) â— æ‰€å±ž â— æ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼šã€€åºƒå ±ãƒ»ä¼ç”»æ‹…å½“ â— æ ªå¼ä¼šç¤¾ã‚¢ã‚·ã‚¹ãƒˆã€€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“æœ¬éƒ¨ â— è¿‘æ³ â— 2014å¹´åº¦ã‚ˆã‚Šã€JPUGã®ç†äº‹ã«ãªã‚Šã¾ã—ãŸã€‚ â— ä»•äº‹ã§ã¯ã€æ–°è¦æ§‹ç¯‰ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã®DBã‚’ã©ã†ã™ã¹ãã‹ï¼Ÿã¨ã„ã†RDBMSé¸æŠžæ”¯æ´ã‚„ã€ å•†ç”¨DBã‹ã‚‰OSSã¸ã®ç§»è¡Œã®å‰æ®µéšŽã¨ã—ã¦ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚„SQLå·®ç•°ã®ãƒ¬ã‚¯ãƒãƒ£ãƒ¼ã‚„ã€ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨ºæ–ãƒ»è©•ä¾¡ã‚’è¡Œã† ç§»è¡Œã‚¢ã‚»
terurou 2015/03/15
postgresql

performance
ãƒªãƒ³ã‚¯
GitHub - torodb/torodb: The old repository used to store ToroDB related products and libraries
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
terurou 2014/10/30
PostgreSQL jsonbãŒãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®MongoDB APIäº’æ›DBã€‚MongoDBã‚ˆã‚Šãƒžã‚·ã‹ã‚‚ã¨æ€ã‚ã›ã¦ã—ã¾ã†ã®ãŒã‚„ã°ã„

ToroDB

postgresql

MongoDB
ãƒªãƒ³ã‚¯
PostgreSQL Internals
æœ¬ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¯ã€2014å¹´1æœˆ30ï½ž31æ—¥ã«ç‘æ³¢å¤§å¦ã§é–‹è¬›ã•ã‚ŒãŸã€Œæƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ç‰¹åˆ¥è¬›ç¾©Dã€ã«ãŠã‘ã‚‹è¬›ç¾©ã€ŒInside PostgreSQL Kernelã€ã®å†…å®¹ã‚’å†æ§‹æˆã€åŠ ç†ãƒ»ä¿®æ£ã—ãŸã‚‚ã®ã§ã™ã€‚ ã¯ã˜ã‚ã« æœ¬ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã«ã¤ã„ã¦ æœ¬ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¸ã®ãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ã«ã¤ã„ã¦ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£æ¦‚è¦ PostgreSQLã®æ§‹æˆè¦ç´ PostgreSQLã®åŸºæœ¬çš„ãªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ SQLæ–‡ã®å‡¦ç†ã•ã‚Œã‚‹æµã‚Œ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç®¡ç† ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã«ãŠã‘ã‚‹ACIDç‰¹æ€§ å„ãƒ¬ã‚³ãƒ¼ãƒ‰ã®å¯è¦–æ€§ã®ç®¡ç† Atomicityï¼ˆåŽŸåæ€§ï¼‰ã®å®Ÿè£… Consistencyï¼ˆä¸€è²«æ€§ï¼‰ã®å®Ÿè£… Isolationï¼ˆåˆ†é›¢æ€§ï¼‰ã®å®Ÿè£… ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã®å®šç¾© Durabilityï¼ˆæ°¸ç¶šæ€§ï¼‰ã®å®Ÿè£… ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆ ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ç®¡ç† pg_controlãƒ•ã‚¡ã‚¤ãƒ« OID/XID/TID ã‚·ã‚¹ãƒ†ãƒ ã‚«ã‚¿ãƒã‚° MVCCã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸æ§‹é€ ãƒ†
terurou 2014/05/26
postgresql
ãƒªãƒ³ã‚¯
ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ã®ä»£ã‚ã‚Šã«uuidã‚’IDã¨ã—ã¦ä½¿ã†
stop using numbers as IDs. just use UUIDs. seriously â€” Postgres: The Bits You Havenâ€™t Found by pvh UUID ã®é•ã„ v1 Generate a UUID from a host ID, sequence number, and the current time. v3 Generate a UUID from the MD5 hash of a namespace UUID and a name. v4 Generate a random UUID v5 Generate a UUID from the SHA-1 hash of a namespace UUID and a name. ã“ã®å†…ã€ID ã¨ã—ã¦åˆ©ç”¨ã§ãã‚‹ã®ã¯ v1 ã¨ v4 ã®2ã¤ã€‚v1 ã¯æœ€å¾Œ 48 ãƒ“ãƒƒãƒˆãŒãƒãƒ¼ãƒ‰å›ºæœ‰ã®ãƒŽãƒ¼
terurou 2014/01/08
PostgreSQLã£ã¦ã€SQLã§UUIDç”Ÿæˆã§ãã‚‹ã®ã‹

postgresql

UUID
ãƒªãƒ³ã‚¯
AWS News Blog
In the Works â€“ AWS Region in Malaysia We launched an AWS Region in Australia earlier this year, four more (Switzerland, Spain, the United Arab Emirates, and India) in 2022, and are working on regions in Canada, Israel, New Zealand, and Thailand. All told, we now have 99 Availability Zones spread across 31 geographic regions. Malaysia in the Works Today I am happy [â€¦] New â€“ Amazon Lightsail for Res
terurou 2013/11/15
aws

postgresql

AmazonRDS
ãƒªãƒ³ã‚¯
GitHub - DbLinq/dblinq2007: LINQ provider for Oracle, PostgreSQL, MySQL, Ingres, SQLite, Firebird and ... SQL Server
Archived project: this project is not maintained anymore. #Welcome to DbLinq ##LINQ provider for Oracle, PostgreSQL, MySQL, Ingres, SQLite, Firebird and ... SQL Server (C# 3.0) DbLinq is THE LINQ provider that allows to use common databases with an API close to Linq to SQL. It currently supports (by order of appearance): MySQL, Oracle, PostgreSQL, SQLite, Ingres, Firebird... And still SQL Server.
terurou 2008/12/14
SQL Serverä»¥å¤–ã®DBç”¨ã®LINQãƒ‰ãƒ©ã‚¤ãƒ

.net

LINQ

database

C#

oracle

postgresql

SQLite

mysql

Firebird
ãƒªãƒ³ã‚¯
ã¤ã¿ãWeb
terurou 2008/03/18
æ±Žç”¨DBæ“ä½œãƒ„ãƒ¼ãƒ«ã€‚SQLã®å‹•ä½œãƒã‚§ãƒƒã‚¯ã‚’ã¡ã‚‡ã„ã¡ã‚‡ã„ã‚„ã‚‹æ™‚ã«ä½¿ã†

windows

software

database

mysql

postgresql

oracle

odbc

sql
ãƒªãƒ³ã‚¯
PostgreSQLã§åŠ¹çŽ‡çš„ãªè² è·åˆ†æ•£ã‚’å®Ÿç¾ã—ã€ãƒ¢ãƒã‚²ãƒ¼ã‚„mixiã‚’è¿½æ’ƒ â€• TechTargetã‚¸ãƒ£ãƒ‘ãƒ³
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®PostgreSQLã§ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ 10ä»£ã€20ä»£ã‚’ä¸å¿ƒã«æ€¥æ¿€ãªæ™®åŠã‚’è¦‹ã›ã‚‹â€œã‚±ãƒ¼ã‚¿ã‚¤SNSâ€ã€‚ä¼šå“¡æ•°ãŒ865ä¸‡äººã«é”ã™ã‚‹ã€Œãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ã€ã‚„æœˆé–“118å„„ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ï¼ˆPVï¼‰ã‚’èª‡ã‚‹ã€Œmixiã€ï¼ˆç´„6å‰²ãŒãƒ¢ãƒã‚¤ãƒ«çµŒç”±ï¼‰ãªã©ã€å¤§æ‰‹SNSã‚µã‚¤ãƒˆãŒå˜åœ¨æ„Ÿã‚’å¢—ã—ã¦ã„ã‚‹ï¼ˆæ•°å€¤ã¯ã„ãšã‚Œã‚‚2007å¹´12æœˆç¾åœ¨ï¼‰ã€‚ãã†ã—ãŸä¸ã§å…ˆè¡Œçµ„ã‚’æ¿€ã—ãè¿½æ’ƒã—ã¦ã„ã‚‹ã®ãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ãƒ‰ã‚¢ãŒé‹å–¶ã™ã‚‹æºå¸¯é›»è©±å‘ã‘ã®SNSã‚µã‚¤ãƒˆã€Œå¤§é›†åˆNEOã€ã ã€‚ 2007å¹´1æœˆã«ã‚¹ã‚¿ãƒ¼ãƒˆã—ãŸå¤§é›†åˆNEOã¯ã€SNSã®ã¿ãªã‚‰ãšã€ã‚¢ãƒã‚¿ãƒ¼ã‚„ã‚²ãƒ¼ãƒ ã€å°èª¬ã€å‹•ç”»ã€æ—¥è¨˜ã€ãƒãƒ£ãƒƒãƒˆãªã©ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã™ã¹ã¦ç„¡æ–™ã§æ¥½ã—ã‚ã‚‹ã®ãŒç‰¹å¾´ã ã€‚ã‚¢ãƒã‚¿ãƒ¼ã‚„ã‚µã‚¤ãƒˆå†…é€šè²¨ã®ä½¿ã„å‹æ‰‹ã®è‰¯ã•ã§å…ˆè¡Œã‚µã‚¤ãƒˆã¨å·®åˆ¥åŒ–ã‚’å›³ã‚Šã€2007å¹´å¤ã«50ä¸‡äººã ã£ãŸä¼šå“¡æ•°ãŒ2008å¹´2æœˆæ™‚ç‚¹ã§2å€ã®100ä¸‡äººã«é”ã—ã¦ã„ã‚‹ã€‚ ãã®å¤§é›†åˆNEOã®ã‚·ã‚¹ãƒ†ãƒ åŸºç›¤ã‚’æ‹…ã£ã¦ã„ã‚‹ã®ã¯ã€MySQLã¨ã‚ª
terurou 2008/03/03
pgpoolã¨Slony-lã®ç¨¼åƒå®Ÿç¸¾ã€‚

database

postgresql

sns

è² è·åˆ†æ•£

pgpool

Slony-l

äº‹ä¾‹
ãƒªãƒ³ã‚¯
ã€ç‰¹é›†ã€‘æœŸå¾…åº¦å¤§ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ— - PostgreSQL 8.3ã®æ”¹è‰¯ç‚¹ã‚’å¾¹åº•åˆ†æž (1) ã¯ã˜ã‚ã« - PostgreSQL 8.3ã®å¤§ããª4ã¤ã®æ”¹è‰¯ç‚¹ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
ç¾åœ¨ãƒ™ãƒ¼ã‚¿ãƒ†ã‚¹ãƒˆä¸ã®PostgreSQL 8.3ã¯ã€ä¹…ã€…ã«ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸éƒ¨åˆ†ã«æ‰‹ãŒå…¥ã‚‹ãªã©ã€å¤§ããªæ”¹è‰¯ãŒåŠ ãˆã‚‰ã‚Œã¦ã„ã‚‹ã€‚ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®åŸºæœ¬æ§‹é€ éƒ¨åˆ†ã«æ‰‹ãŒå…¥ã‚‹ã®ã¯ã€ç†è€…ã®è¨˜æ†¶ã§ã¯ã€2001å¹´ãƒªãƒªãƒ¼ã‚¹ã®PostgreSQL 7.1ä»¥æ¥ã®ã“ã¨ã§ã‚ã‚‹ã€‚ 8.3ã®æ”¹è‰¯ç‚¹ã¯ã€å¤§ããåˆ†ã‘ã¦ä»¥ä¸‹ã®3ã¤ã«ãªã‚‹ã€‚ 1. æ€§èƒ½é¢ã§ã®æ”¹è‰¯ HOT(Heap Only Tuple)ã¨ã„ã†æ–°ã—ã„ä»•çµ„ã¿ãŒã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸éƒ¨åˆ†ã«å°Žå…¥ã•ã‚Œã€å¾“æ¥PostgreSQLãŒè‹¦æ‰‹ã¨ã—ã¦ã„ãŸã€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹æ›´æ–°å‡¦ç†æ€§èƒ½ãŒå¤§å¹…ã«æ”¹å–„ã•ã‚Œã¦ã„ã‚‹ã€‚ãã®ã»ã‹ã€ãƒžãƒ«ãƒã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥åŠ¹çŽ‡ã®å‘ä¸Šãªã©ãŒç›®ã«ã¤ãã¨ã“ã‚ã§ã‚ã‚‹ã€‚ 2. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é‹ç”¨ç®¡ç†æ©Ÿèƒ½ã®æ”¹è‰¯ PostgreSQLã«é™ã‚‰ãšã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é©åˆ‡ãªç®¡ç†/é‹ç”¨ã¯é›£ã—ã„ã€‚ãã‚Œã ã‘ã§1ã¤ã®è·æ¥ã«ãªã‚‹ã»ã©ã ã€‚8.3ã§ã¯ã€ã‚ˆã‚Šé©åˆ‡ãªç®¡ç†ãŒè¡Œãˆã‚‹ã‚ˆã†ã«ã€ãƒã‚°é …ç›®ãŒå¢—ãˆã¦ã„ã‚‹ã»ã‹ã€é©åˆ‡ãªã‚¤
terurou 2007/11/25
PostgreSQL 8.3ã®æ”¹è‰¯ç‚¹ã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒã‚¤ãƒ³ãƒˆ

database

postgresql

è³‡æ–™

performance
ãƒªãƒ³ã‚¯
1