??�e?�a?�a?�a?�a?�a��a��?�?c?�?��a�?a��a??a?�e�?a?�a??a��a??a��a??a?�a??a�Se??a?�a��?�?a?�a?�a?�a??a?�a??a?Ya?�a?�a??a�?bitcha��a?�a??a?�a�S?�?a?�a??a??a??a??a?�a?�a??a??a?Ya?�a?�a�?1a??e?�a???�??��a???�?a??a??a?YcS�?��a?�a??a??a?�a?�a??a??a?�a?�a��a��

a??a��a??a??a��a??a?Ya?�a??a?�a?�a?�a�?e�?a?�a?�(a��a?�a??a��a??a?�a??a�?a��a?�a��)a??a??a�?a�?a�Sa?�a?�a?�a?�a?�a?�a???�?a?�a��a?Ya?�a?�a��a??a??e?�a��a?�a��e??a�?a??a?�a�Sa??a?�a??a��a?�a��?�?a??a?�a��a�Sa��

a?�a�?c��a?�a??a??a?�a?�a�?a�?e��a?�e��a?�a?�a?�a�?a�?a??a?�a??a�?a??a�?a��a??a?�a�?a?�a??a�?2012.DBa�?a?�e??a??a?�a??a?Ya?�a?�a�?a??a?�?��a?�a??a??a��

a��a??a?�a�?a?�a??a�?a?�a��a��a??a??a�?a?�a��a?�a?�a�?a??e?�?��(a?�e??)a��a?�?�?a?�Ustreama?�c��a??e��a��a�?a��a��
http://www.ospn.jp/osc2012.db/

BigDataa��e?Za???�?a?�i?? PostgreSQLa?�a?�a?�?�?a?Ya?�a?�a��a��a�?a�?Stadoa�?a?�c??a��a???�?e??a��a�S
?��a?�i?sa�?a??a?�a�?a��a?�a?�a?�a�?a?Za?�a�?a??a�?a??a??a?sc�?
e��a?�i?s?�?a�� ?�Ya??

Stado(a�?a�?a?�)a?�?��e�?
a?�MPPa?Ya?�a?�a��a��a�?a��PostgreSQLa?�a??c�?a��
a?�GridSQLa?�a??c��a?�a?�a�?a��a�?a??a��?�?a??a??e��a?�a��
a?�a��a��a�?a??a?�a?Sa??a��a??a��
a?�a�?a??a?�a??a�?a??a�?
a?�DWH/BIa?�a?�a�?a??a??a??a��a?�a??
a?�a�?a�?a??a�?a��a??a?za��a??e�?a??a?�a?�a?�a?�a?�a?�a�?a�?a??a��a�Ye??a?�a��a?Ya�?a?�a��a?�a��
a?�a?�a?�a??a��a??a��a?�a??a?�a??a??a?�a��
a?�e�?a??c�?a?�a?�a?�a??a??a?�a��
a?�Postgres-XC(a?za?�a??a?za�?a�?a??a?�a�?a?�a�?a�?)a?�a??a??a?�a��
a?�c��c?�a��a??a??1a?�a?�a??a?�a?�e��?��a?�e��c?�a?Za??a?�a��e?�a�sa?�a��a?�a??a??a?�a??a��a��
a?�a?�a??a?�a�?a��a?�a?�a??a��a??a�?a?�2c?�e?za��a???��a?�a??c�?a?�a��a?�a??a??a??e??a��
a?�a??a�?a?�a??a?�a�?a��a?�a?�a??a��a��a��a��CE(PostgreSQL??�??�?�Ye??)
a??a??a��a??a?�a??a?�a�?a��a?�a?�a??a��a��a��a��Stado
a?�e��c?�a��c?�(sum, count)a??2?��esZa?�a�Ye??(a?�a??a��a?�a��a?Za??a?�e��a?�e��e??)
a?�a�Ye??a??e??a??SQLa?�a?�c?�a?�a�Sa��
a?�DMLa??e?�a?�a?�a?�a?�a??a�?c��e??a??a?�a??a?�a��a??a??a?Ya??a?�a�?a?�a??a?�a��?Z?a??a��
a?�a?Za??a?�a��e??aS�a?�a��a?�a??a?�a��a??a�?a��a?�a??a?�e�?a��

a�Za�??��e��
a?�PostgreSQL9.1a�?e�?a�?JDK6a�?e�?a??a?�e�?a��
a?�a??a??a??a�?c�?a?�a??a??a??a??a??a�?a??a??a?�a��??�?��c�?a��a�??��a?�a?�a��a??a�?a??a??a?�a?�a��a?�a??a��?Z?a??a��

?�?e??c�??z?
a?�?�?e??a?�a??c�?a?�a?Yc��a??a??a�?a?�2c?�e?za��
Amazon EC2 8nodes
c��c?�a��a??a?? HDDx4 e��c?�4nodes
a?�a??c�?a?�a?Ya?�a??a??a?za??a�?a??DBT-3a��a�?a��a??a?�a?�a�?a�?a�?i?s10
a?�counta��group bya?�a??a??a?�a�?a?�a�?a��a??a?�a?�a?Ya��
a?�a?Za??a?�a��a??a?Ya??join(a�?a?�a�?a?Za??a?�a�?a?�a��a??)a?�a??a?�a?�a��a??a?za??a�?a??a?Sa??a��a??a?�a��
a?�a�?a?�a�?a?Za??a?�a�?a?�a��a??a??a?�?��TEMPa?�a??a?�a?�a��a?????a?�a?�a?�a��a?Ya�?a�?DISK?�?a??a�?a?�a??c�?c�Ya��
a?�a�?a?�cs�a?�c��c?�a��a??a??a??a?�a??a??a�?a?�a?�a??a?�a�?a?�a�?a��a??a?�a?�a��e??a?�a??a�sa?�a??a?Ya��
a?�a?�?�?a?�EC2a??a?�a??a??a?�a�?a?�a�?a��a??a?�a?�a��e??a?�a��a?�a�?a?�a?�a??a?�e??a?�a��a�sa??a�?c�??z?a??a??a��a�sa��
a?�a?�a?�a�?c�??z?a?�a??a?�a????Za??c�?a???��a��a?Ya�?a??a?�e???Y�a??a?�e�?a��

a�?a?�a�?a��a??cs�a???�Y???a��
?�?e??a?�a??e��?��a?Za??a?�a?�c��a??a??a?�a?�EC2a��a??c�?a?�a?�a?�a?Ya?Ya�?a�?c�??z?a?�a??a��a�sa?�a??Stadoa?�a�?a��a��a?�a??a?�a?�a��???c��a??a?�a�?a��a��a?�a??a?�a?�a??a????Zcz�a?�a??a?Ya��c��c?�a��a??a??a��e��?��c�??�?a?�a?�a?�?�?e??c�??z?a��e��a?�a??a?Ya?�(e�?a?�a?�a��a�?a??a?�a?�e��a?�i?Y)a��
pgpool-II ?��a??a??a�?a?�a?? 3.2 c��a�?i?? i?za�s?�Ye??a?Ya?�a?�a��a��a�? pgpool-II a?�??�c�?a?� PostgreSQL a?�c�?a?�a?�a��a??a?�a��i?z
?��a?�i?sSRA OSS Inc.?�???�?�?c�?
e��a?�i?sa��e?� a??c?Zi??SRA OSS Inc.?�???�?�?c�? ?S�e?�e��c�?e??i?�

a�Sa�za??a�?a?�2a?�a?�?��?�Ye??a?�c??a��a��
1. On memory query cache
2. Watchdog

On memory query cache
a?�MySQLa?�a�?a�?a??a��a??a??a��a??a��a?�a�?a�?a?�a��
a?�pgpool-IIa??a�?a�????a??a?�a?�a?Y?��a�?a�?a??a��a??a??a��a??a??a�??�?a?�a?Ya��
a?�a�?a�?a??a��md5a?�a��a??a??a��a??a?�a?Ya��a?�a��??�e??a?�a?�a?�a��a��
a?�a��a??a??a��a??a?�a�?a??a?�selecta??a�?a?�a?�e�sa�Sa��
i?sImmutablea?�a??a??a?�a��a?�(DATEe�??��a??a?�)
i?sfor update
i?sa��?��a?�a?Ya�?a�?a??a��a?�a??a?�a??a??a�?a?�a?Ya�?a�?a??
i?sa?�a?�a??a�?a??a�?a??a?�e?�a??a?�a?�a��a��a?�
i?sa?�a??a��a??a??a�?a??a?�e?�a??a?�a?�a??a?�a��a?�
i?sa�?a�?a??a?�a�?a??a?�e?�a?�a�?a��c�??z?a��a??a??a?�a��a��a�?a??a��a??a?�a��a?�
i?sa?�?��a?�a??a?�a?�(a?�a?�a��a?�a??a?�a??a��a??a??a��a??c�?aS?a��??�aS?a?�a��a?�a??a��a��)
a?�a��a??a??a��a??a?�a??a??cZ�a??a?Za?�a�?a??a??a??a�?a??a?�?�?a??e�Ya?�(a��a??a??a��a??a?�a?Ya�?a?�a?�e??a??a��c?�a��a?�a?�a?�a��a?Ya�?)a��
a?�a��a??a??a��a??a?�a??a??cZ�a?�c��a��a??60%i?z70%a??a��a?�a��
a?�a?�e�?a?�e��a??a�?a?�a?�e�sa�Sa��
i?s?s�e��cs�a???�??��a??e??e�?a?�a??a??a?�a��a?�a??a??a?�?�??��a��a??a??a��a??a??a?�a��
i?sa�?a��a??a?za��a??a??a?�a��a?�a??a??a?�a??a??a?�a��a??c?�a?�SQL?��a��a??a??a��a??a?�a?�a?�a��a?Ya�?a�?SQLa��a?�a�?a��a??a?z??�a�sa??a??a?�a�?a?�a??a??a??a??a��a??a?�a??a??a?�a?�a??a?�a��

Watchdog
a?�pgpoola��HA?��???a?�a??a?�a?Ya�?a?�?�Ye??a��
a?�a��???IPa��a??a?�a��
a?�pinga?�c�?e��
a��a��a��a��a��???IP
a��
Active pgpoolA�A� a�?a��A�A� stand by pgpool
a��
PostgreSQL1A�A�A�A� a�?a��A�A� PostgreSQL2

a?�a�?a?�a??a??a??a?�a?�a��a??a??c��a??a�?HUB?��es??��a?�a?�a??a��a��a��???IPa��downa?�a?�a��a?�a??a?�e??a?�a��
a?�a��???IPa?�up/downa��e??a?�a?Ya�?a�?pgpoola��roota?�a�Ye??a?�a��a?�e�?a?�a�Sa��
a?�failover?��a?�a?�a�?a??a??a?�a??a?�ssh?Z?c�sa??a?�a??a��a?�e�?a?�a�Sa��
a?�c???��c�?a?�a??a?�a?�a?�a??a��a�?a?�a??a�?a�???�a��a??a??a??a?�a��
a?�?��a?�a????Ya??a?�e�?a��

a�?a?�a�?a��a??cs�a???�Y???a��
a?�pgpool-IIe�?a?�a��a?�a??cY?a��a??a?�a??a?Ya?�a?�a�??��?�Ye??a?�e��a?�a?�e?za?�a?�a��?�?a�?a??a??a?�a??a?Ya��a?�a??a??a?Ya��
a?�e��a?�a?�a??a?�a��a�Sa??a?Ya?�a?Ya?�a?�a?�a??a?Ya��e�?a?�a��??�e?�a??a��a?Ya?Sa??a��a?�a??a��e??a?�a?�a??a??a�sa?�a?�a?�a�?e?za?�a?�a?�a��a??a??a?�e�?a?�a??a��a??a?�a?�a��?�?a��???a??a?�a?�a?�a��a?�a��a?�a?�a?�a??a??a?Ya��

DBa??a??a??a��a??a??e?�a?�a?�a?�a�?a?�?�?a��c?�aY?c��a�?Hadoopa�?a?�?��e�?a????�?��a��a?�c??a��i??
?��a?�i?sHadoopa?�a??a��a??a?s
e��a?�i?sa��a?� c?Ya?�

a�?a��a??a?�e�sa�Sa�?a?�a??a??a�Sa??a?�a?Y?��e�?c??a��a?�a??a?Ya?Ya�?a�?a?�cs�a??e��a??c??c�?a��
?��a?�a??a??a?Yc�?a?�a?�a�?a?�a?�a?�a??a�?a�?a??a?�a��

a?�GEa?�a??MySQLa?�50?��e��a?�a?�a??a?�a?�a?Ya?�a��a??a??a��e??a?�a?�a?�?z?a��c?�a��Hadoopa?�30a?�a?�a?�a?Ya��
a?�CBSa?�a??Weba��a��a??a?�a?�a��a��Hadoopa?�a??a�?a?�a?�a?�a��a��
a?�HBasea???��100TBa??a��a?�a??a?�a?�a?�a??a�?e�?a?�a�Yc??a?�a�Sa��
a?�Apache Flumei?sa?�a��a?�a??a�?a��?�?c??a?�a��ETLa?�a??a?�a��
a?�Javaa??Oracle Java6 64bita?�a??a��a??a??a??a��(Java7a?????a��a??a??a??a??a?�a?�a??a��)
a?�Apache BigTopi?s?��c?�a��a?�a�?a??c��a??a��a?????a?�a��a?�a??a?�a��

a�?a?�a�?a��a??cs�a???�Y???a��
a?�?�?a??c�?a?�a��a??a?sa?�a?�a?�a�?a??e?�?��a??a?Sa�?a?�a?�a??a??a?Ya??a?�a?�a�?3???a?�a�?a?�e?�?��a��c�?a?�a?�a?�a?�a?�a�?a??a?�a??a?Ya��??�???a?�a?�a?�a�?a??a��e?za??a?Ya?�a??a?Ya��a��a��a??a?�a�?a??a?�a?�a�?a?�a?�a��a��a?�a????�???a?�a?�a?�a�?a??e?�?��a?�a�?a?�a?�a��

PostgreSQL??�?��??�a�� i?z9.2a??a??a�?a?�a??a?�a?�i?z
?��a?�i?s?�???�PostgreSQLa?�a??a��a?s
e��a?�i?se�?a?s e?�i???�???�PostgreSQLa?�a??a��a?si?�

9.2a?�?��?�Ye??a?�?�?e�?c�?a?�a?�a?�a?�a?�c??a��a��
a?�CPUa?�a�?a��a??a?�a?�a??a??a��8.2i?z9.1a??a?�a??8i?z12a�?a�?a??a?�a�?a��a??a?�a?�a?Ya??a�?9.2a?�a??32i?z64a�?a�?a??a?�a�?a��a??a?�a?�a��a��
a?�a�Sa�za?�a�?a��a??a?�a??a??a??a��e??cs�a??a?�a??a�?c��a??a��?�?a��a?�a��a?�a??a?�a??e??a??a??a??a?Ya��
a?�?�?a??e??a??a??a?�a??a��a�?a��a?�a??a?�?�?a��a��COMMITe?�a��a???�?a��a?�a�?a?Ya��
a?�Index only scana??a??e??a??a??a??a?Ya��PostgreSQLa??e??e??az�a??a?�a?�c�?a??a?�a?Ya�?a�?a?�a�?a??a?�Indexa?�a??a?�a�?a��a??a??a?�a��a?�a??a??a?�a??a??a?�a??a?Y(a?�a??a?�a?�a??a?�a??a?�a??a??a�?a?�a??a��c�?c?�a?�a?�a?�a?Ya?Ya�?)a��a�Sa�za??vacuuma��c?�?�?a��a?�a?Ya�?a?�a�?a�?a�Za�?a?�a�?a?YVisibility Mapa��a??c�?a?�a�?e��?��a?�a??a??a�?a?�a??a��???a?Ya??a?�a�?a??(vacuumc�?a??a??a?�)a?�a�Ye??a?�a??a��a�?a?�a?�a?�a?Ya��
a?�a?�a?�a??a��a??a��a?�a???�Ye??a��?�?a?�a?�a�?a�?a�?a??a??a��a?�a��a�?a��a??a?�?��???a?�a??a??a?�a?Ya��

a?�a?�a��a?za??a��a��a��a�?a�?a??a??a��a��a��a��a�?a�?a??a??a��
i??a��a��a��a��a��a��a��a��a��a��a��a��a��a��a��i??
a��a��a��a�?a�?a??a??a��a��a��a��a��a��a��a��a��a��a��a��a??a??a�?a�?a??a?�

a?�JSONa?�a??a�?az�a?�e??aS�a��e�?a?�a?�e??a?�a��JSONaz�a??a?�e?�e��e�??��a?�a�S(e��a??a??a?�)a��c???��c�?a?�a??a?za?�a??a??a��a??a?�a??a��a?�a�Sa��
a?�a��a��a??a??a?�a�?a??a??a�?a?�a??a??a��a?�a??a??a�sc?�?��a?�e?�a�sa��
a?�SE-pgsqla?�a??a??c?�a�?a???�?a��a?�a�?a?Ya��
a?�parameterzed plana?�e???Sza??a??e??a?�a??a??a?Ya��a?�a?�a??a??a�?a�?a??SQLa?�a�Ye??e??c��a��a�?a�sa?�a??a?�a?�a??a??a?�a??a��a��
a��Oraclea?�a?�a?�a??a��a??a?�a��?��a��a??a?�es�a?�a�Ye??e??c��a?�a��??�a��?�?a�?a��a??a?�a?�e��a??a?�c��a?�a??i?Y
a?�drop index concurrentlya�?a?za??a?�a��a��a??a?�a??a�?a�?a�Se��?��a?�e??a?�a??a�?a��e??a�?a??a??a?�???a��a�?a?�a?�a??a??a?Ya??a?�a?�e��a��

a�?a?�a�?a��a??cs�a???�Y???a��
a��a??a?�a??a�?a�?a?�a??a��a??a??a?Y?�?c??a??a??a?�a?�a??a?�a?�a??a?�a??a?Ya?�a??a?�e�sa??a��c??a?�a?�a��e???��e��a��e�?a??a��a??e�?a?�a?�a?�a?�a??a???�?a?�a?�a?�a??a�?aY???�cs�a??e?�e???�????a??e�?e�Ya?�a�?a�Sa��a??a�?a?�a??a�Ye?�a��a�?a�?a?�a?�a?�a��a?�a?�a�?a?�a?�a��