Conference Sessions - PostgresOpen 2017

The following list contains all the talks that have been approved so far for PostgresOpen 2017. Note that they may not yet have been scheduled! You can find the full conference information at the conference website.

Training

• #1- Online Upgrades with Logical Replication (AM) (Free!) (Mark Wong, Shaun Thomas)
• #2 - Solid Schemas and Advanced SQL (AM) (Samantha Billington)
• #3 - Detecting performance problems and fixing them (AM) (Hans-Jürgen)
• #4 - Designing your Multi-tenant Database for Scale with Postgres (PM) (Free!) (Ozgun Erdogan, Sai Srirampur)
• #5 - Practical PostgreSQL Backup & Restore (PM) (David Steele)
• #6- Learn how to develop apps with ‘Azure Database for PostgreSQL’ (PM) (Free!) (Saloni Sonpal)

General

• A Kubernetes Operator for PostgreSQL - Architecture and Design (Sarah Conway)
• A look at the Elephants trunk - PostgreSQL 10 (Magnus Hagander)
• An ultimate guide to upgrading your PostgreSQL installation (Ilya Kosmodemiansky)
• Best practices of using a managed PostgreSQL in the cloud (Jignesh Shah)
• Beyond Foreign Data Wrappers: building a data warehouse from heterogeneous external data sources (Chad Slaughter)
• Concurrency Deep-Dive (Tejas Manohar)
• Developing powerful and intelligent apps using the Azure managed PostgreSQL service (Saloni Sonpal, Sunil Kamath)
• Distributed COUNT(DISTINCT) with HyperLogLog on PostgreSQL (Burak Yucesoy)
• Enhancements to the bitemporal model support: integrity constraints (Boris Novikov, Chad Slaughter, Henrietta Dombrovskaya)
• ETL Confessions (Corey Huinker)
• Get to know Google Cloud SQL (Alexis Guajardo, Brett Hesterberg)
• How Postgres Could Index Itself (Andrew Kane)
• Human Beings Do Not Have a Primary Key (Christophe Pettus)
• Improving Postgres' Efficiency (Andres Freund)
• Logical Replication.... LIVE! (Robert Treat)
• Monitoring 101 (Jason Yee)
• PanLex: Using PostgreSQL to implement a massive word-translation graph (David Kamholz)
• PastgreSQL: Dead data tells all tales! (Samuel Elston, Srivathsava Rangarajan)
• PgBouncer and 20000 TPS at one node: advanced tuning, hacks and problem solving (Victor Yagofarov)
• PostgreSQL as a distributed computing platform (Marco Slot)
• PostgreSQL at Pandora (Stephen Rees)
• PostgreSQL BI Performance & News from XL project (Mark Wong)
• PostgreSQL, REST API’s and Rapid Application Development for Legacy Data (Charles Finley)
• PostgreSQL Security for Application Developers (Sehrope Sarkuni)
• Postgres Window Magic (Bruce Momjian)
• Replication based Multi-Master solutions and design patterns (Tom Kincaid)
• Scalable in-database machine learning with PL/Python (Srivatsan Ramanujam)
• Scaling a Saas application beyond a single Postgres with Citus. (Jesse H. Willett)
• Schrödinger's Elephant (Josh Berkus)
• Securing PostgreSQL -- Exploring the PostgreSQL STIG and Beyond (Joe Conway, Sarah Conway)
• The Immortal Postgres Web (Shaun Thomas)
• Tuning PostgreSQL for High Write Workloads (Grant McAlister)
• Your database migrations are bad and you should feel bad (Robert Lechte)