Presented by:

Headshot 2015 09 18 128

Phil Vacca

Mitel Networks

Phil Vacca has been designing highly scalable applications for years. He has worked for and consulted with enterprises of vast and varied data needs, including some of the nation's largest insurers, defense industries, telecom providers, and many others. While always happy to build and improve Production facing applications, his favorite projects involve data warehousing and analysis. Currently he leads an effort at Mitel Networks to move all enterprise data to a single, streaming event-fed data lake, and a relational data warehouse built on the Postgres fork, Amazon Redshift.

Phil is an active speaker, and can be found extolling the virtues of the world's most advanced open source database as a member of pgMKE, the Milwaukee area PostgreSQL Users Group.

No video of the event yet, sorry!

The popularity of the PostgreSQL database has never been higher. Now, all three of the biggest Cloud providers - AWS, MS Azure, and Google Cloud Platform - finally offer Postgres as a hosted service. Add to that one of the earliest and most familiar hosted PostgreSQL solutions, Heroku, and it certainly seems that it has never been easier to have a turn-key solution for the world's most advanced open source database. A developer or system admin would be wise to ask what are the differences between these offerings? And just how much control over the db are you giving up by opting for one of these solutions?

The talk will attempt to answer these questions and more in three parts: 1. A brief history of Cloud hosted databases 2. What hosting gives you, and what you give up (a feature comparison of the providers) 3. Options for doing it yourself using the cloud

This talk should help you understand how many areas there are to consider when it comes to hosting your database: from deployment, to monitoring performance, handling version upgrades, and maintaining High Availability, to the all important questions of pricing. I hope you will join me for this look at the current state of Postgres in the Cloud.

2017 September 30 15:00 UTC
50 min
PgConf US Local: Ohio [PgConf.US]