Postgresql logo

Postgres Conference 2020

Postgres Conference 2020 is the largest gathering about People, Postgres, Data! A professional, inclusive and diverse global event with a truly international community, we bring together a best-in-talent combination of speakers, attendees, and sponsors to build opportunities for the global Postgres ecosystem.

Convince Your Boss!

Sponsors

Diamond

Platinum

Gold

Silver

Community Partners

The registration period ends in

Register Now

Some of our speakers

Ecaa579ddbd27537b4ac50a26f1814a9

Bruce Momjian

EnterpriseDB
Senior Database Architect
Dscf5192

Oleg Bartunov

Postgres Professional
CEO
Aht twitter img

Alvaro Hernandez

OnGres
Founder
Leohead

Leo Hsu

Paragon Corporation
Vice President
Reginahead

Regina Obe

Paragon Corporation
President
B3e314bbf4bec1eeca20175ca8018a56

Avinash Vallarapu

Percona
PostgreSQL Tech Lead
0 2

Mara Lemagie

Bazean
Lead Data Engineer
Img 1954  1

Henrietta Dombrovskaya

Braviant Holdings
Associate Director of DB
Rkp 191205 0339 websq

Leanne Baldwin

Bazean
Data Engineer
Sangwook kim

Sangwook Kim

Apposha
CEO
C985cee81783fe248403fb8bbd64ce01

Byeonghun Hyeon

Apposha
CTO
2079b104be2b2145d855bb076453d8da

Filip Rembiałkowski

Command Prompt, Inc.
DBA
F1e0e0c3c3196a63c9b17a2344fb6a61

Mike Fowler

Claranet
Principal Data Engineer
A1f5b18aa0583df8ef30cb8198f2ccff

Celia Zhang

Google
Software Engineer
D6c3309c8b23331ba3384715d7715ffa

Ekaterina Dontsova

Pivotal
Software Engineer
Profile p

Rafia Sabih

Zalando SE
Software Engineer
Headshot

Rebecca Bilbro

Scikit-Yellowbrick
Chief Data Scientist
4bdcb3fd015704fb178c3ce90f97c5d3

Janet Whiteman

Google
Engineer

Conference Highlights

Mar 27 PostgreSQL performance from the ground up

Are you facing performance problems? Well, if you do this is the perfect training class for you. You will be guided through PostgreSQL performance from the ground up and learn how to optimize your PostgreSQL database to achieve maximum performance under all circumstances. We will also point you to the most common bottlenecks and provide easy solutions to those problems.

Mar 27 postgresql.conf A-Z

We will take a full day trip to explore the postgresql.conf and explain all the interesting machinery behind those knobs - especially the additions in version 12.

Mar 26 Introduction to PostgreSQL and Kubernetes

Discover the new way of thinking about applications, IT processes, and systems in general using Kubernetes – the open source container orchestration platform. Join Simon Riggs, CEO of 2ndQuadrant, to receive an introduction to the platform for automating deployment, scaling, and operations of application containers across clusters of hosts. Starting with basics on Docker, the training course walks through the main concepts of using Kubernetes to deploy stateless applications on PostgreSQL...

Mar 25 Alternative data where it’s needed the most. Use case: Satellite Imagery - North Africa.

Economic development research heavily relies on limited, expensive and sometimes “doubtful” survey data. Using free and readily available satellite imagery to empower economic development research is one solution to the problem. This talk will highlight some of those benefits and walk through a step-by-step technical example using open source tools. *source: NOAA.gov national oceanic and atmospheric administration Economists around the world often rely on limited survey data to...

Mar 26 Getting Stuff done with PostGIS and pgRouting

This training will teach you how to use PostGIS related extensions to answer questions about WHERE and HOW TO GET THERE with data. The main focus will be on the postgis and pgrouting extensions as well as tools for loading spatial data. We will also cover techniques for getting the most performance out of your spatial and routing queries. Though most queries will also work on lower versions, we will be using PostgreSQL 12, PostGIS 3 , and pgRouting 3. We will highlight functions/spatial...

Mar 24 Postgres Talent Exchange

Career fair, Talent exchange, Speed Mentoring etc...

Mar 24 PostgreSQL 13: The encrypted data platform for Regulated Industry

Join PostgreSQL Core Member and Committer, Bruce Momjian in exploring the current community efforts to bring a new standard of data privacy to PostgreSQL users. In this presentation we will talk about the status of current efforts, the expectations for the upcoming release of PostgreSQL 13 and future plans. We will also touch briefly on current security trends and where PostgreSQL needs to expand its efforts or where PostgreSQL already leads the industry.

Mar 23 Running PostgreSQL on AWS

Join Scott Mead from AWS on a journey of best practices when running PostgreSQL on AWS

Mar 23 Aurora PostgreSQL workshop

Join Scott Mead/Sameer Malik/Kathy Gibbs in a hands on workshop with best practices for Aurora PostgreSQL

Mar 27 The Ultimate Postgres Optimization: Going Beyond Docs and Textbooks

Abstract: Is it possible to teach somebody to optimize? Or is optimization a sort of magic, available only for the limited circle of wizards? We believe that it is entirely possible to become an optimization wizard, and we are going to prove it in the course of this training. We will provide the participants with the opportunity to look at the process of query writing “as a database engine”, and will teach them “how to think, as a database engine”. The topics which will be covered...

Mar 23 Aurora Deep Dive

Join Grant McAlister in a deep dive on how Amazon Aurora for PostgreSQL works!

Mar 25 Will partitioning and sharding improve performance?

What is the best solution to join 2 very big tables (>1TB) with billion rows and hundreds of columns with the help of distribution and partitioning? We have analysed different distribution and partition methods to achieve the best performance for a crossmatch, that is, identifying different rows from 2 tables (star catalogues) referring to the same star. Crossmatching helps scientists around the world to understand better our universe identifying objects observed by different space missions.

Mar 27 Working with spatial data in PostGIS

Kartoza is a South African company with a global footprint. We specialise in geospatial solutions with FOSS, which means we use PostGIS a lot. We also present courses on PostGIS. This workshop is a condensed version of what we normally do in two or three days. You will get hands-on experience with loading spatial data, understanding geometries and using spatial data in analysis. In the process you will learn all about spatial SQL and also how to use a desktop GIS (QGIS) to interact with the...

Mar 26 Exploring Common Table Expressions and Window Functions

Developers are often challenged to deliver results that are hard to implement using simple SQL queries. Fortunately, complex SQL capabilities exist in the SQL standard --- common table expressions and window functions. SQL is a declarative language, meaning the user submits an SQL command and the database determines the optimal execution. Common Table Expressions (CTEs) allow queries to be more imperative, allowing looping and processing hierarchical structures that are normally...

Mar 26 Differentially Private SQL

Differential privacy (DP) provides formal guarantees that the output of a database query does not reveal too much information about any individual present in the database. While many differentially private algorithms have been proposed in the scientific literature, there are only a few end-to-end implementations of differentially private query engines. Crucially, existing systems assume that each individual is associated with at most one database record, which is unrealistic in...

Mar 24 Differentially Private SQL

Differential privacy (DP) provides formal guarantees that the output of a database query does not reveal too much information about any individual present in the database. While many differentially private algorithms have been proposed in the scientific literature, there are only a few end-to-end implementations of differentially private query engines. Crucially, existing systems assume that each individual is associated with at most one database record, which is unrealistic in...

Mar 24 Running postgres on kubernetes

Learn the ins and outs of running highly available Postrges on kubernetes for production. We will use Amazon EKS for orchestrating our kubernetes cluster.

Mar 24 Being An Effective Tech Leader

As technology grows and evolves, it’s critical to have the best tech staff, yet not every business founder, project manager, or sales director has a tech background. How do you manage a team of developers, products and services when you don’t have tech experience? We'll explore this as well as - How do you bridge the knowledge gap between your technical team and your non-technical founders, project and product managers, and sales and marketing staff? - - How can you communicate...

Mar 27 Always-On with Postgres BDR (Deploying with Multi-Master)

This course will present the Postgres-BDR Always-On architecture. It will do an in depth review of logical replication and high availability concepts. How to achieve maximum availability through a Postgres Multi-Master architecture will presented. Specific topics that will be covered: 1) How to achieve zero down time upgrades. 2) How to quickly (under a second) failover. 3) How to failover between data data centers. 4) How to have a zero impact on your deployment as a result of...

Program

2020 has the most awesome program ever!
See rock-star speakers cover the topics of

Ops and Administration

PostgreSQL performance from the ground up by Hans-Jürgen Schönig

postgresql.conf A-Z by Filip Rembiałkowski

Introduction to PostgreSQL and Kubernetes by Simon Riggs

High Availability and Automatic Failover in PostgreSQL. by Avinash Vallarapu

Prometheus & PostgreSQL: How and why to use PostgreSQL as long-term storage for metrics by Avthar Sewrathan

Make Your PostgreSQL 10x Faster on Cloud in Minutes by Sangwook Kim

pgagroal by Jesper Pedersen

PostgreSQL Extensions: A Deeper Look by Jignesh Shah

PostgreSQL Replication by Asif Rehman

Authentication & Authorization with Multi-User Connection Pooling for Large-scale Postgres Deployments by Erik Brandsberg

Data Security in PostgreSQL - Deep Dive by Abbas Butt

PostgreSQL TDE: Fully encrypted PostgreSQL by Hans-Jürgen Schönig

Logical Replication lessons learned for the Data Warehouse by Pat Wright

Upgrading a PostgreSQL database from a legacy to newer version with no downtime. by Avinash Vallarapu

Running postgres on kubernetes by manish muttreja

Bring Compression to Postgres at Zero Cost of Performance by Tong Zhang

Performance Impact of Idle PostgreSQL Connections by Yaser Raja

A detailed understanding of MVCC and Autovacuum Internals in PostgreSQL. by Avinash Vallarapu

Mostly mistaken and ignored PostgreSQL parameters while optimizing a PostgreSQL database by Avinash Vallarapu

Monitoring & Diagnostics of PostgreSQL by Mahadevan Ramachandran

Scalable Replication For Postgres by Marc Linster

Backup PostgreSQL with Barman by Andrew Dunstan

Scheduled PostgreSQL jobs with AWS Batch by Peter Celentano

Improve Write-Master and Read Replica scale, safely without application changes by Roland Lee

Improve Postgres Transaction/Second with a Database Proxy, no code changes required by Erik Brandsberg

Zero to Hero: Managing Postgres through DevOps by Ajay Patel

Postgres for the SQL Server DBA by Pat Wright

Use Docker, Go, Rest and some more to build a PostgreSQL multi cloud self service by Heiko Onnebrink

MVCC and Tuple Freezing through Pictures. by Tom Kincaid

Always-On with Postgres BDR (Deploying with Multi-Master) by Tom Kincaid

PostgreSQL HA with Pgpool-II and whats been happening in Pgpool-II lately.... by Muhammad Usama

Wait! What's going on inside my database? Understanding PostgreSQL wait events by Jeremy Schneider

Backups, Upgrades, and Inventing a New Way to Move Data Faster by Jeremy Schneider

DevOps On ACID by Robert Treat

Upgrade Techniques Through the Ages by Shaun Thomas

Working with JSON Data in PostgreSQL vs. MongoDB by dharshan rangegowda

StackGres: Cloud-Native PostgreSQL on Kubernetes by Alvaro Hernandez

Turning PostgreSQL into a Cloud Native Data Service by Julian Fischer

How to access your cloud PostgreSQL servers from highly secured corporate environment. by Tatiana Krupenya

The future of Postgres in a multi-cloud world by Marc Linster

From SQL Server DBA to Postgres DBA by Victoria McCormick

Monitor Postgres for performance by Ajay Patel

Tune your Linux Box, not just PostgreSQL by Ibrar Ahmed

Active Session History In PostgreSQL: Why?, How? and use cases by Bertrand Drouvot

Interesting 25 new features in PostgreSQL 12 by Jobin Augustine

Development

OLTP Workload Acceleration with Memory Optimized Tables on PostgreSQL by Liran Mishali

The Ultimate Postgres Optimization: Going Beyond Docs and Textbooks by Henrietta Dombrovskaya

Life without ORM: is it possible and how we can get there by Henrietta Dombrovskaya

Exploring Common Table Expressions and Window Functions by Bruce Momjian

Debugging with PostgreSQL by John Ashmead

Workshop to use Postgres and ArcGIS for beginners by Chaula Jain

B-tree indexes - learn more about the heart of PostgreSQL by Anastasia Lubennikova

Building the Holodeck by Justin Reock

Open Source Applied by Justin Reock

Tired of Impedence Mismatch? Meet Quill! by Alexander Ioffe

A Deep Dive into PostgreSQL Indexing by Ibrar Ahmed

Scaling AWS Redshift Concurrency With PostgreSQL by Will Liu

Differentially Private SQL by Celia Zhang

Building JSON from Relational Data by Jeremy Smith

The Art of Logical Replication by Kuntal Ghosh

Using benchmarks and profiles to optimize CockroachDB's execution engine by Rafi Shamim

Blockchain as a Database by Abdullah Uz Tansel

The anatomy of FTS engine in PostgreSQL. by Oleg Bartunov

Enterprise DDL Management by Gavin M. Roy

Customizing PostgreSQL via extensions by Rafia Sabih

Deeper Understanding of PostgreSQL Execution Plan : At plan time and run time by Jobin Augustine

Run Postgres Natively on Kubernetes by Marc Linster

Was Just About Time for JIT in PostgreSQL in v11 by Hamid Akhtar

MobilityDB: Managing Spatiotemporal Data in PostgreSQL by Mahmoud SAKR

Advanced compression in TimescaleDB with hybrid row/columnar storage by Michael Freedman

Machine Learning

Outside the Black Box by Rebecca Bilbro

Marriott Marquis

Marriott Marquis

There is no city quite like New York City, and no hotel quite like New York Marriott Marquis. Set in the heart of Times Square on West 46th Street and Broadway, our iconic Manhattan hotel lets you experience all the magic of NYC from the moment you arrive. Inside our towering hotel, you'll find some of New York City's largest hotel rooms and suites and multiple restaurants, including the only revolving restaurant in the city and a popular outdoor lounge. Whether visiting for a family vacation, a Broadway show weekend or attending a conference, New York Marriott Marquis is truly the perfect hotel for your stay in New York City.

RESERVE YOUR ROOM TODAY

A dedicated booking website has been created for our event so our attendees can make and modify your hotel reservations online, as well as take advantage of any room upgrades, amenities or other services offered by the hotel.

Please reserve your room via this link.

New York, New York


Marriott Marquis
1535 Broadway
New York, New York 10036
United States