
Postgres Conference
Don't miss the premiere Professional Postgres conference as it returns to Manhattan! The 8th annual PostgresConf is the largest and the most diverse class of Postgres professionals and companies in the world. The Postgres Conference conveys the preeminent “People, Postgres and Data” experience.
Three things that set this event apart
Some of our speakers
Conference Highlights
High Availability with Cloud SQL + Kubernetes
Hands on demonstration building and deploying a highly available, fault tolerant web application. In this tutorial, we will demonstrate how to set up a connection from an python application running in Google Kubernetes Engine to a Cloud SQL instance, using private IP or the Cloud SQL Proxy Docker image.
Loading data into PostgreSQL
PostgreSQL is one of the easiest databases to get data into and out of. In addition there are tons of free useful data sources to munch on. We'll cover various ways of loading various kinds of data into PostgreSQL. Data formats will include other postgres data, delimited, fixed width, spreadsheets, other relational databases, and other formats (including spatial formats) you may come across, and even Web services. We'll demonstrate loading data using SQL, psql \copy,...
Connecting Galaxies
Everything shall pass except Object-Relational Impedance Mismatch. Despite many years of research and development in this area, applications and databases still struggle with communication issues. An incompatibility of data models between object-oriented application code and a database engine causes multiple performance problems and triggers over-complicated application design. In this talk, we describe a solution for high-level information exchange between PostgreSQL database and Java...
You Got Kubernetes In My Postgres!
My day job is as a Kubernetes project contributor, and Postgres Foreign Data Wrappers have always held a special place in my heart. Combining them is only natural. Kubernetes uses etcd as its data store, but it maps very well onto Postgres. All APIs follow a very uniform schema that makes programmatically mapping objects to tables easy. The user experience I settled on makes it easy to present exactly the data you want, not the entire object. Unlike most postgres extensions, the...
Logical Replication… Let’s do it LIVE!
Postgres 10 added a new form of replication; logical replication; into the wide array of replication and failover options available within the Postgres ecosphere. In this talk, we'll cover: • a (very) brief history of replication in Postgres • what is logical replication? • differences between Postgres 10 and 11 • how does it differ from other replication options? • good use cases for logical replication • not good use cases Once we cover the basics, we'll then walk through a...
Program
2019 has the most awesome program ever! See rock-star speakers cover the topics of
Use Cases
Row Level Security by Bennie Swart
400% performance improvement after tuning these PostgreSQL parameters by Avinash Vallarapu
What is the optimal value of shared_buffers for your database? A use case of data-driven optimization based on database experiments by Nikolay Samokhvalov
Logical Replication and pgLogical by Tom Kincaid
When to use JSONB and When not to use JSONB in postgres by Anson Abraham
Building a code-security service using time-series data in Postgres by Preetam Jinka
Building scalable application with Google Cloud SQL for PostgreSQL by Eric Sheetz
PostgreSQL Practices in China by Grant Zhou
The wonders of CTE's by Hein Kruger
Building a scalable realtime GraphQL API (GraphQL subcriptions) on Postgres by Tanmai Gopal
Compressing multidimensional data in PostgreSQL by Karl Pietrzak
Building a SaaS developer platform using Postgres by Abhijit Paithankar
Running your datacenter with PostgreSQL by Tony Perez
Join Heterogeneous Databases using PostgreSQL Foreign Data Wrappers by Dr. Ibrar Ahmed
Face recognition and postgres by Jacques Combrink
Upgrading Postgres 9.3 with zero downtime by Cory Stephenson
Indexes: right place, right time. by Jonathan Salama
Data
TIBCO Data Science by Venkata Jagannath
Introducing PostgreSQL in Azure Data Studio by Dr. Rony Chatterjee
Mitigating Your Database Migration Challenges by Jeffrey Surretsky
Streaming ETL in Practice with PostgreSQL, Apache Kafka, and KSQL by Viktor Gamov
Learn how Dell Computer Improved Postgres/Greenplum Performance 20x with a Database Proxy by Erik Brandsberg
Agile Data Science on Greenplum [using Airflow] by Aditya Padhye
Gap Filling: Enabling New Analytic Capabilities in Postgres by Matvey Arye
Migrating from Oracle to Enterprise-Ready Postgres in the Cloud by Prashant Agarwal
Bringing DevOps to Data Science: Operationalize AI Leveraging Postgres by Sridhar Paladugu
"Right size" your PostGIS data by Ryan Lambert
Writing Recursive Queries by Ben Lis
Loading data into PostgreSQL by Regina Obe
Scaling AWS Redshift Concurrency With PostgreSQL by Will Liu
Integrating Postgres with Apache Camel and ActiveMQ by Justin Reock
Simple steps to superior database performance by Hans-Jürgen Schönig
Azure Database for PostgreSQL – what’s new and lesson learned. by Sunil Kamath
Shadow Tables vers PGAudit by Lloyd Albin
Driving Data Science at Scale Using Postgres and Greenplum with Dataiku by Nicolas Gakrelidz
Ops and Administration
Divide and Conquer data:- Advanced Methods for partitioning and sharding data - Latest developments by Jobin Augustine
PostgreSQL backups in the age of The Cloud by Hannu Valtonen
Dollars for Disks: Hard lessons behind performant Postgres I/O in the Cloud by Jeffrey Zampieron
Wait! What's going on inside my database? Understanding PostgreSQL wait events by Jeremy Schneider
Deploying & Managing PostgreSQL on Public Clouds: 10 Questions to Ask (& Answer) Before You Go Live by dharshan rangegowda
Logical Replication… Let’s do it LIVE! by Robert Treat
The PostgreSQL Ecology by Andrew Dunstan
Whats slowing down my database a Dev-Ops approach by Bernhardt Garlipp
HOT - UNDERSTANDING THIS IMPORTANT UPDATE OPTIMIZATION by Grant McAlister
All the dirt on VACUUM by Jim Nasby
Using Grafana and Prometheus for PostgreSQL monitoring in TomTom by Michał Gutkowski
Essential Postgres Performance tuning by Payal Singh
Fully Automating the Entire PostgreSQL Lifecycle by Julian Fischer
Monitoring PostgreSQL with Grafana and TimescaleDB by Peter Celentano
Next Generation Storage Technology Considerations for PostgreSQL by Andrew Ruffin
Transactions per Dollar - PostgreSQL in virtual and bare metal clouds by Oskari Saarenmaa
Automated health checks of PostgreSQL clusters by Nikolay Samokhvalov
Visualizing Data in PostgreSQL Using Grafana by Preetam Jinka
Query Optimization for Excel People by Mara Lemagie
Replication in PostgreSQL - Deep Dive by Abbas Butt
Setting up PostgreSQL for Production in AWS by Scott Mead
Postgres for the Financial Industry by Simon Riggs
Understanding and implementing PostgreSQL High Availability with Patroni by Alexey Klyukin
Essential PostgreSQL11 Database Administration by Simon Riggs
An Introductory Training on TimescaleDB by Diana Hsieh
Introduction to PostgreSQL for Oracle and MySQL DBAs by Avinash Vallarapu
Oracle to PostgreSQL Migration Tutorial by Alvaro Hernandez
Performance tuning PostgreSQL by Malcolm McLean
Development
FoundationDB: Building a next-generation distributed database storage engine by Ben Collins
Getting stuff done with PostGIS by Leo Hsu
PostgreSQL EXPLAIN Explained by Baron Schwartz
Connecting Galaxies by Alyssa Ritchie
Multi-Tenant PostgreSQL-as-a-Service in SAP Cloud Platform by Dinesh Kumar
Securing PostgreSQL as a Service in a multi-cloud platform by Dinesh Kumar
TimescaleDB: Leveraging PostgreSQL for Reliability by Mike Freedman
Ace it with ACID by Alexey Klyukin
Integrating Postgres Into DevOps by Jeffrey Surretsky
"Why isn't my query using an index?" - Tips on SQL performance to keep on your finger tips! by Denish Patel
Performant multi-region Postgres using distributed data storage engine by Karthik Ranganathan
High-performance Coding: a Rust-based tree hash for large files by Jack O'Connor
In-Database Application Server by Sergey Shestakov
Using FDW Like Never Before by Henrietta Dombrovskaya
You Got Kubernetes In My Postgres! by Liz Frost
Stored Procedures by Andrew Dunstan
Beginner's Guide to PostgreSQL Development by Jim Mlodgenski
Greenplum Summit
AI on Greenplum Using Apache MADlib and MADlib Flow by Frank McQuillan
Greenplum Expert Panel: Greenplum Operations at Scale by Gregory Chase
Greenplum and Kafka: Real time Streaming to Greenplum by Sharath Punreddy
A Modern Interface for Data Science on Postgres and Greenplum by Scott Hajek
Pivotal Greenplum: Postgres-Based. Multi-Cloud. Built for Analytics & AI by Keaton Adams
Maximize Greenplum For Any Use Cases: Decoupling Compute and Storage by Shivram Mani
Bringing Cloud Databases On-Premises with Greenplum and Kubernetes by Oz Basarir
The Present and Future of Greenplum, a Massively Parallel Postgres Database by Ivan Novick
Achieve Extreme Simplicity and Superior Price/Performance with Greenplum Building Blocks by Derek Comingore
How Baker Hughes, a GE Company, Migrated Its Data Lake to AWS and Greenplum by Jayaraman Thiagarajan
Greenplum and the Power of The Cloud - The Marketplace Offerings across AWS, Azure, and GCP by Jon Roberts
Distributing big astronomical catalogues with Greenplum by Pilar de Teodoro
Building Models Quickly by Ian Pytlarz
Petabyte Scale Data Warehousing with Open Source Greenplum Database by Marshall Presser
Regulated Industry
Achieving Business Results under Stress/Strain of Government Regulation by Bryan Doyle
Case Study: Secure and high performant data lake by Pratik Verma
Designing database schemas for GDPR-compliance and security by Karthik Ranganathan
PostgreSQL Security Best Practices by Dennis Tighe
AWS Migration Day
Tools to help you Migrate from Oracle to PostgreSQL by Craig Silveira
Deep Dive on Amazon Aurora PostgreSQL Performance Tuning by James Finnerty
How Amazon.com Migrated their Inventory Management System from Oracle to Aurora PostgreSQL by Brent Bigonger
Managed PostgreSQL Databases on AWS by Kevin Jernigan
Ask Me Anything about PostgreSQL on AWS by Kevin Jernigan
Deep Dive on Amazon Aurora with PostgreSQL Compatibility by Jim Mlodgenski
Moving Your Enterprise from Commercial Databases to PostgreSQL by David Rader
Google Cloud Summit
PostgreSQL in Production by Steve Hetzel
Oracle to PostgreSQL Migration by David Yahalom
Introduction to Google Cloud Platform Storage and Cloud SQL by Eric Sheetz
Introduction to Cloud Bigtable by Billy Jacobson
Fireside Chat with a Google Cloud SQL Engineer by Shuang Liang
Introduction to Cloud Firestore by Ben Whitehead
Introduction to Cloud Spanner by Gabi Ferrara
High Availability with Cloud SQL + Kubernetes by Kurtis Van Gent
General Session
Diversity and Inclusiveness Panel by PostgresConf Organizers

Sheraton New York Times Square
The conference will take place at the Sheraton New York Times Square, just steps from Central Park, Times Square, and world-class entertainment destinations. Make the most of your limited time to network and learn by staying at the official conference hotel.
Reserve your room today. Be sure to book prior to March 4, 2019 - the conference rate is not guaranteed after this date.
New York, New York
Sheraton New York Times Square 811 7th Avenue 53rd Street
New York, New York 10019
United States