¥µ¥Ý¡¼¥È

PostgreSQL/PowerGres ¥µ¥Ý¡¼¥È&Êݼ饵¡¼¥Ó¥¹

PostgreSQL¤Î10ǯ¥µ¥Ý¡¼¥È¡¢¥µ¡¼¥É¥Ñ¡¼¥Æ¥£¥½¥Õ¥È¥¦¥§¥¢¤Î¥µ¥Ý¡¼¥È¤ò³«»Ï¤·¤Þ¤·¤¿¡£

ÂåɽŪ¤Ê¥ª¡¼¥×¥ó¥½¡¼¥¹¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ç¤¢¤ë PostgreSQL ¤ÎÍøÍѤò»Ù±ç¤¹¤ë¥µ¥Ý¡¼¥È¥µ¡¼¥Ó¥¹¤Ç¤¹¡£
PostgreSQL ¤òÍøÍѤ·¤¿¥·¥¹¥Æ¥à¤Î³«È¯»þ¤«¤é±¿ÍѤޤǡ¢Éý¹­¤¯³èÍѤ¤¤¿¤À¤±¤ë¥µ¡¼¥Ó¥¹ÆâÍÆ¤È¤Ê¤Ã¤Æ¤ª¤ê¤Þ¤¹¡£

ÆüËܤǺǽé¤Ë PostgreSQL ¤Î¥µ¥Ý¡¼¥È¤ò³«»Ï¤·¤¿Åö¼Ò¤¬¡¢Ä¹Ç¯¤Î·Ð¸³¤ò³è¤«¤·¤Æ¡¢ ¹âÉʼÁ¤«¤Ä¿×®¤ÊÂбþ¤ò¼Â»Ü¤·¤Æ¤¤¤Þ¤¹¡£

Ä̾ï¤Î¥µ¥Ý¡¼¥È¤Ç¤ÏÂоݳ°¤È¤Ê¤ë¡¢À߷פä¥Á¥å¡¼¥Ë¥ó¥°¤È¤¤¤Ã¤¿¹âÅÙ¤ÊÆâÍÆ¤â¥µ¥Ý¡¼¥È¤Ë´Þ¤ó¤Ç¤ª¤ê¡¢
PostgreSQL ¤Î³«È¯¤Ë´Ø¤ï¤ëÅö¼Ò¤¬¥½¡¼¥¹¥³¡¼¥É¥ì¥Ù¥ë¤ÇÂбþ¤µ¤»¤Æ¤¤¤¿¤À¤¯¡¢ÉʼÁ½Å»ë¤Î¥µ¡¼¥Ó¥¹¤Ç¤¹¡£

SRA OSS ¤Î¥µ¡¼¥Ó¥¹¤Ï¤³¤³¤¬°ã¤¦¡ª

  • ¥½¡¼¥¹¥³¡¼¥É¥ì¥Ù¥ë¤ÇÄ´ºº³Îǧ¤ò¹Ô¤¦¡¢¹âÉʼÁ¤Ê¥Ø¥ë¥×¥Ç¥¹¥¯¥µ¡¼¥Ó¥¹
  • PostgreSQL ÍѤΥ¯¥é¥¹¥¿¥½¥Õ¥È¥¦¥§¥¢¤â¥µ¥Ý¡¼¥È
  • ¥Ê¥ì¥Ã¥¸¥Ù¡¼¥¹¡¢¥Ë¥å¡¼¥¹ÇÛ¿®¤Ê¤É¡¢¼þÊÕ¥µ¡¼¥Ó¥¹¤â½¼¼Â

¥µ¡¼¥Ó¥¹ÆâÍÆ (³µÍ×)

¥Ø¥ë¥×¥Ç¥¹¥¯

¡ã ¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥Ð¤Î¥Ø¥ë¥×¥Ç¥¹¥¯ÂбþÈÏ°Ï ¡ä

¡ã ¥¯¥é¥¹¥¿¥½¥Õ¥È¥¦¥§¥¢¤Î¥Ø¥ë¥×¥Ç¥¹¥¯ÂбþÈÏ°Ï ¡ä


Web ¥µ¥Ý¡¼¥ÈÁë¸ý²èÌÌ¥¤¥á¡¼¥¸
QA web sample1QA web sample2QA web sample3

¾ã³²Âбþ

¾ã³²¸¶°ø¤òÄ´ºº¤·¡¢²þÁ±ºö¤ò¤´Ä󼨤¤¤¿¤·¤Þ¤¹¡£²þÁ±ºö¤ÎÄ󼨤ÏÉüµìÊýË¡¡¢²óÈòÊýË¡¤òÃæ¿´¤È¤·¤Þ¤¹¤¬¡¢
¥½¥Õ¥È¥¦¥§¥¢¤Î½¤Àµ¤Ç¤·¤«Âбþ¤Ç¤­¤Ê¤¤¾ì¹ç¡¢²Äǽ¤Ê¸Â¤ê¥½¥Õ¥È¥¦¥§¥¢ËÜÂΤؤν¤Àµ¤ò¹Ô¤¤¤Þ¤¹¡£

¾ðÊóÇÛ¿®¥µ¡¼¥Ó¥¹

¥µ¥Ý¡¼¥ÈÂоݤΥ½¥Õ¥È¥¦¥§¥¢¤Ë´Ø¤¹¤ë¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¾ðÊó¤äºÇ¿·¾ðÊó¤ò¿ï»þ¡¢ÅŻҥ᡼¥ë¤Ë¤Æ¤ªÃΤ餻¤·¤Þ¤¹¡£

¥Ê¥ì¥Ã¥¸¡¦¥Ç¡¼¥¿¥Ù¡¼¥¹

¤´·ÀÌó¤Î¥½¥Õ¥È¥¦¥§¥¢¤Ë´Ø¤¹¤ë¡¢¤è¤¯¤¢¤ë¤´¼ÁÌä¤ä¡¢²áµî¤Î²óÅú»öÎã¤Ê¤É¤ò±ÜÍ÷¤¤¤¿¤À¤±¤ë¥µ¡¼¥Ó¥¹¤Ç¤¹¡£
¥µ¥Ý¡¼¥È¤ªÌ䤤¹ç¤ï¤»ÍѤÎWeb¥·¥¹¥Æ¥à¤«¤é»²¾È¤¤¤¿¤À¤±¤Þ¤¹¡£


¥Ê¥ì¥Ã¥¸¥Ù¡¼¥¹¤Î¥¤¥á¡¼¥¸
KB sample1KB sample2KB sample3

¥Ê¥ì¥Ã¥¸¥Ù¡¼¥¹¤Îʸ½ñ¥µ¥ó¥×¥ë

¡¡¡¡¡¡

¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¥½¥Õ¥È¥¦¥§¥¢¤ÎÄó¶¡

¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¥½¥Õ¥È¥¦¥§¥¢¤ò̵½þ¤Ç¤´Ä󶡤¤¤¿¤·¤Þ¤¹¡£

¥µ¡¼¥Ó¥¹¥á¥Ë¥å¡¼

3 ¼ïÎà¤Î¥á¥Ë¥å¡¼¤È¡¢¤½¤ì¤¾¤ì¤Ë¥Ó¥¸¥Í¥¹¥¿¥¤¥à¥µ¥Ý¡¼¥È¤È24 »þ´Ö 365 Æü¡Ê°Ê¹ß 24¡ß365¡Ë¥µ¥Ý¡¼¥È¤¬ÍѰդµ¤ì¤Æ¤¤¤Þ¤¹¡£
¡Ê¥Ó¥¸¥Í¥¹¥¿¥¤¥à¥µ¥Ý¡¼¥È¤È 24¡ß365¥µ¥Ý¡¼¥È¤Ë¤Ä¤¤¤Æ¤Ï¡¢¤´°ÆÆâ PDF ¤Î ¡Ö3.¼õÉÕÊýË¡¤ÈÂбþ»þ´Ö¡×¤ò¤´»²¾È¤¯¤À¤µ¤¤¡£¡Ë

Âоݥ½¥Õ¥È¥¦¥§¥¢¤ª¤è¤Ó¥×¥é¥Ã¥È¥Õ¥©¡¼¥à¤Î¥Ð¡¼¥¸¥ç¥ó¤Ë¤Ä¤¤¤Æ¤Ï¡¢¤´°ÆÆâ(ÊÌ»æ¡Ë¤ÎÄ̤ê¤È¤Ê¤ê¤Þ¤¹¡£

¥µ¡¼¥Ó¥¹¥á¥Ë¥å¡¼ ¥×¥é¥Á¥Ê ¥´¡¼¥ë¥É ¥·¥ë¥Ð¡¼
Âбþ¥Ç¡¼¥¿¥Ù¡¼¥¹
¥½¥Õ¥È¥¦¥§¥¢
PostgreSQL¢¨3
PowerGres on Windows
PowerGres on Linux
Âбþ¥¯¥é¥¹¥¿
¥½¥Õ¥È¥¦¥§¥¢
pgpool-II,Slony-I,pgpool-HA,¢¨4
Corosync/Heartbeat¢¨5,DRBD¢¨5
-
Âбþ¥×¥é¥Ã¥È¥Õ¥©¡¼¥à PostgreSQL

¡Ú Linux ¡Û
Red Hat Enterprise Linux AE/ES(x86/x86_64,IBM POWER)
CentOS¡¢Debian
¡Ú Windows¡Û
ÆüËܸìÈÇ¥Õ¥¡¥¤¥ë¥·¥¹¥Æ¥à NTFS
¡Ú Solaris ¡Û
Solaris(SPARC/x86)
¡Ú HP-UX ¡Û
HP-UX(Itanium)

DB ¥µ¡¼¥Ð¥Î¡¼¥É¿ô ¢¨ 1 20 4 1
¼ÁÌäôÅö¼Ô¿ô 20̾ 4̾ 1̾
¥¤¥ó¥·¥Ç¥ó¥È¿ô ¢¨ 2 ̵À©¸Â
·ÀÌó´ü´Ö 1 ǯ´Ö
ɸ½à¥á¥Ë¥å¡¼
Àǹþ²Á³Ê
¥Ó¥¸¥Í¥¹¥¿¥¤¥à 2,100,000±ß ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 840,000±ß ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 420,000±ß
24¡ß365 4,200,000±ß 24¡ß365 1,680,000±ß 24¡ß365 840,000±ß
pgpool-HA
¥ª¥×¥·¥ç¥ó
²Á³Ê ¢¨6
¥Ó¥¸¥Í¥¹¥¿¥¤¥à 787,500 ±ß ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 315,000 ±ß -
24¡ß365 1,575,000±ß 24¡ß365 630,000±ß -
Pacemaker / Heartbeat
+ DRBD
¥ª¥×¥·¥ç¥ó
²Á³Ê ¢¨7
¥Ó¥¸¥Í¥¹¥¿¥¤¥à 1,050,000 ±ß ¥Ó¥¸¥Í¥¹¥¿¥¤¥à 420,000 ±ß -
24¡ß365 2,100,000±ß 24¡ß365 840,000±ß -
¢¨ 1
DB¥µ¡¼¥Ð¥Î¡¼¥É¿ô¤È¤Ï¡¢1¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥Ð¥×¥í¥°¥é¥à¤Î¥¤¥ó¥¹¥È¡¼¥ë¿ô¤ò¤µ¤·¤Þ¤¹¡£
¥¯¥é¥¹¥¿¥½¥Õ¥È¥¦¥§¥¢¤òÍøÍѤ·¤¿¾ì¹ç¤â¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥Ð¥×¥í¥°¥é¥à¤Î¥¤¥ó¥¹¥È¡¼¥ë¿ô¤Î¤ß¤Ç¥«¥¦¥ó¥È¤·¤Þ¤¹¡£
¢¨ 2
¥¤¥ó¥·¥Ç¥ó¥È¿ô¤Ï1¤Ä¤Î¼ÁÌ䤬´°Î»¤¹¤ë¤Þ¤Ç¤Î°ìÏ¢¤Îή¤ì¤ò¤µ¤·¤Þ¤¹¡£
¢¨ 3
PostgreSQL¤Ï³«È¯¥³¥ß¥å¥Ë¥Æ¥£¤è¤ê¥ê¥ê¡¼¥¹¤µ¤ì¤Æ¤¤¤ë¤â¤Î¤¬Âоݤˤʤê¤Þ¤¹¡£
¢¨ 4
pgpool-HA¥ª¥×¥·¥ç¥óÄɲä¬É¬Í×
¢¨ 5
Pacemaker/Heartbeat+DRBD¥ª¥×¥·¥ç¥óÄɲä¬É¬Í×
¢¨ 6
Pacemaker/Heartbeat¤Ë¤è¤ë¹â²ÄÍÑÀ­¥¯¥é¥¹¥¿¤Ç pgpool-HA ¥ê¥«¥Ð¥ê¥¨¡¼¥¸¥§¥ó¥È¤ò»È¤¤pgpool-II¤òÊݸ¤ë¹½À®
¡¡¡¡
¢¨ 7
Pacemaker/Heartbeat ¤Ë¤è¤ë¹â²ÄÍÑÀ­¥¯¥é¥¹¥¿¤Ç DRBD ¤Ë¤è¤ë¥ì¥×¥ê¥±¡¼¥·¥ç¥ó¤Ç PostgreSQ L ¤òÊݸ¤ë¹½À®

IBM Power Systems ¤Ø¤ÎÂбþ¤Ë¤Ä¤¤¤Æ

IBM Power Systems ¤Ø¤ÎÂбþ¤Ë¤Ä¤¤¤Æ¡¢¤è¤ê´Ê°×¤Ë¤´ÍøÍѤ¤¤¿¤À¤¯¤¿¤á¤Ë¡¢ ËÜ¥µ¥Ý¡¼¥È¤ÎÂоݥ½¥Õ¥È¥¦¥§¥¢¤Î RPM ¥Ñ¥Ã¥±¡¼¥¸¤òÄ󶡤·¤Æ¤ª¤ê¤Þ¤¹¡£
Red Hat Enterprise Linux 6 for IBM POWER ÍÑ PostgreSQL ´ØÏ¢¥½¥Õ¥È¥¦¥§¥¢ RPM ¥Ñ¥Ã¥±¡¼¥¸¥À¥¦¥ó¥í¡¼¥É

¤½¤Î¾¤Î¥ß¥É¥ë¥¦¥§¥¢¡¦Äɲå⥸¥å¡¼¥ë¤È¤ÎÁȤ߹ç¤ï¤»

PostgreSQL ¤ÈÁȤ߹ç¤ï¤»¤ÆÍøÍѤ¹¤ë¤½¤Î¾¥ß¥É¥ë¥¦¥§¥¢¤äÄɲå⥸¥å¡¼¥ë¤ò»È¤¦¾ì¹ç¤Ë ¤½¤ì¤é¤ËÂФ¹¤ë¥µ¥Ý¡¼¥È¤â¤´Ä󶡤¤¤¿¤·¤Þ¤¹¡£
¸ÄÊ̤ˤªÌ䤤¹ç¤ï¤»¤¯¤À¤µ¤¤¡£

¥µ¥Ý¡¼¥È¾ÜºÙ

¾Ü¤·¤¤¥µ¥Ý¡¼¥ÈÆâÍÆ¤Ï¡ÖPostgreSQL/PowerGres ¥µ¥Ý¡¼¥È&Êݼ饵¡¼¥Ó¥¹¤Î¤´°ÆÆâ (PDF ·Á¼° PDF ·Á¼°/260 KB)¡×¤ª¤è¤Ó¡ÖPostgreSQL/PowerGres¥µ¥Ý¡¼¥È&Êݼ饵¡¼¥Ó¥¹¤Î¤´°ÆÆâ¡ÊÊÌ»æ¡Ë¡×PDF ·Á¼°¡ÊPDF·Á¼°/210KB)¤ò¤´Í÷¤¯¤À¤µ¤¤¡£
¾åµ­°Ê³°¤Ë¡¢¥½¥Õ¥È¥¦¥§¥¢¥Ù¥ó¥À¡¼Íͤ䥢¥×¥ê¥±¡¼¥·¥ç¥ó¥µ¡¼¥Ó¥¹¥×¥í¥Ð¥¤¥À¡¼Í͸þ¤±¤Î¡Ö¥Ù¥ó¥À¡¼¥¢¥é¥¤¥¢¥ó¥¹¥×¥í¥°¥é¥à¡×¤â¤´ÍѰդ·¤Æ¤ª¤ê¤Þ¤¹¡£
¾ÜºÙ¤Ï ¤Þ¤Ç¤ªÌ䤤¹ç¤ï¤»¤¯¤À¤µ¤¤¡£

¤ª¿½¤·¹þ¤ß

Web ¥Ú¡¼¥¸¤«¤é¤ª¿½¤·¹þ¤ß¤ò¼õ¤±ÉÕ¤±¤Æ¤ª¤ê¤Þ¤¹¡£ ¤ª¸«ÀѤâ¤ê¤¬É¬Íפʾì¹ç¤Ï ¤Þ¤Ç¤ªÌ䤤¹ç¤ï¤»¤¯¤À¤µ¤¤¡£

µì¥Ð¡¼¥¸¥ç¥ó¤Î¥µ¥Ý¡¼¥È¤ä¥µ¥Ý¡¼¥ÈÂоݳ°¤Î¥×¥é¥Ã¥È¥Õ¥©¡¼¥à¤Ë¤Ä¤¤¤Æ¤â¤´ÁêÃ̤¯¤À¤µ¤¤¡£