PGCon2011 - Final (2011.06.11)

PGCon 2011
The PostgreSQL Conference

Speakers
Tetsuo Sakata
Schedule
Day Talks - 1 - 2011-05-19
Room DMS 1120
Start time 15:00
Duration 01:00
Info
ID 307
Event type Lecture
Track Case Studies
Language used for presentation English
Feedback

NTT’s Case Report

Introduce PostgreSQL into reliable and large-scale telecommunication support system

We will present how to introduce PostgreSQL into NTT’s telecommunication systems. To inform the merit of PostgreSQL for IT system managers we evaluated its performance and showed applicable field of our production systems. To broaden the field we have resolved performance problems like as performance glitch at checkpoints and improved its usability with home-made tools such as pgbulkload, pgstatsinfo and so on. All these efforts and their results are worth being shared with who plan and proceed PostgreSQL’s enterprise use.

NTT group, which is the largest telecommunication career in Japan providing more than 120 million subscribers, has made effort introducing PostgreSQL to its production systems that support telecommunication. Such systems require as same performance and reliability as proprietary DBMSes provide, which shows PostgreSQL should be enhanced in many aspects for enterprise use. We will present what kind of performance characters were required from production systems engineers and how we showed them. At first we evaluate PostgreSQL performance under TPC-C and TPC-W like workload to show its throughputs are enough for many systems. At the same time we found instability of response time and complex maintenance operation like VACUUM, which we thought be large obstacles for introduction. We tried to resolve them and they are finally cleared up by PostgreSQL 8.3. From the view point of usability, our production engineers pointed PostgreSQL lacked some essential utility tool such as fast data-loader and performance monitor. So we provided original open-source tools pgbulkload and pgstatsinfo to meet such requirements. Finally we will present improvement availability by PostgreSQL 9.0 and show expected applied systems that the feature should enable.