n n n ( ) n Oracle 16 PostgreSQL 3 MySQL

SaaS CAM MACS PostgreSQL ~ ~ 7 PostgreSQL in 2014/02/07

n n n ( ) n Oracle 16 PostgreSQL 3 MySQL

n SaaS CAM MACS n AWS n 1993 6 1 1999 4 1 C/S CAM MACS 2007 4 1 SaaS CAM MACS 2007 11 1 SaaS CAM MACS

CAM MACS n SaaS CAM MACS 34 2014 2 n EC n CRM EC

1 (2007) OS RHEL5 + CentOS5 Web Apache AP Tomcat DB Oracle 10g Java Seasar2 (Teeda + S2Dao) DB 2

1 DB n n + Redo +

2 (2010) OS Ubuntu10.10 Web Apache AP Tomcat DB PostgreSQL 9.0 Java Seasar2 (Teeda + S2Dao) Pacamaker(Ubuntu ) + pgpool-ha + pgpool-ii + Orafce

2 DB n PostgreSQL9.0 pgpool-ii n PostgreSQL pacemaker pgpool-ii IP pacemaker

2 DB pgpool-ii n IP pgpool-ii

2 DB PostgreSQL n PostgreSQL pgpool-ii

3 (2011) OS Scientific Linux 6 Web Apache AP Tomcat DB PostgreSQL 9.1 Java Seasar2 (Teeda + S2Dao) Pacamaker(Linux-HA Japan ) + Orafce

3 DB n PostgreSQL9.1 pgpool-ii PostgreSQL

3 DB n

3 DB n

4 (2013) AWS OS Amazon Linux Web Apache AP Tomcat DB PostgreSQL 9.1 Java Seasar2 (Teeda + S2Dao) Orafce

5 (2013) AWS OS Amazon Linux Web Apache AP GlassFish 3.1.2.2 DB PostgreSQL 9.2 Java JavaEE6

4 5 DB n CDP: Routing-Based HA http://aws.clouddesignpattern.org/index.php/cdp:routing-based_ha%e3%83%91%e3%82%bf%e3%83%bc%e3%83%b3 n : C3.2xlarge : C3.large

PostgreSQL

n

(1) n Oracle10g Standard Edition One HDD FT 100%

(2) n Oracle10g Standard Edition One

PostgreSQL MySQL

MySQL n PostgreSQL Oracle SQL n MySQL Nested Loop JOIN Nested Loop JOIN 5.6 BKA JOIN n MySQL 4 UTF-8 5.5

PostgreSQL

n n Oracle

n Let s Postgres http://lets.postgresql.jp/documents/case n PostgreSQL

n PostgreSQL Oracle Oracle PostgreSQL Oracle SQL PostgreSQL

SQL

SQL n Oracle PostgreSQL n SQL n Orafce(Oracle ) 2011/05 n n SQL SQL

n SQL Dao Characterization Test http://devtesting.jp/pekema/?0002%2ftddnextstep n SQL Oracle PostgreSQL Green

SQL

n table01.flg varchar select col1 from table01 where flg = 0 select col1 from table01 where flg = 0 Oracle PostgreSQL

n rownum row_number() over() select rownum, col1 from table01 order by col1 select row_number() over (order by col1), col1 from table01 Oracle PostgreSQL

n select col1, col2 from (select col1, col2 from table01) t01; Oracle PostgreSQL

n DECODE CASE Orafce CASE decode() http://orafce.projects.pgfoundry.org/index-ja.html#decode select case when col1 = 0 then A when col1 = 1 then B else Z end col1 from table01 Oracle PostgreSQL

n Java 2007 Oracle PostgreSQL Java

n PostgreSQL Null n Oracle DATE PostgreSQL timestamp Java java.util.date n null null PostgreSQL9.1 CONCAT

n unknown CAST JDBC psql create cast (unknown as varchar) with inout as implicit; create cast (unknown as text) with inout as implicit; create cast (unknown as timestamp without time zone) with inout as implicit;

n PostgreSQL CREATE n Oracle CSV PostgreSQL n currval PostgreSQL select 'select setval(''' sequence_name ''', ' last_number ', false);' from user_sequences where last_number > 1 select setval('seqxxx', 9999, false);

n Zabbix OS PostgreSQL n http://lets.postgresql.jp/documents/technical/statistics/1 n pg_monz PostgreSQL

PostgreSQL

n n ILIKE LIKE n GENERATE_SERIES UNION n n

n Oracle 3 PostgreSQL

n PostgreSQL