PGCon2015 - final
PGCon 2015
The PostgreSQL Conference
Speakers | |
---|---|
Gary Baker |
Schedule | |
---|---|
Day | Talks - Day 3 - Thursday - 2015-06-18 |
Room | DMS 1160 |
Start time | 14:00 |
Duration | 00:45 |
Info | |
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.