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
Indexes: right place, right time. by Jonathan Salama
Upgrading Postgres 9.3 with zero downtime by Cory Stephenson
Building scalable application with Google Cloud SQL for PostgreSQL by Eric Sheetz
Face recognition and postgres by Jacques Combrink
Join Heterogeneous Databases using PostgreSQL Foreign Data Wrappers by Ibrar Ahmed
Running your datacenter with PostgreSQL by Tony Perez
Building a SaaS developer platform using Postgres by Abhijit Paithankar
Compressing multidimensional data in PostgreSQL by Karl Pietrzak
Building a code-security service using time-series data in Postgres by Preetam Jinka
When to use JSONB and When not to use JSONB in postgres by Anson Abraham
Logical Replication and pgLogical by Tom Kincaid
Building a scalable realtime GraphQL API (GraphQL subcriptions) on Postgres by Tanmai Gopal
The wonders of CTE's by Hein Kruger
PostgreSQL Practices in China by Grant Zhou
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
400% performance improvement after tuning these PostgreSQL parameters by Avinash Vallarapu
Row Level Security by Bennie Swart
Data
Shadow Tables vers PGAudit by Lloyd Albin
Azure Database for PostgreSQL – what’s new and lesson learned. by Sunil Kamath
Simple steps to superior database performance by Hans-Jürgen Schönig
Integrating Postgres with Apache Camel and ActiveMQ by Justin Reock
Scaling AWS Redshift Concurrency With PostgreSQL by Will Liu
Loading data into PostgreSQL by Regina Obe
Writing Recursive Queries by Ben Lis
"Right size" your PostGIS data by Ryan Lambert
Bringing DevOps to Data Science: Operationalize AI Leveraging Postgres by Sridhar Paladugu
Gap Filling: Enabling New Analytic Capabilities in Postgres by Matvey Arye
Driving Data Science at Scale Using Postgres and Greenplum with Dataiku by Nicolas Gakrelidz
Agile Data Science on Greenplum [using Airflow] by Aditya Padhye
Learn how Dell Computer Improved Postgres/Greenplum Performance 20x with a Database Proxy by Erik Brandsberg
Migrating from Oracle to Enterprise-Ready Postgres in the Cloud by Prashant Agarwal
Streaming ETL in Practice with PostgreSQL, Apache Kafka, and KSQL by Viktor Gamov
Mitigating Your Database Migration Challenges by Jeffrey Surretsky
Introducing PostgreSQL in Azure Data Studio by Dr. Rony Chatterjee
TIBCO Data Science by Venkata Jagannath
Ops and Administration
Automated health checks of PostgreSQL clusters by Nikolay Samokhvalov
Transactions per Dollar - PostgreSQL in virtual and bare metal clouds by Oskari Saarenmaa
Next Generation Storage Technology Considerations for PostgreSQL by Andrew Ruffin
Performance tuning PostgreSQL by Malcolm McLean
Monitoring PostgreSQL with Grafana and TimescaleDB by Peter Celentano
Fully Automating the Entire PostgreSQL Lifecycle by Julian Fischer
Essential Postgres Performance tuning by Payal Singh
Using Grafana and Prometheus for PostgreSQL monitoring in TomTom by Michał Gutkowski
An Introductory Training on TimescaleDB by Diana Hsieh
All the dirt on VACUUM by Jim Nasby
HOT - UNDERSTANDING THIS IMPORTANT UPDATE OPTIMIZATION by Grant McAlister
Whats slowing down my database a Dev-Ops approach by Bernhardt Garlipp
The PostgreSQL Ecology by Andrew Dunstan
Query Optimization for Excel People by Mara Lemagie
Logical Replication… Let’s do it LIVE! by Robert Treat
Essential PostgreSQL11 Database Administration by Simon Riggs
Understanding and implementing PostgreSQL High Availability with Patroni by Alexey Klyukin
Postgres for the Financial Industry by Simon Riggs
Deploying & Managing PostgreSQL on Public Clouds: 10 Questions to Ask (& Answer) Before You Go Live by dharshan rangegowda
Wait! What's going on inside my database? Understanding PostgreSQL wait events by Jeremy Schneider
Dollars for Disks: Hard lessons behind performant Postgres I/O in the Cloud by Jeffrey Zampieron
Oracle to PostgreSQL Migration Tutorial by Alvaro Hernandez
Setting up PostgreSQL for Production in AWS by Scott Mead
PostgreSQL backups in the age of The Cloud by Hannu Valtonen
Visualizing Data in PostgreSQL Using Grafana by Preetam Jinka
Replication in PostgreSQL - Deep Dive by Abbas Butt
Introduction to PostgreSQL for Oracle and MySQL DBAs by Avinash Vallarapu
Divide and Conquer data:- Advanced Methods for partitioning and sharding data - Latest developments by Jobin Augustine
Development
High-performance Coding: a Rust-based tree hash for large files by Jack O'Connor
Stored Procedures by Andrew Dunstan
Performant multi-region Postgres using distributed data storage engine by Karthik Ranganathan
You Got Kubernetes In My Postgres! by Liz Frost
"Why isn't my query using an index?" - Tips on SQL performance to keep on your finger tips! by Denish Patel
Beginner's Guide to PostgreSQL Development by Jim Mlodgenski
Integrating Postgres Into DevOps by Jeffrey Surretsky
Ace it with ACID by Alexey Klyukin
Using FDW Like Never Before by Henrietta Dombrovskaya
TimescaleDB: Leveraging PostgreSQL for Reliability by Mike Freedman
Securing PostgreSQL as a Service in a multi-cloud platform by Dinesh Kumar
Multi-Tenant PostgreSQL-as-a-Service in SAP Cloud Platform by Dinesh Kumar
Connecting Galaxies by Alyssa Ritchie
PostgreSQL EXPLAIN Explained by Baron Schwartz
In-Database Application Server by Sergey Shestakov
Getting stuff done with PostGIS by Leo Hsu
FoundationDB: Building a next-generation distributed database storage engine by Ben Collins
Greenplum Summit
Building Models Quickly by Ian Pytlarz
Distributing big astronomical catalogues with Greenplum by Pilar de Teodoro
Greenplum and the Power of The Cloud - The Marketplace Offerings across AWS, Azure, and GCP by Jon Roberts
How Baker Hughes, a GE Company, Migrated Its Data Lake to AWS and Greenplum by Jayaraman Thiagarajan
Achieve Extreme Simplicity and Superior Price/Performance with Greenplum Building Blocks by Derek Comingore
Greenplum Expert Panel: Greenplum Operations at Scale by Gregory Chase
The Present and Future of Greenplum, a Massively Parallel Postgres Database by Ivan Novick
Bringing Cloud Databases On-Premises with Greenplum and Kubernetes by Oz Basarir
Petabyte Scale Data Warehousing with Open Source Greenplum Database by Marshall Presser
AI on Greenplum Using Apache MADlib and MADlib Flow by Frank McQuillan
Maximize Greenplum For Any Use Cases: Decoupling Compute and Storage by Shivram Mani
Pivotal Greenplum: Postgres-Based. Multi-Cloud. Built for Analytics & AI by Keaton Adams
A Modern Interface for Data Science on Postgres and Greenplum by Scott Hajek
Greenplum and Kafka: Real time Streaming to Greenplum by Sharath Punreddy
Regulated Industry
Designing database schemas for GDPR-compliance and security by Karthik Ranganathan
Case Study: Secure and high performant data lake by Pratik Verma
PostgreSQL Security Best Practices by Dennis Tighe
Achieving Business Results under Stress/Strain of Government Regulation by Bryan Doyle
AWS Migration Day
Moving Your Enterprise from Commercial Databases to PostgreSQL by David Rader
Ask Me Anything about PostgreSQL on AWS by Kevin Jernigan
Managed PostgreSQL Databases on AWS by Kevin Jernigan
How Amazon.com Migrated their Inventory Management System from Oracle to Aurora PostgreSQL by Brent Bigonger
Deep Dive on Amazon Aurora PostgreSQL Performance Tuning by James Finnerty
Deep Dive on Amazon Aurora with PostgreSQL Compatibility by Jim Mlodgenski
Tools to help you Migrate from Oracle to PostgreSQL by Craig Silveira
Google Cloud Summit
Introduction to Google Cloud Platform Storage and Cloud SQL by Eric Sheetz
Oracle to PostgreSQL Migration by David Yahalom
High Availability with Cloud SQL + Kubernetes by Kurtis Van Gent
Introduction to Cloud Spanner by Gabi Ferrara
Introduction to Cloud Firestore by Ben Whitehead
Fireside Chat with a Google Cloud SQL Engineer by Shuang Liang
Introduction to Cloud Bigtable by Billy Jacobson
PostgreSQL in Production by Steve Hetzel
General Session
Diversity and Inclusiveness Panel by PostgresConf Organizers
New York, New York
Sheraton New York Times Square 811 7th Avenue 53rd Street
New York, New York 10019
United States