Postgres Vision 2019: Full Schedule

10:00am EDT

Training Workshop: Deploying EDB Postgres Containers with Google Kubernetes Engine

Deploying EDB Postgres Containers with Google Kubernetes Engine

EDB containers can operate standalone or be orchestrated by Kubernetes and deployed into any cloud environment. Designed for DBAs, Developers and Architects this training will help you understand multitenant architecture and you will learn how to deploy, manage and use EDB Containers with Kubernetes. You will also be able to see a live demo of how EDB Containers provide Highly available, resilient and scalable EDB Postgres Clusters.

Learn more and register.

Pre-requisites: Basic knowledge of EDB Postgres and Google Kubernetes Engine

Speakers

Rupinder Singh

Technical Trainer, PostgreSQL and EDB Postgres, EnterpriseDB

Rupinder Singh is a leading Technical Trainer for PostgreSQL and EDB Postgres technologies. He has also been a Lead Systems Engineer at EnterpriseDB, and has over 10 years of Postgres experience. He is one of EDB’s most frequent trainers who has delivered hundreds of Postgres training... Read More →

Monday June 24, 2019 10:00am - 4:00pm EDT
Back Bay A The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Training, Workshop

6:00pm EDT

Informal Meet and Greet at the Sheraton Hotel bar

They'll be an informal gathering in the Sheraton Hotel bar - (Lobby Level) for our conference guests arriving the evening of June 24th starting at 6pm. Meet and greet your colleagues before the conference.

Monday June 24, 2019 6:00pm - 8:00pm EDT
The Sheraton Hotel bar on the Lobby level The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Meals, Networking

7:00am EDT

Registration Opens at Registration Desk

Tuesday June 25, 2019 7:00am - 5:00pm EDT
Exposition Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA , 02199

Registration

7:30am EDT

Breakfast

Breakfast will be served in the Ballroom Foyer from 7:30am to 8:30am.

Tuesday June 25, 2019 7:30am - 8:30am EDT
Constitution Ballroom The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Meals, Networking

8:10am EDT

EDB Postgres "Meet the Expert" Meetings

Ask your questions about our technology, tools and services directly of EDB Postgres experts. Click below to book in advance or walk-up based on availability.

PostgreSQL: Have a chat about PostgreSQL with our foremost experts
EDB Postgres Advanced Server: Talk to EDB about our Postgres Advanced Server
Enterprise Failover Manager: Discuss EFM with EDB’s own architects
Replication Server: Have a question about xDB or Replication Server 7? Talk to us.
Postgres Migrations: Talk to our migration code experts.
Postgres Connectors: Learn more about EDB and our Postgres Connectors
Postgres Enterprise Manager: Have a question about PEM?
EDB Cloud Database Service: Learn more about EDB’s cloud-based database cluster solution
EDB Support Services: Want to learn more about Technical Support or RemoteDBA?

Tuesday June 25, 2019 8:10am - 4:40pm EDT
Back Bay D The Sheraton Boston Hotel, 39 Dalton St, Boston, MA 02199

Expert Session Meetings, Tech and Tools Track

8:30am EDT

Keynote: A Look Ahead Into the Future of Tech

World Wide Web Inventor, Sir Tim Berners-Lee to Deliver Keynote at Postgres Vision
Register now to save your seat for this talk, “A Look Ahead Into the Future of Tech”. Sir Tim Berners-Lee will look beyond the technology itself and into the real transformative impact these technologies are having and will have in the years ahead, including the Internet of Things, artificial intelligence, power of data, the impact of security and privacy, and his new project to re-decentralize the Web, Solid.

Speakers

Sir Tim Berners-Lee

Inventor of the World Wide Web, President and Founder, Open Data Institute

Named one of TIME magazine’s “100 Most Important People of the 20th Century,” one of the UK’s "100 Greatest Britons,” and one of the world's "Most Influential Thinkers,” Sir Tim Berners-Lee created the most powerful communication medium in the world — the World Wide... Read More →

Tuesday June 25, 2019 8:30am - 9:30am EDT
Grand Ballroom: General Session Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Keynote, Vision Track

9:30am EDT

Keynote: Postgres Takes Charge Around the World

Join this talk as open source veteran Ed Boyajian explores the past, present, and future of Postgres.

Speakers

Ed Boyajian

President and CEO of EDB, EnterpriseDB

Ed Boyajian, President and CEO of EDB, drives the development and execution of EDB’s strategic vision and growth strategy in the database industry. Ed joined EDB in 2008 after six years at Red Hat, where he rose to Vice President and General Manager of North America. He played a... Read More →

Tuesday June 25, 2019 9:30am - 10:00am EDT
Grand Ballroom: General Session Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Keynote, Vision Track

10:00am EDT

Morning Coffee Break

Take a break, grab a snack, meet our sponsors in the Expo Hall. Connect, collaborate, and network. Fuel-up and then hustle back. We’ve got another engaging keynote on deck.

Tuesday June 25, 2019 10:00am - 10:30am EDT
Exposition Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA , 02199

Break, Networking

10:00am EDT

Invitation Only: Meet the Speaker

Speakers

Ed Boyajian

President and CEO of EDB, EnterpriseDB

Tuesday June 25, 2019 10:00am - 10:30am EDT
Liberty B The Sheraton Boston Hotel 39 Dalton St, Boston, MA 02199

Meet and Greet

10:30am EDT

Real-World Postgres Deployment Stories

Real-World Postgres Deployment Stories:
Your peers discuss their real-world stories of how Postgres is helping them outmaneuver competitors, reduce costs, and invest more in innovation. This panel of experts will share insights into what motivated them to deploy Postgres, what they learned in the process, and what they hope to do next.

Speakers

Ken Rugg

Chief Product and Strategy Officer, EnterpriseDB

Ken Rugg is EDB's Chief Product and Strategy Officer and is charged with leading the company's product and strategic vision. Prior to joining EDB, Ken was the founder and CEO of Tesora. The Tesora DBaaS Platform, based on OpenStack Trove, let enterprises provide self-service database... Read More →

Mujeeb AbdurRahman

Senior Manager, IT - Database, ULTA Beauty

Steve Mento

Infrastructure PM - Associate, Booz Allen Hamilton

Steve has 16 years industry experience, over 11 years with Booz Allen, primarily in database development, administration and architecture. His focus areas include database strategy, technical management of concurrent initiatives and the adoption of new technology. His experience includes... Read More →

Kelly Poole

Field CTO, EnterpriseDB

Craig Guarente

CEO & Founder, Palisade Compliance

Craig is the CEO and founder of Palisade Compliance. Founded in 2011, Palisade Compliance is now the leading independent provider of Oracle licensing, contracting, audit defense, and cost reduction services. Palisade Compliance enables businesses to reduce their Oracle costs, stay... Read More →

Benny Rutten

Senior Database Administrator

Benny Rutten is an experienced Oracle and Postgres Database Administrator and also manages also Cassandra, RabbitMQ, and Redis environments.

Tuesday June 25, 2019 10:30am - 11:05am EDT
Grand Ballroom: General Session Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Panel Discussion, Real World Track

11:05am EDT

10-Minute Break: Transition to Breakout #1 Sessions

Take a break, grab a snack, and then file into our first group of Breakout Sessions!

Tuesday June 25, 2019 11:05am - 11:15am EDT
Transition Time 5-Minute Break: Transition Time to go to Breakout Sessions

Break, Transition Time

11:15am EDT

Creating Continuously Up to Date Materialized Aggregates

Time-series workloads (i.e. data from sensors, IoT devices, finance, or even satellites) are generally insert-mostly, and data typically arrives in time order (at regular or irregular intervals). Given the high velocity and continuous workload of writing time-series, insert performance is paramount. But what is the use of inserting a significant amount of data if you can't analyze, visualize, and act on it effectively? Unlike many OLTP workloads, you often don't need the granularity of each data point, but rather reports on aggregates over significant periods of time and other analysis are the key to making good decisions with the data you store.

This talk describes how TimescaleDB (a time-series database packaged as an extension of PostgreSQL) has implemented the infrastructure for creating continuously up-to-date aggregates without write amplification using features of Postgres (partial aggregates, invalidation triggers, proper locking/transaction safety, background workers, union views, query planner etc.), as well as how/when to use these pre-calculated results to speed your queries.

Speakers

David Kohn

Software Engineer, Timescale

After earning a B.S. in Environmental Engineering at Yale, founding an electrochemistry startup, joining a battery startup, and doing crazy things with Postgres for Moat (an ad-analytics company), David joined Timescale to focus on research and development. He also cooks, does pottery... Read More →

Tuesday June 25, 2019 11:15am - 12:00pm EDT
Back Bay B The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Tech and Tools Track

11:15am EDT

KT/KTDS Case Study: Open Source Database Adoption in Telecom

Join this session to hear this real-life story from KT/KTDS. They will share the experience of the migration of their Oracle Database to EDB Postgres. Their story will include adoption history, technology verification, governance, diffusion, adoption effect and open source database technical support. Furthermore, they will discuss their application methodology approach and migration tools deployed. Don't miss this session to learn from their experience and insights.

Speakers

Eun Jung Sin

SW Strategy Planning Manager, KT/KTDS

Eunjung Sin is a SW strategy planning manager in KT. She is in charge of governance of the purchase and use of commercial and open source SW. Especially, she is responsible for checking the compliance of open source SW. Before KT, she worked as a SW Engineer for 12 years.

Hyun Ji Lee

PostgreSQL DBA, KT/KTDS

Hyunjee lee is a DBA in KT/KTDS. She has been working on Postgres migration projects for several systems such as iPhone Reservation System in KT group last 6 years, responsible for consulting and technical support in KT group.

Tuesday June 25, 2019 11:15am - 12:00pm EDT
Back Bay A The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Real World Track

11:15am EDT

Preview of the EDB Postgres Roadmap

Join Ken Rugg and John Dalton for a preview of the EDB Postgres product roadmap. Is your organization developing new applications? Moving off of Oracle? Moving to the cloud? Operating highly available Postgres at scale? Learn what is being planned for the platform to support your enterprise Postgres requirements. Want to go deeper on a topic? This is where to get connected to other conference sessions and Postgres experts.

Speakers

Ken Rugg

Chief Product and Strategy Officer, EnterpriseDB

John Dalton

Senior Director of Product Management, EnterpriseDB

John Dalton is Senior Director of Product Management at EDB. SaaS and enterprise software has been his focus as a product management leader for the past 12 years. In his current and most recent roles, he championed the use of business cases, KPIs, and Agile principles by product managers... Read More →

Tuesday June 25, 2019 11:15am - 12:00pm EDT
Back Bay C The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Vision Track

12:00pm EDT

Lunch

Breakfast will be served in the Ballroom Foyer from 12:00pm to 1:00pm.

Tuesday June 25, 2019 12:00pm - 1:00pm EDT
Constitution Ballroom The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Meals, Networking

1:00pm EDT

Lightning Talk: A Multi-layered Security Architecture for Your Postgres Databases

Data security has never been more important than it is today. Considering the amount of data collection most modern apps require, it’s not just imperative to keep private and proprietary safe and secure — with measures like the European Union’s GDPR, it’s also the law. For organizations running any sort of data operation, keeping databases secure from existing and emerging threats is crucial. EDB's approach to data security uses a multi-layered security architecture. Join this session to learn about how this approach is designed and implemented.

Speakers

Marc Linster

Senior Vice President, Product Development, EnterpriseDB

Marc Linster, Ph.D., is EDB’s Senior Vice President of Product Development and leads EDB’s engineering divisions and product development groups.Marc is committed to EDB being an accelerator to providing architectural “know how” to help customers take advantage of Postgres... Read More →

Tuesday June 25, 2019 1:00pm - 1:20pm EDT
Back Bay C The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Lightning Talk

1:00pm EDT

Lightning Talk: The Next Generation of EDB Postgres Replication Server

EDB Postgres Replication Server (EPRS) has been re-architected to meet growing data integration challenges and enable fast data movement to meet today’s enterprise high-availability requirements. Join this session to hear what is new.

Speakers

Zahid Iqbal

Senior Director, Tools Development, EnterpriseDB

Zahid Iqbal is Senior Director, Tools Development, and leads the design and implementation of EDB Postgres Replication Server. Zahid has been with EDB since 2004, the year the company was founded. Prior to EDB, Zahid was a team leader as Architect/Project Manager at Diyatech. He holds... Read More →

Tuesday June 25, 2019 1:00pm - 1:20pm EDT
Back Bay B The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Lightning Talk

1:00pm EDT

Lightning Talk: Where Should You Deliver Database Services From?

Organizations have a choice when it comes to database platform. On the one hand, the dev platforms that cloud vendors provide are fast and loaded with tools, you don’t manage the infrastructure and only pay for what you use. On the other hand, deploying on premises can mean better control over performance, security, user experience and compliance. This session discusses making those choices – not for one app, but at enterprise scale. What should you consider? Which factors say “cloud”? Which factors say “on premises”? And can you get a consumption-based experience either way?

Speakers

Kevin Lange

Master Database Architect, HPE Pointnext Services

Kevin has been with HPE for 8 years, serving as a consulting technologist in HPE’s World Wide application and database portfolio. His background includes over 25 years of progressive database experience as a developer, DBA and architect. Kevin launched the 1st Database Modernization... Read More →

Tuesday June 25, 2019 1:00pm - 1:20pm EDT
Back Bay A The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Lightning Talk

1:20pm EDT

10-Minute Break: Transition Time to go to Breakout #3 Sessions

Tuesday June 25, 2019 1:20pm - 1:30pm EDT
Transition Time 5-Minute Break: Transition Time to go to Breakout Sessions

Break, Transition Time

1:30pm EDT

Break Free Of Your Oracle Contracts And Reduce Your Oracle Spend

Oracle contracts and policies are designed to lock in customers and increase your costs. Even companies moving to open source solutions and reducing their reliance on Oracle technology can be trapped in a never ending cycle of Oracle cost increases. In this session we will learn how to gain leverage with Oracle and break free of your restrictive Oracle contracts. Join Craig Guarente, formerly Oracle’s Global VP of Contracts and Business Practices, and now Founder and CEO of Palisade Compliance, as we walk through the steps necessary to gain leverage on Oracle and increase your flexibility to adopt Open Source Solutions like EDB’s Postgres.

Speakers

Craig Guarente

CEO & Founder, Palisade Compliance

Tuesday June 25, 2019 1:30pm - 2:15pm EDT
Back Bay B The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Real World Track

1:30pm EDT

Breakout: Nutanix Era - Postgres and One-Click Simplicity

Speakers

Mehboob Alam

Postgres Evangelist/Sr. Solutions Architect, Postgres DBaaS, Nutanix

Mehboob Alam is a community Postgres evangelist and has helped build the open-source community around Postgres in NY over the last ten years. His first database was Ingres, the pre-cursor to Postgres developed at UC Berkeley. He recently joined Nutanix as a Sr. Solutions Architect... Read More →

Mike McGhee

Principal Technical Marketing Engineer, Nutanix

Mike has 20 years of experience in the IT industry and is currently focused on assisting customers and partners better understand the core functionality of the Nutanix platform. Mike has responsibilities around Nutanix Files, Nutanix Volumes, Metro Availability, Era and the Microsoft... Read More →

Tuesday June 25, 2019 1:30pm - 2:15pm EDT
Back Bay A The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Vision Track

1:30pm EDT

What to Expect in PostgreSQL 12

PostgreSQL 12, due out early Fall 2019, is the results of tens of thousands of hours of work by hundreds of people, and it brings important improvements in a wide variety of areas. This talk will cover some of the most important changes and improvements, including improvements to partitioning, indexing, and the query planner; changes to recovery and replication, the exciting new table access method interface, and other forthcoming improvements.

Speakers

Robert Haas

Vice President, Chief Database Architect, EnterpriseDB, PostgreSQL committer and major contributor

Robert is a 15-year database industry veteran and has been a major contributor to the PostgreSQL Global Development Group since 2008. He joined EDB in 2010 after spending just over two years with SNiP as Director of Business Engineering. Prior to that he was a Senior Systems Analyst... Read More →

Tuesday June 25, 2019 1:30pm - 2:15pm EDT
Back Bay C The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Vision Track

2:15pm EDT

10-Minute Break: Transition Time to go to Breakout #4 Sessions

10-Minute Break: Transition Time to go to Breakout #3 Sessions

Tuesday June 25, 2019 2:15pm - 2:25pm EDT
Transition Time 5-Minute Break: Transition Time to go to Breakout Sessions

Break, Transition Time

2:25pm EDT

Advanced Database Patterns for Kubernetes

Speakers

Oscar Herrera

Senior Vice President, Services, EnterpriseDB

Oscar Herrera is EDB’s Senior Vice President, Services. He is responsible for EDB’s global consulting and training organizations and serves as a Field CTO by providing leadership to the teams inside large enterprise customers that are adopting EDB Postgres or expanding deployments... Read More →

Tuesday June 25, 2019 2:25pm - 3:10pm EDT
Back Bay C The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Vision Track

2:25pm EDT

Managing Postgres at Scale with PEM

Join Dave Page as he shows you how to manage large scale Postgres deployments and highlights how Postgres Enterprise Manager can be used for monitoring, alerting and administration of your Postgres estate - no matter where it is deployed.

Speakers

Dave Page

Vice President and Chief Architect, Tools & Installers, EnterpriseDB, PostgreSQL Core Team Member

Dave Page is Vice President and Chief Architect, Tools & Installers. In this role, Dave manages the development of EDB’s suites of tools that support database administrators in using EDB Postgres, and he oversees the build processes and development of installers and packages for... Read More →

Tuesday June 25, 2019 2:25pm - 3:10pm EDT
Back Bay B The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Tech and Tools Track

2:25pm EDT

Vacuuming: Through Pictures

Proper Vacuum operations is an important function of any Postgres deployment. Vacuum is at the core of many Postgres operational items. Having a Postgres deployment properly tuned for vacuum is critical for all successful Postgres production instances. Unfortunately, may people struggle with the concepts behind vacuum and auto-vacuum. Hence, DBAs and Developers become extremely confused about how to tune the critical functionality associated with them (i.e. reclaiming dead tuples, freezing tuples and analyzing tables).

This talk will cover some key concepts of Postgres Vacuum and Autovacuum and some of the concepts around properly tuning Vacuum. This talk will include extensive use of diagrams, illustrations and animations to present the concepts around Postgres Vacuum and tuning Postgres Vacuum. The talk will be augmented with real life stories about how tuning vacuum properly makes a difference.

Speakers

Tom Kincaid

General Manager, 2nd Quadrant

Tom in the General Manager for 2ndQuadrant in North America. He has been developing, deploying and supporting Database Systems and Enterprise Software for over 25 years. Tom had total product delivery ownership for the Progress OpenEdge platform which included a relational database... Read More →

Andrew Dunstan

Database Architect, 2ndQuadrant

Andrew Dunstan is a PostgreSQL developer at 2ndQuadrant, a Core Committer on the PostgreSQL project and PostgreSQL Specialist.

Tuesday June 25, 2019 2:25pm - 3:10pm EDT
Back Bay A The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Tech and Tools Track

3:10pm EDT

10-Minute Break: Transition Time to go to Breakout #5 Sessions

10-Minute Break: Transition Time to go to Breakout #4 Sessions

Tuesday June 25, 2019 3:10pm - 3:20pm EDT
Transition Time 5-Minute Break: Transition Time to go to Breakout Sessions

Break, Transition Time

3:20pm EDT

New Developments in Pluggable Storage in PostgreSQL

For PostgreSQL 12, the PostgreSQL developers, including Andres Freund, have worked hard at making table storage pluggable, i.e. allowing to store table data in different forms than PostgreSQL's current heap.

The goal of this work so is mainly twofold: First, to be able to address new use cases that PostgreSQL's current storage is not well suited for (e.g. columnar stores for analytics workloads). Second, to be able to make architectural changes to even better handle workloads PostgreSQL is already widely used for (e.g. to reduce problems with VACUUM and increase storage density.

In addition to the reasons for making Postgres' table storage pluggable, the talk will give a brief overview over the new API, explain what types of table stores can already be implemented using it, and what types are not yet possible, and how the limitations of the API prevent the latter can be addressed in future versions of PostgreSQL.

Speakers

Andres Freund

PostgreSQL Developer & Committer, Senior Database Architect, EnterpriseDB

Andres Freund is one of the leading contributors in the Postgres community and his work has been influential to advancing the replication, performance and scalability capabilities of Postgres. He joins EDB from Citus Data, Inc., where he was a Developer and Principal Software Engineer... Read More →

Tuesday June 25, 2019 3:20pm - 4:05pm EDT
Back Bay C The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Tech and Tools Track

3:20pm EDT

The Vision for Graph Database from Postgres

Due to the 4th Industrial Revolution, the IT industry is making continuous progress. However, flood of unstructured big data through various devices are pouring in and the customers’ needs are becoming more complicated than ever. Although PostgreSQL is definitely an enterprise-class, high quality DBMS, several options require some reviews to meet the various purposes of corporate users.

In this session, we will introduce the concept of Graph Database (which has strength in relation-based data analysis during this hyper-connected era) and the synergy effect in combination of Postgres and NoSQL (Graph Database). Through this session, the attendees will be able to discover a direction of Postgres’ unlimited scalability.

Speakers

Eya Badal Abdisho

Technical Engineer, Bitnine Global

Eya Badal Abdisho is a Technical Engineer of Bitnine Global Inc. responsible for consulting and implementation of AgensGraph, the multi model (Postgres + Graph DB) database management system. Previously, Eya worked as a Technical Project Manager at the CoderSchool. Eya has a Bachelor's... Read More →

Junseok Yang

Software Engineer, Bitnine Global, Inc.

Junseok Yang is a senior software engineer at Bitnine who works on graph database development. Previous to Bitnine, Junseok had experience with developing clustered volume manager based on RDBMS, distributed RDBMS, and network manager for clustered file system and distributed file... Read More →

Tuesday June 25, 2019 3:20pm - 4:05pm EDT
Back Bay B The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Vision Track

3:20pm EDT

The World of PostGIS

Join this session with leading experts in PostGIS, Regina Obe and Leo Hsu. They will show you how to load and query spatial data, spotlight the problems you can solve with PostGIS, and identify the most common queries people are using PostGIS for today. Plus, gain insights on way to obtain free spatial data and load all kinds of spatial data with ogr_fdw and ogr2ogr, and QGIS dbmanager. Regina and Leo will also preview what changes you can expect in PostGIS 3.0

Speakers

Regina Obe

Project Steering Committee member of PostGIS, Co-founder Paragon Corporation, Paragon Corporation

Regina Obe is a co-founder of Paragon Corporation, a Boston-based PostgreSQL/PostGIS consulting company. She is a member of the PostGIS and GEOS project steering committee, as well as a development team member of several geospatial Projects (PostGIS, GEOS, pgRouting, and on OSGeo... Read More →

Leo Hsu

Co-founder, Paragon Corporation

Leo Hsu is co-founder of Paragon Corporation, a Boston-based PostgreSQL/PostGIS consulting company. He is also a co-author of several books on PostgreSQL, PostGIS, and pgRouting (another PostgreSQL extension commonly used with PostGIS) with his wife and partner, Regina Obe.

Tuesday June 25, 2019 3:20pm - 4:05pm EDT
Back Bay A The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Tech and Tools Track

4:05pm EDT

10-Minute Break: Return to General Session Hall for Closing Keynote

10-Minute Break: Please return to the General Session Hall for our Day 1 Closing Keynote: Bruce Momjian

Tuesday June 25, 2019 4:05pm - 4:15pm EDT
Transition Time 5-Minute Break: Transition Time to go to Breakout Sessions

Break, Transition Time

4:15pm EDT

The Democratization of Databases

This presentation covers the history of various governing structures and why democracy provides superior results. It then explains that open source is a form of democracy, compared to the methods used by proprietary software producers. It covers the many benefits Postgres has enjoyed using an open development model, and how its future remains bright.

Speakers

Bruce Momjian

Co-founder of the PostgreSQL Global Development Group, Senior Database Architect, EnterpriseDB, PostgreSQL Core Team Member

Bruce Momjian is a co-founder of the PostgreSQL Global Development Group and a Senior Database Architect at EDB. He has worked on PostgreSQL since 1996 as a committer and community leader. He is a frequent speaker and Postgres evangelist and travels worldwide appearing at conferences... Read More →

Tuesday June 25, 2019 4:15pm - 5:00pm EDT
Grand Ballroom: General Session Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Keynote, Vision Track

5:00pm EDT

1-Hour Break: Please Join Us for Cocktails and Dinner starting at 6pm

Tuesday June 25, 2019 5:00pm - 6:00pm EDT
Transition Time 5-Minute Break: Transition Time to go to Breakout Sessions

Break, Transition Time

6:00pm EDT

Cocktails, Dinner, and Networking: Sponsored by EDB Postgres Cloud Database Service

Don’t miss the party and an opportunity to make some conversation with EDB's Postgres contributors. Join us for cocktails, hors d'oeuvres, and networking in our Postgres Vision Expo Hall. All EDB's leading voices in the PostgreSQL community will be in attendance!

Tuesday June 25, 2019 6:00pm - 8:00pm EDT
Exposition Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA , 02199

Meals, Networking

7:00am EDT

Registration Opens at Registration Desk

Wednesday June 26, 2019 7:00am - 4:00pm EDT
Exposition Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA , 02199

7:30am EDT

Breakfast

Wednesday June 26, 2019 7:30am - 8:30am EDT
Constitution Ballroom The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Meals, Networking

8:10am EDT

EDB Postgres "Meet the Expert" Meetings

Wednesday June 26, 2019 8:10am - 4:40pm EDT
Liberty B The Sheraton Boston Hotel 39 Dalton St, Boston, MA 02199

Expert Session Meetings, Networking

8:30am EDT

Keynote: The Land Sharks are on the Squawk Box (Where Did Postgres Come From?)

This Turing Award talk intermixes a bicycle ride across America during the summer of 1988 with the design, construction and commercialization of Postgres during the late 80’s and early ‘90’s. Striking parallels are observed, leading to a discussion of what it takes to build a new DBMS. Also, indicated are the roles that perseverance and serendipity played in both endeavors.

Speakers

Dr. Michael Stonebraker

Chief Technology Officer of Paradigm4 and Tamr, Inc., Adjunct Professor of Computer Science at M.I.T and co-director of the Intel Science and Technology Center

Dr. Stonebraker has been a pioneer of database research and technology for more than forty years. He was the main architect of the INGRES relational DBMS, and the object-relational DBMS, POSTGRES. These prototypes were developed at the University of California at Berkeley where Stonebraker... Read More →

Wednesday June 26, 2019 8:30am - 9:45am EDT
Grand Ballroom: General Session Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Keynote, Vision Track

9:45am EDT

So You’ll be Working With Women or Other Under-Represented Groups

One of the great strengths of PostgreSQL is that it is used by a diverse universe of people. We can make it stronger by highlighting that diversity and growing the visibility of under-represented contributors.

Join Renee Phillips, the founder of New York City's branch of PostgreSQL Women, for a talk that offers an introduction to the tools, sites, and concepts available to aid in working with people from a variety of backgrounds. This talk will include some sociology and global statistics, and addresses the impact of having homogeneous work teams and reasons people flee the workspace due to discomfort.

New York City's branch of PostgreSQL Women regularly hosts inclusive monthly talks and workshops.
A version of this talk was presented at pgDay Paris in 2019.

Speakers

Renee Phillips

Founder of New York City's branch of PostgreSQL Women

Wednesday June 26, 2019 9:45am - 10:15am EDT
Grand Ballroom: General Session Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Keynote, Vision Track

10:15am EDT

Coffee Break for the General Session

Take a break, grab a snack, meet our sponsors in the Expo Hall. Connect, collaborate, and network. Fuel-up and then hustle back. We’ve got another engaging keynote on deck.

Wednesday June 26, 2019 10:15am - 10:30am EDT
Exposition Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA , 02199

Break, Networking

10:30am EDT

Keynote: Freedom to Innovate - Postgres in the Cloud

Speakers

Mehboob Alam

Postgres Evangelist/Sr. Solutions Architect, Postgres DBaaS, Nutanix

Wednesday June 26, 2019 10:30am - 11:00am EDT
Grand Ballroom: General Session Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Keynote, Vision Track

11:00am EDT

Real-World Insights on the Impact of Containers, DevOps, and Agile Analytics on IT

Hear from your peers on how Containers, DevOps, Agile Analytics are impacting their approach to data, databases and IT.

Speakers

Mujeeb AbdurRahman

Senior Manager, IT - Database, ULTA Beauty

Ken Rugg

Chief Product and Strategy Officer, EnterpriseDB

Taylor Graham

Field CTO, EnterpriseDB

Taylor Graham is a Field CTO in the Global Services Team and works with the sales engineers and Solution Architecture Team to help customers understand how to use EDB Postgres for their digital business transformations. Prior to joining EDB, Graham worked at IPsoft, a firm focused... Read More →

Benny Rutten

Senior Database Administrator

Benny Rutten is an experienced Oracle and Postgres Database Administrator and also manages also Cassandra, RabbitMQ, and Redis environments.

Wednesday June 26, 2019 11:00am - 11:30am EDT
Grand Ballroom: General Session Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Panel Discussion, Real World Track

11:30am EDT

10-Minute Break: Transition to Breakout #1 Sessions

Wednesday June 26, 2019 11:30am - 11:40am EDT
Transition Time 5-Minute Break: Transition Time to go to Breakout Sessions

Break, Transition Time

11:40am EDT

Lightning Talk: Data Modernization Journey to Cloud – Our Approach, Experiences and Methodology

There is a wave of application modernization and workload migration to cloud. Data Modernization is a very important component of this Modernization Journey. While assisting our customer, we have realized that successful Data Modernization is a combination of Art and Science; combination of right approach, methodology and tools. In this session, we will discuss how we approach a typical data modernization program, the typical nuances and learnings from our experiences.

Speakers

Dhaval Jagani

Principal Architect, Infosys

Dhaval Jagani is a solution architect with deep legacy modernization experience. He leads a team of architects from the open source database practice in US for the Infosys Modernization COE, who assist the clients of Infosys in developing right fit solution for their business objectives... Read More →

Wednesday June 26, 2019 11:40am - 12:00pm EDT
Back Bay A The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Lightning Talk

11:40am EDT

Lightning Talk: Good Data Gone Bad, Bad Data Gone Worse

How bad data gets into the pipeline, how developers make data bad and worse in the pipeline. This talk will look at data sources, data types, and ways Postgres can be used to abuse data. Renee Phillips brings her experience before joining the tech world, and after to discuss problems seen in many data sources. Renee's background in Medical Anthropology and work in various industries taught her the effects of bad data on decision making. Her recent experience doing QA for a startup gave her new insight into data quality issues at the source. She will talk about some of the things that a user can do or not do in PostgreSQL that might or will definitely lead to data corruption.

This talk is suitable for users of all experience levels. A version of this talk was presented at PGDay Nordic in 2019

Speakers

Renee Phillips

Founder of New York City's branch of PostgreSQL Women

Wednesday June 26, 2019 11:40am - 12:00pm EDT
Back Bay C The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Lightning Talk

11:40am EDT

Lightning Talk: How to Build On-demand Oracle Compatible Postgres Database in Minutes

Learn how to build an on-demand Oracle compatible Postgres database in minutes with EDB Postgres Cloud Database Service (CDS), featuring a LIVE demo!

Speakers

Kanchan Mohitey

Director, Cloud Services, EnterpriseDB

Kanchan Mohitey is an accomplished and result-driven senior professional with more then 15 years of experience in Database domain. She has a proven track record of driving technical and operational excellence within culturally diverse environments. She has a startup mindset with experience... Read More →

Wednesday June 26, 2019 11:40am - 12:00pm EDT
Back Bay B The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Lightning Talk

12:00pm EDT

Lunch

Wednesday June 26, 2019 12:00pm - 1:15pm EDT
Grand Ballroom: General Session Hall The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Meals, Networking

1:15pm EDT

MongoDB vs. Postgres Benchmarks

Benchmarking is hard. Benchmarking databases, harder. Benchmarking databases that follow different approaches (relational vs document) is even harder.

But the market demands these kinds of benchmarks. Despite the different data models that MongoDB and PostgreSQL expose, many organizations face the challenge of picking either technology. And performance is arguably the main deciding factor.

Join this talk to discover the numbers! After $30K spent on public cloud and months of testing, there are many different scenarios to analyze. Benchmarks on three distinct categories have been performed: OLTP, OLAP and comparing MongoDB 4.0 transaction performance with PostgreSQL's.

What would be faster, MongoDB or PostgreSQL? There's only one way to know: attend this talk!

Speakers

Alvaro Hernandez

Founder, Ongres

Álvaro Hernandez is a passionate database and software developer. He has been an almost exclusive user of PostgreSQL, as THE database, for more than 15 years. Founder of OnGres, he is dedicated to R&D in databases. Álvaro founded ToroDB, previously the “Billion Tables Project... Read More →

Wednesday June 26, 2019 1:15pm - 2:00pm EDT
Back Bay C The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Real World Track

1:15pm EDT

Optimizing Performance and Security with Platform Native Packaging

The PostgreSQL community already provides native packages on a number of platforms, and it is considered the best way to install PostgreSQL on those platforms. Learn how EDB is now bringing this enhancement to our products as well.

Speakers

Devrim Gündüz

PostgreSQL, Red Hat, and Fedora contributor, Principal Systems Engineer, EnterpriseDB

As a contributor to the PostgreSQL Community, Devrim Gündüz is the lead maintainer of the PostgreSQL YUM repository, and contributes to other PostgreSQL-related projects. At EDB, Devrim Gündüz specializes in clustering, high availability and replication solutions for EDB Postgres... Read More →

Wednesday June 26, 2019 1:15pm - 2:00pm EDT
Back Bay B The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Tech and Tools Track

1:15pm EDT

Scaling PostgreSQL for High Performance with Increased Database Load and Data

A well maintained database that has been performing fast may suddenly start to degrade due to increased traffic or data. So, how should we scale up? Should we increase the memory or add more CPU cores? Would faster storage help? How can we scale a PostgreSQL server so that it can do the best forever with increasing data volume and transactions over a period of time ? In this presentation, we shall discuss how a connection pooler, load balancer, partitioning, tablespaces and a few extensions can help us scale a PostgreSQL server.

Speakers

Avinash Vallarapu

PostgreSQL Tech Lead, Percona

Avinash Vallarapu (Avi) is currently working for Percona as a PostgreSQL Support Tech Lead. Before joining Percona, he worked for OpenSCG for 2.2 years as a Database Architect and for Dell as a Tech Lead for 9.8 Years. He has a vast experience in technologies like Oracle, PostgreSQL... Read More →

Wednesday June 26, 2019 1:15pm - 2:00pm EDT
Back Bay A The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Tech and Tools Track

2:00pm EDT

10-Minute Break: Transition to Breakout #3 Sessions

10-Minute Break: Transition Time to go to Breakout Sessions

Wednesday June 26, 2019 2:00pm - 2:10pm EDT
Transition Time 5-Minute Break: Transition Time to go to Breakout Sessions

Break, Transition Time

2:10pm EDT

Bringing DevOps to the Database

In this talk, we'll discuss what makes databases different from other parts of the software development stack when it comes to DevOps methodologies, the architecture patterns for managing databases in DevOps oriented workflows, and ideas and options for managing the people who currently manage your database operations.

Speakers

Robert Treat

CEO, America, credativ

Working on database backed, internet based systems for over a decade, Robert is a long time user, developer, and advocate for open source technologies. Best known for his work in the Postgres community, he has contributed to dozens of projects over the years and served on numerous... Read More →

Wednesday June 26, 2019 2:10pm - 2:55pm EDT
Back Bay A The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Vision Track

2:10pm EDT

No Time to Waste: Migrate from Oracle to Postgres in Minutes

Need to break free from Oracle? An open source-based DBMS like Postgres is the answer. So, what is stopping you? Discover how to migrate from Oracle to Postgres, quickly and without risk. This talk will explain how to leverage tools and technologies to convert your Oracle database to EDB Postgres with ease and offer helpful best practices, including:

What challenges to look for, like complex schemas, database stored procedures and more
Where to start, like self-contained databases that help free up Oracle licenses
And, when to deploy your workload on-premises or in the cloud

PLUS, DON’T MISS THIS LIVE DEMO:
We will demo a sample Oracle database migration, including the schema and the data, in just minutes using the fully-automated EDB Postgres Migration Portal.

Speakers

Prashant Agarwal

Sr. Development Manager, EnterpriseDB

Prashant Agarwal is a Sr. Development Manager at EnterpriseDB and manages different tools around Postgres & Postgres Advanced Server. He has overall 13+ yrs of industry experience and leads teams for MTK, Migration Portal & Cloud Database Service (CDS - EDB's upcoming offering).

Wednesday June 26, 2019 2:10pm - 2:55pm EDT
Back Bay B The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Tech and Tools Track

2:10pm EDT

The Future of Sharding

Speakers

Craig Kerstiens

Head of Cloud, Citus Data/Microsoft

Craig Kerstiens heads up the Cloud team at @citusdata. Citus extends Postgres to be a horizontally scalable distributed database. Previously, Craig spent a number of years @heroku, a Platform-as-a-service, which takes much of the overhead out of IT from keeping the lights on and lets developers focus on building features and adding... Read More →

Wednesday June 26, 2019 2:10pm - 2:55pm EDT
Back Bay C The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Vision Track

2:55pm EDT

10-Minute Break: Transition to Breakout #4 Sessions

Wednesday June 26, 2019 2:55pm - 3:05pm EDT
Transition Time 5-Minute Break: Transition Time to go to Breakout Sessions

Break, Transition Time

3:05pm EDT

HTAP By Accident: Getting More From PostgreSQL Using Hardware Acceleration

Big Data. Data Science. AI. It's all big business.
Once upon a time we succeeded in these fields by selectively storing, processing and learning from just the right data. This, of course, requires you to know what "the right data" is. We know there are valuable insights in data, so why not store the lot? It's the 21st century equivalent of "there's gold in them thar hills!"

So having spent years stashing away terabytes of your data in PostgreSQL, you want to start learning from that data. Queries. More queries. More complex queries. Lots of real-time queries. Lots of concurrent users. It might be tempting at this point to give up on PostgreSQL and stash your data into a different solution, more suited to purpose. Don't. PostgreSQL can perform very well in HTAP environments and performs even better with a little help.

In this presentation we dive into the current state of the art with regards to PostgreSQL in HTAP environments and expose how hardware acceleration can help squeeze as much knowledge as possible out of your data.

Speakers

Paul Adams

VP of Engineering, Swarm64

Paul Adams has over 15 years experience building and supporting teams, with focus on distributed engineering, especially Open Source. He works with the engineering teams at Swarm64 to help them learn and be better every day and to ensure that structure and process serve the needs... Read More →

Sebastian Dressler

Lead Solution Engineering (EMEA), Swarm64

Sebastian Dressler has a wealth of experience in connecting hardware with software building creative solutions. He leads the European solution engineering team at Swarm64, helping our customers fully understand how our technology can fit into their environments. Sebastian holds an... Read More →

Wednesday June 26, 2019 3:05pm - 3:55pm EDT
Back Bay B The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Tech and Tools Track

3:05pm EDT

The Future of zHeap

Data bloat, what is it and how it can impact the large Enterprises? The databases are prone to generate additional data for certain operations, but the important thing is how efficiently it manages to remove it or avoid growing it over a period of time.

PostgreSQL also offers ways to contain and remove bloat, but many-a-time those are so costly or requires high maintenance that they don't help.

zHeap is a solution in making that will avoid generating bloat in PostgreSQL. In this talk, I will explain how this new solution can help in solving the problems related to bloat.

Bloat is the main problem which zHeap tries to address, but that is not all, it will also have a smaller disk footprint and will reduce the disk writes.

This talk will also cover what is already done and what is the future plan to make this solution a reality in PostgreSQL.

Speakers

Amit Kapila

Senior Database Architect, EnterpriseDB, PostgreSQL committer and major contributor

At EDB, Amit emphasizes database internals and workload management in EDB Postgres™ Advanced Server and is a technical team leader. A 15-year database veteran, Amit has developed deep expertise in PostgreSQL, Oracle®, and in-house in-memory databases. Amit participates actively... Read More →

Wednesday June 26, 2019 3:05pm - 3:55pm EDT
Back Bay C The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Vision Track

3:05pm EDT

Zero-to-Hero: Running Postgres in Kubernetes

Join Taylor Graham and get all the tips and best practices you need to go from zero-to-hero. He'll show you everything you need to know about to running Postgres in Kubernetes! Don't miss this informative jump start!

Speakers

Taylor Graham

Field CTO, EnterpriseDB

Wednesday June 26, 2019 3:05pm - 3:55pm EDT
Back Bay A The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199

Breakout Session, Vision Track