PGCon2014 - Final Release

PGCon 2014
The PostgreSQL Conference

Ian Barwick
Day Talks - Day 2 - Fri May 23 - 2014-05-23
Room Morisset 221
Start time 15:15
Duration 00:45
ID 682
Event type Lecture
Track Case Studies
Language used for presentation English

"A Tale of Two Oracle Migrations"

Deploying PostgreSQL at Japan's second-largest stock exchange

In this presentation I'll talk about two migrations from Oracle to PostgreSQL - the first back in 2001, which is how I got into PostgreSQL in the first place, and the second in 2013 involving the second largest stock exchange in Japan.

One of the hotter PostgreSQL topics recently is the increasing trend towards enterprise-scale migrations from Oracle and other commercial databases to PostgreSQL - not only for cost savings but also for its rich and expanding feature set combined with a solid reputation for reliability. But it's hardly a new trend - that's how I first came across PostgreSQL back in 2001. I'll give a brief and hopefully humourous description of what I did back then (with some pictures of cute animals) and how it led to the Japanese stock market.

Which is where I ended up in charge of the database underpinning the back office of Japan's second largest stock exchange, SBI Japannext. Since late last summer this has been powered by PostgreSQL and the changeover from Oracle has gone very smoothly. The main part of this presentation will be about how this migration was planned and implemented, and the foundations it has created for further adoption of PostgreSQL.