PGCon2013 - includes video

PGCon 2013
The PostgreSQL Conference

Speakers
Hitoshi Hemmi
Tatsuo Ishii
Schedule
Day Talks - Day 2 - 2013-05-24
Room MNT 202
Start time 16:30
Duration 01:00
Info
ID 556
Event type Lecture
Track Case Studies
Language used for presentation English
Feedback

Introducing PostgreSQL Enterprise Consortium activities

PostgreSQL Enterprise Consortium (PGEcons) is a non-profit organization aiming for promoting PostgreSQL in production use, especially in mission critical area. It is formed by leading IT companies in Japan last year. Currently PGECons has 36 company members. In the first fiscal year, PGECons performed two major technical activities: PostgreSQL scale up/scale out evaluation (by Working Group 1: WG1) and establishing migration process from commercial DBMSs to PostgreSQL (by Working Group 2: WG2). These objectives were determined based on requests from PostgreSQL users and PGECons members and PGECons believes that sharing the experience is a big benefit for PostgreSQL community.

In this talk we present current achievements of WG1 and WG2.

PostgreSQL Enterprise Consortium (PGEcons) is a non-profit organization aiming for promoting PostgreSQL in production use, especially in mission critical area. PGECons performed two major technical activities conducted by two working groups (WG1 and WG2). In this talk we present current achievements of WG1 and WG2.

The tests conducted by WG1 fall into two categories: scale up test and scale out test.

For scale up test the target was a 80 physical core server to check how PostgreSQL 9.2 behaves against concurrent transactions. We will report the detailed results including the fact that PostgreSQL scales up to 80 concurrent users with read-only load.

For the scale out tests, we tested three configurations: PostgreSQL's cascading replication with a master, a cascading standby, and four standbys, pgpool-II running in native replication mode with 4 nodes and Postgres-XC with 4 data nodes. Each configuration showed different characteristics. For example, pgpool-II performed well with read-only load, while Postgres-XC was strong in write load. We will present them with detailed data.

To promote adoptions of PostgreSQL in enterprise domain, WG2, Operation and Design working group in official, examined several related issues on the start time and determined to focus on DBMS migration. According to the survey of attendees at PGECons opening seminar, users of Oracle, DB2, SQL Server, Sybase and MySQL are in total 2.5 times more than those of PostgreSQL, even in such a PostgreSQL event. Because many of those utilizations are predicted to be enterprise ones, dealing with them is indispensable for our purpose.

In the first fiscal year, WG2, participated by 11 software businesses, carefully studied the DBMS migration process, divided it into 14 subtasks, and started to tackle to 11 of them by dedicated sub-teams. Selective topics from these activities as well as the big picture of WG2 will be presented in this talk.