PGCon2015 - final

PGCon 2015
The PostgreSQL Conference

Gary Baker
Day Talks - Day 3 - Thursday - 2015-06-18
Room DMS 1160
Start time 14:00
Duration 00:45
ID 795
Event type Lecture
Track Case Studies
Language used for presentation English

PostgreSQL and the Enterprise Cloud

Challenges, Solutions, & Assorted Horrors

With transactions growing at over 60% annually and customer and data growth rates even higher, Salesforce is at the leading edge of enterprise cloud computing and is always exploring and investing in highly scalable and resilient transactional computing architectures for the future.

Join us and learn how the team approached and solved problems ranging from millions of lines of complex procedural SQLs to an ad-hoc customer query generator to thousands of embedded SQLs in tests and tooling infrastructure in order to further this research using a variety of conventional and innovative techniques.

Learn about some of the challenges encountered when adapting one of the world’s largest, most sophisticated and most successful cloud based java application to run on a secondary database.

From millions of lines of hand coded and generated PL and SQL to a query generator that can process any customer defined query to tens of thousands of ad-hoc SQLs embedded in test and integrity checking tools, this is no small challenge. Our team was able to overcome these challenges using a variety of conventional and innovative tools and frameworks.

Join us to hear about the challenges, solutions, and some of the horror stories that were encountered along the way.