èµ·ãã£ãïŒ

åœç€Ÿã¯ãPostgreSQLããã¥ã¡ã³ãã®çŸåšã®ããŒãžã§ã³ã®ãã·ã¢èªãžã®ç¿»èš³ãå
¬åŒã«å®äºããŸããããã®åºçç©ã§ã¯ããããã©ã®ããã§ãã£ããããäŒãããããšæããŸãã ãŸãããã®ç®æšãéæããããã«è¡ã£ããã¹ïŒããã³ã©ã®ãããªæ¹åæ§ã詊ã¿ããïŒã«ã€ããŠã話ããããšæããŸãããããã¯ããããå¥ã®èšäºã®ãããã¯ã§ãã
PostgreSQLèªäœã®ãã·ã¢èªãžã®ç¿»èš³ã¯2001幎ã«å§ãŸãããã®åŸãpostgresql 7.1ã®ããŒãžã§ã³ã®ã¿ããªãªãŒã¹ãããpostgresqlèªäœã§ã¯ãéçºè
ã®åªåã«ã¯ã¡ãã»ãŒãžãããŒã«ã©ã€ãºããæ©èœã®ã¿ãå«ãŸããŠããŸããïŒ
ãã¡ããåç
§ïŒã ã¡ãã»ãŒãžã®ãã·ã¢èªãžã®ç¿»èš³ãããã©ã³ã¹èªããã€ãèªãã¹ãŠã§ãŒãã³èªãäžåœèªããã§ã³èªãžã®ç¿»èš³ãšãšãã«ãããŒãžã§ã³7.2ã«åããŠå«ãŸããŸããã
åºã«ã¯ãšã³ã³ãŒãã£ã³ã°KOI8-RããããŸããã Windows 2000ãLinux 2.4.1ãRHEL 2.1ãDebian Woodyã pgadmin IIã UbuntuïŒ ããããèããŠããŸããã
ãµãŒããŒ7.2ã§ã¯ãçŽ30ïŒ
ã®ã¡ãã»ãŒãžããã·ã¢èªã«ç¿»èš³ãããŸããïŒ3205ãã881ã¡ãã»ãŒãžïŒã ãµãŒããŒ7.2ã®ããã¥ã¡ã³ãã«ã¯çŽ1000ããŒãžããããŸããã 2005幎1æ-ããŒãžã§ã³8.0ã§ã¯ãçŽ80ïŒ
ã翻蚳ãããŸããïŒ2888ã¡ãã»ãŒãžïŒã Windows 2003ãLinux 2.6.10ãRHEL 4ãDebian SargeãUbuntu-ãã§ã«ãããŒã®ããããšãèããããšããããŸãã
ããŒãžã§ã³9.0ã§ã¯ã翻蚳ã®å²åã¯64ïŒ
ïŒ2765ã¡ãã»ãŒãžïŒã«æžå°ããŸããã
æåŸã«ã2012幎ã«ããŒãžã§ã³9.2ã§è¿œãã€ããŸãã-100ïŒ
ïŒ6388ã¡ãã»ãŒãžïŒã ïŒããŒãžã§ã³9.5ã§ã¯ã7675ã®ã¡ãã»ãŒãžã翻蚳ãããŠããŸãã翻蚳ä»ãã®ã¡ãã»ãŒãžã®ãµã€ãºã¯çŽ1.8 MBã§ããïŒ
ãã®åŸããã£ã𿬲ããã£ãã pgadminãšãã®ãµã€ãã®ç¿»èš³ä»¥äžã ã¯ããã«ã ããã«å€ãã®ããã¥ã¡ã³ããèŠã€ãããŸããã å
¬åŒãµã€ãã«ã¯ããã©ã³ã¹èªã𿥿¬èªã®ç¿»èš³ã®ã¿ãžã®ãªã³ã¯ããããŸããã ããã¯ææŠã§ãïŒ 9.3ã®ãªãªãŒã¹ã®æç¹ã§ãããã¥ã¡ã³ãã¯ãã§ã«çŽ2000ããŒãžãå ããŠããŸããïŒãªãªãŒã¹ããŒããé€ãïŒã®ã§ãããããŸãææŠã§ãïŒ ããã¥ã¡ã³ãã翻蚳ãã詊ã¿ã¯ãã§ã«è¡ãããŠããããšã«æ³šæããå¿
èŠããããŸãã æ
å ±ãä¿åãããŠããæåã®
ããŒãžã§ã³ã¯ãããŒãžã§ã³6.5.2ã®ããã¥ã¡ã³ãã®ç¿»èš³ã§ããããããã20äžçŽã«ããã®ãŒãã»ã«ã®ãšãããµãåºèº«ã®è¥ããŠç±ãç·ãã¡ã«ãã£ãŠäœæãããããã§ãã
ãã®åŸããã§ã«å¥ã®ç¿»èš³ããããŸãããããã§ã«ç§ãã¡ã®æä»£ã«ã¯ãããŸããããå®å
šã§ã¯ãªãããã®åè³ªã¯æãŸããŠããŸããã§ããã ãŸã倱æããå¥ã®è©Šè¡ã®ãã¬ãŒã¹ãèŠã€ããããšãã§ããŸãã ãããã£ãŠãæ°ãããã®ãæŽããããç°¡åã«æã«å
¥ããšå€æãããŸããã ãããŠå¥ã®å®¶æã§ã
2013幎ã®åãã«ãããã¥ã¡ã³ãã®æåã®2ã€ã®ã»ã¯ã·ã§ã³ïŒçŽ400ããŒãžïŒã®ç¿»èš³ãå®äºããå
¬éãããŸããã 2015幎ã«åœç€Ÿãèšç«ãããããã¥ã¡ã³ãã®ç¿»èš³ãå®äºããããã«åªå
é äœã®1ã€ãéžæãããŸããã ãããŠãä»äºã¯æ²žéš°ãå§ããŸããã å
¥ãå£ã§ã¯ãããŒãžã§ã³9.4ã®ããã¥ã¡ã³ãã2000ããŒãžã«ãããæåã¯400ã«ç¿»èš³ãããŠããŸããã6æ25ïŒ
ã翻蚳ããã12æ57ïŒ
ã4æã«9.4ã®ããã¥ã¡ã³ãã®ç¿»èš³ãå®äºããŸããã 2016幎5æã«ã翻蚳ã¯ããŒãžã§ã³9.5ãšåæãããå®å
šã«ãã·ã¢èªã®ããã¥ã¡ã³ãïŒ2xxxããŒãžã翻蚳ã«äŒŽãçããã¹ãã®ããªã¥ãŒã ã18 MBïŒãåãåããŸããã
ããã«ææžããããŸãïŒ
æåŸã«ãçŸåšãããŒãžã§ã³9.6ïŒbeta2ãbeta3ã...ïŒãšåçã§ããã補åã®ãªãªãŒã¹æã«å®å
šãªããã¥ã¡ã³ãããã·ã¢èªã§ãªãªãŒã¹ããŸãã
幞ããªããšã«ãã¯ããŒãºããã¹ããè¡ââãããŠããRUS-Studioã®ç¹æ®ããŒãžã§ã³ãå©çšããããšãã§ããŸããã ããã«ãããç¿»èš³ã®æ®µéã§ããã¹ãã確èªãããšã©ãŒãç¹å®ããããšãã§ããŸããããšã©ãŒã®ããã€ãã¯ã以äžã®ç®çã®ããã«æ¥œããã§ãããæ€èšããŸãã ãã®çš®ã®ãšã©ãŒã¯ã©ãã«ã§ãèŠãããŸãããç§ãã¡ã®ééãã§ããããç§ãã¡ã«ã¯æ£ããããšããããŸãã
ç§ãã¡ã®çç ã¯ã©ã€ã¢ã³ãã¢ããªã±ãŒã·ã§ã³ããµãŒããŒã«æ¥ç¶ãããšãUnixã©ã€ã¯ãªOSã§ã®éåžžã®ãŠãŒã¶ãŒãã°ã€ã³ãšåæ§ã«ãPostgreSQLãŠãŒã¶ãŒåã瀺ãããŸãã
RUS-StudioèŠåïŒW203è±èªã®ãããªæãæ€åºãããŸããã
ããã«ãããããé«ãã¬ãã«ã®ä¿¡é Œæ§ãæäŸãããŸãããããã2ã€ã®ãµãŒããŒã®ã€ã³ã¹ããŒã«ããã³æ§æäžã«ã·ã¹ãã 管çè
ãæ³šææ·±ãäœæ¥ããå Žåã®ã¿ã§ãã
質åRUS-StudioïŒQ088ããã«ãããªãã®ä»äºã¯ã©ãã»ã©äžå¯§ã§ããïŒ
ããšãã°ãã¢ããªã±ãŒã·ã§ã³ã®ã©ã€ããµã€ã¯ã«ã§ã¯ã倿Žã®10ïŒ
ãéèŠãªé¡§å®¢ããŒã¿ã§ãããä»ã®90ïŒ
ã®å€æŽã¯ããžãã¹ã«ãšã£ãŠããã»ã©éèŠã§ã¯ãªãã倱ãããå ŽåïŒãŠãŒã¶ãŒéã®ãã£ãããªã©ïŒã«ç°¡åã«åŸ©å
ã§ããŸãã
ãªãªãžãã«ïŒ
ããšãã°ãã¢ããªã±ãŒã·ã§ã³ã®ã¯ãŒã¯ããŒãã¯ã次ã®ãã®ã§æ§æãããŸãïŒå€æŽã®10ïŒ
ã¯éèŠãªé¡§å®¢ã®è©³çްã§ããã倿Žã®90ïŒ
ã¯éèŠæ§ã®äœãããŒã¿ã§ããããŠãŒã¶ãŒéã®ãã£ããã¡ãã»ãŒãžãªã©ãããžãã¹ã倱ãããŠãããç°¡åã«çãæ®ãããšãã§ããŸãã
RUS-Studioãšã©ãŒïŒA000 FalsehoodïŒ "Workload"ïŒ= "Life Cycle"
RUS-Studioãšã©ãŒïŒA000 FalsehoodïŒãããžãã¹ã¯çãæ®ããŸããïŒã=ããŠãŒã¶ãŒéã®ãã£ããã埩å
ãããŸããã
ãŠãŒã¶ãŒã¯ãäž»èŠãµãŒããŒã§æŽæ°è² è·ãé«ãããŒãã«ã¯ãããã¯ã¢ããã§ã®é·ãã¯ãšãªã®ãã£ã³ã»ã«ãåŒãèµ·ããå¯èœæ§ãé«ãããšãçè§£ããå¿
èŠããããŸãã
RUS-Studioãšã©ãŒïŒR005è€éãªæã
RUS-Studioã®è³ªåïŒQ075 LOLã®ããŒã-äœã§ããïŒ ããŒãã«ã¯ç¬äœãçµãŸããïŒ ããŒãã«ã¯ç¬ãåŒãèµ·ããããšãã§ããŸããïŒ
éåžžã®ïŒé埩æ§ïŒã¢ãŒãã§ãæ¥ç¶ããæš©éãæã€ããŒã«ã«å¯ŸããŠDROP USERãŸãã¯DROP ROLEã³ãã³ããå®è¡ãããŠãŒã¶ãŒãçŸåšæ¥ç¶ãããŠããå Žåããã®ãŠãŒã¶ãŒã«ã¯äœãèµ·ãããŸãã-åœŒã¯æ¥ç¶ãç¶ç¶ããŸãã
RUS-Studioãšã©ãŒïŒB901ãã³ãã¬ãŒãã®ç Žæã
ã¯ã©ãŒã¿ã䜿ãæãããšããã£ã¹ã¯å®¹éã®äžè¶³ãšåãæªãçµæãçããŸãã
RUS-StudioèŠåïŒW051ããããŒã¶ã«ã®æ²çã¯ã2次å°é¢æ°ã®èš±å®¹ã¬ãã«ãè¶
ããŠããŸãã
ããªã¬ãŒé¢æ°ã¯ã颿°ãããŒãžã£ãŒã€ã³ã¿ãŒãã§ã€ã¹ã®ããŒãžã§ã³1ã䜿çšããå¿
èŠããããŸãã
RUS-Studioãšã©ãŒïŒR00Eè±èªããã¹ããæ€åºãããŸããã
äœæããããŠãŒã¶ãŒãã»ãã·ã§ã³ãéãããšãèš±å¯ããŸãã ãããããã©ã«ãã®åäœã§ãã
ãªãªãžãã«ïŒ
æ°ãããŠãŒã¶ãŒã¯ãã°ã€ã³ãèš±å¯ãããŸãïŒã€ãŸãããŠãŒã¶ãŒåã¯åæã»ãã·ã§ã³ãŠãŒã¶ãŒèå¥åãšããŠäœ¿çšã§ããŸãïŒã ãããããã©ã«ãã§ãã
RUS-Studioãšã©ãŒïŒL102éå¯éå§çž®ãæ€åºãããŸããã
ã³ããŒã®äœæäžã«ããŒã¿ããŒã¹ããŒã¿ã倿Žãããå¯èœæ§ããããããæšå®å€ã¯æŠç®å€ã§ããã100ïŒ
ã®ç²ŸåºŠã¯åŸãããŸããã
ãªãªãžãã«ïŒ
ããŒã¿ããŒã¹ã¯ããã¯ã¢ããäžã«å€æŽãããå¯èœæ§ããããããããã¯ãããŸã§ãæŠç®ã§ãããæ£ç¢ºã«100ïŒ
ã§çµãããšã¯éããŸããã
RUS-Studioãšã©ãŒïŒMU003æèŠã®èª€è§£ã®å
åãæããã«ãªããŸããã
ã©ã€ãã©ãªãªããžã§ã¯ãã®ã³ãŒããé
眮ããããã®ãã¹ãåºåããŸãã
ãªãªãžãã«ïŒ
ãªããžã§ã¯ãã³ãŒãã©ã€ãã©ãªã®å ŽæãåºåããŸãã
ãšã©ãŒRUS-StudioïŒN3ïŒïŒçµã¿åããã®åé¡ã«å¯Ÿãã誀ã£ã解決çã
ããããµããŒããããŠãããã©ââãããã©ãŒã ã§ã¯ããµãŒããŒã¯ã¯ã©ãã·ã¥æã«ã¹ãããã·ã§ããããã£ããã£ããããšããŸãã ããã«ãããå°æ¥ã®æœåšçãªåé¡ã蚺æããã³é²æ¢ã§ããŸãã
ãªãªãžãã«ïŒ
ã³ã¢ãã¡ã€ã«ã«èšå®ããããœãããªãœãŒã¹å¶éãè§£é€ããããšã«ããããããå¯èœãªãã©ãããã©ãŒã äžã§ã³ã¢ãã¡ã€ã«ãçæããããã«ãµãŒããŒã¯ã©ãã·ã¥ãèš±å¯ããããšããŸãã ããã¯ãé害ãçºçãããµãŒããŒããã»ã¹ããã¹ã¿ãã¯ãã¬ãŒã¹ãååŸã§ããããã«ããããšã§ãåé¡ã®ãããã°ã蚺æã«åœ¹ç«ã¡ãŸãã
RUS-StudioèŠåïŒèª€è§£ã®åé¡ã®è§£æ±ºçãšããŠã®æç« ã®ç°¡çŽ åãæããã«ãªããŸããã
ãµãŒããŒãéå§ãŸãã¯åæ¢ããã®ãåŸ
ã€ããšãç¡èŠããŸãã
ãªãªãžãã«ïŒ
èµ·åãŸãã¯ã·ã£ããããŠã³ãå®äºããã®ãåŸ
ããªãã§ãã ããã
RUS-Studioã®ææ¡ïŒS021è€éãªå
çäžçãæã€äººã
ã䜿çšããå ŽåïŒãç§ã®æåŸ
ãç¡èŠããªãã§ãã ãããã
ãããã®ãšã©ãŒã¯ãã¹ãŠå®¹èµŠãªãä¿®æ£ãããŠããŸãããè±ç«ã¬ã€ãã§ããã¥ã¡ã³ãã調ã¹ãŠããéã«ä»ã®äººã«äŒã£ãããç§ãã¡ã«é£çµ¡ã
ãŠãã ãã ã ç§ãã¡ã®ããã¥ã¡ã³ãããªãªãžãã«ãšåãå質ã§ããããšã倧ãã«æåŸ
ããŠããŸãã
ããªãã¯å°ããïŒãªãããªãã¯æ¬åœã«éåžžã«è³¢æãªææžã翻蚳ããå¿
èŠããã£ãã®ã§ããïŒ ãã¡ããããã®è³ªåããã人ã¯ãã§ã«ãªãªãžãã«ãèªãã§ããã®ã§ãè±èªã§çè§£ããããšãã§ãããããããããèªã¿ç¶ãããããããšããµã€ãã£ã³ã°ãªã¡ãŒãªã³ã°ãªã¹ãã§ããããŸãã
ãã ãããã®ãã°ãããDBMSã«ãŸã æ
£ããŠããªã人ã«ãšã£ãŠã¯ãè±èªã®ååãªç¥èã®æ¬ åŠã¯ãç§ãã¡ã®æ·±ã信念ã«ãããŠããã®åŠç¿ã®é害ã«ãªãã¹ãã§ã¯ãããŸããã ãããã¯åå¿è
ã®ç®¡çè
/éçºè
ãåŠçãããã«ã¯åŠç«¥ã§ãïŒã¯ããããã¥ã¡ã³ãã«ã¯SQLã®åºæ¬ã«é¢ããè³æãå«ãŸããŠãããããªããºãã§ãçè§£ã§ããŸãïŒã
ããã«ãããèªäœãéåžžã«è³¢æã§ãããšããäºå®ã¯ãããã翻蚳ããåªåãæ£åœåããŸãã ããã«ãç§ãã¡ã®ç¿»èš³ãåºç€ãšããŠããªãªãžãã«ã§èŠã€ããããšãã§ããã®ãšåãã¬ãã«ã®å質ãšå®å
šæ§ãåããæç§æžãšã³ãŒã¹ãéçºããŠããŸãã
æåŸã«ãPostgreSQLã«åºã¥ããŠæ§ç¯ãããPostgres Pro補åã¯ãåœå
ã®ãœãããŠã§ã¢ã¬ãžã¹ããªã«å«ãŸããŠããŸããã€ãŸããäž»ã«ãã·ã¢èªã話ããŠãŒã¶ãŒã察象ãšããŠããããã·ã¢èªã®ããã¥ã¡ã³ããå¿
èŠã§ãã ããã©ããŒãžã§ã³ã®ç¿»èš³ã¯ããã·ã¢èªã話ãã³ãã¥ããã£å
šäœã®postgresã®éçºã«è²¢ç®ããŠããŸãã
æ°ãæãšæ°ã¡ã¬ãã€ãã®äœæ¥ã®çµæããã®ã€ãã³ãã¯ã
httpsïŒ//www.postgresql.org/docs/ããŒãžã®ç¿»èš³ãªã¹ãã«æ§ãããª
ãã·ã¢èªã®ãªã³ã¯ã衚瀺ãããããšã§è¡šãããŸããã
ããããïŒ