Postgresql logo

PGConf US 2017 [PgConf.US]

Join the growing PostgreSQL Community!

March 28th - 31st, 2017 at the Westin Jersey City

PGConf US is a non-profit conference hosted run by the United States PostgreSQL Association. This conference is part of the effort to grow the PostgreSQL community by increasing awareness and providing the appropriate training and resources to further PostgreSQL adoption.







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


Postgres Performance for Application Developers by Lukas Fittl

LXD, the Container Hypervisor by Anthony Davis

PostgreSQL worst practices by Ilya Kosmodemiansky

DataGrip, SQL client from JetBrains by Vasiliy Chernov

From Dev to prod, The ABC's of PostgreSQL backups by Scott Mead

POWER Platform - The New Home For PostgreSQL by Michael Meskes

Advanced Postgres Monitoring by Denish Patel

Intro to PostgreSQL by Joe Conway

PostgreSQL High Availability in a Containerized World by Jignesh Shah

Enterprise Data Architecture with PostgreSQL by Kevin Kempter

Patroni - HA PostgreSQL made easy by Alexander Kukushkin

DevOps Tools for managing PostgreSQL by Kunal Jain

Columns and Clouds - Hybrid databases by David Rader

High-Availability Postgres with etcd by Tess Rinearson

Restrictions on PostgreSQL Cloud DBaaS by Simon Riggs

Amazon RDS for PostgreSQL: What’s New and Lessons Learned by Grant McAlister

Managing OS Provided PostgreSQL Packages by Keith Fiske

Provisioning and Automating High Availability Postgres on AWS EC2 by Payal Singh

Automating Production-Ready Databases in Docker by Jesse White

Data Rescue by Debra Cerda


An Introduction to SQLAlchemy and Friends by Jon Banafato

Django and PostgreSQL: Two Great Tastes by Christophe Pettus

TimescaleDB: Designing a scalable time-series database on PostgreSQL by Mike Freedman

Designing your SaaS Database for Scale with Postgres by Ozgun Erdogan

Gophers Riding Elephants: Writing PostgreSQL tools in Go by AJ Bahnken

Exploiting the hidden talents of JDBC for maximum performance by Dave Cramer

Schema management with Flyway by Scott Mead


Time in Databases by Abdullah Uz Tansel

Turbocharge your SQL queries in-memory with Apache® Ignite™ by Denis Magda

Python + Jupyter + Postgres by Jim Nasby

RDS or: How I Learned to Stop Worrying and Love the Cloud by Gavin M. Roy

How Green Was My Valley by Joe Conway

Audit Logging for PostgreSQL by David Steele

Peeking into the Black Hole called PL/pgSQL - The new PL Profiler by Jan Wieck

ETL Confessions by Corey Huinker

Tour de Data Types: VARCHAR2 or CHAR(255)? by Andreas Scherbaum

Migrating off of MongoDB to PostgreSQL by Alvaro Hernandez

Use Cases

Analytics Infrastructure Powered by Logical Decoding and Kafka by Jeff Klukas

Softlayer vs RDS/AWS: A price to performance perspective by Joshua D. Drake

Corruption War Stories by Christophe Pettus

Top 10 Problems Solved by PostGIS by Leo Hsu and Regina Obe

TOASTing an Elephant : Building a Custom Data Warehouse Using PostgreSQL by David Kohn

Designing The Right Schema To Power Heap by Dan Robinson

Processing 1 billion rows per second by Hans-Jürgen Schönig

The dark side of the universe from Oracle to PostgreSQL by Sara Nieto

Pgcrypto avast!: A case-study in Django's password hashers by Drew Engelson

Transitioning from MSSQL to PostgreSQL, our trails and tribulations. by Louis Royster

Collaboration and Community in PostgreSQL by Debra Cerda

Lessons Learned the Hard Way: Postgres in Production at GoCardless by Chris Sinjakli

600k queries per second in PostgreSQL - we do it in TomTom by Michał Gutkowski


PostgreSQL When It's Not Your Job by Christophe Pettus

Designing a Multi-tenant Database for Scale with PostgreSQL by Ozgun Erdogan

Getting Stuff done with PostGIS by Leo Hsu and Regina Obe

Detecting performance problems and fixing them by Hans-Jürgen Schönig

Pacific Crest Trail: The postgresql.conf from A-Z by Joshua D. Drake

Linux IO internals for PostgreSQL administrators by Ilya Kosmodemiansky


Evolution of pgAdmin: pgAdmin4 by Dave Page

Next-Generation Parallel Query by Robert Haas

MVCC Unmasked by Bruce Momjian

Logical Replication in PostgreSQL 10 by Peter Eisentraut

PostgreSQL BI Performance & News from XL project by Tomas Vondra

All the dirt on VACUUM: 9.6 edition by Jim Nasby

Sort vs. Hash: A Duality by Peter Geoghegan

Speeding up Query Execution by Andres Freund

In-core compression: how to shrink your database size in several times by Anastasia Lubennikova

Jsonb in Postgres - the present and future by Oleg Bartunov

Implementing Graph Database based on PostgreSQL by Kisung Kim

a Practical Postgres Protocol Primer by Will Leinweber

Regulated Industry Summit

Blockchain, Distributed Security and Regulated Industries by Chris Dannen

Secure Containers, Bridging Mainframes to Cloud, (IBM) by Diana Henderson

HIPAA Compliant, Scalable and Highly Available PostgreSQL Architecture in AWS by Yaser Raja

Security Enhancements in Postgres 10 by Simon Riggs

Public Clouds & Risk Assessments for Regulated Industries by Kai Huang

Engineering cloud infrastructure for HIPAA-compliance by Shaun Qualheim

Secure Technical Implementation Guide (STIG) For PostgreSQL by Jason O'Donnell

How to Make Security on NoSQL More than just an afterthought by Chad Hardin

Creating blockchain platforms and future directions by Ryan Smith

Westin Jersey City

Situated on the waterfront Financial District of Jersey City, our AAA/CAA Four Diamond hotel is just 200 steps and one subway stop to NYC. Featuring spacious guest rooms and inspiring views of Manhattan, we're walking distance to great restaurants on the Hudson waterfront. Explore our now completed hotel renovation, escape to the serenity of our 429 Jersey City accommodations and treat yourself to a stay in a one of our premium rooms with sweeping Hudson views of the NYC skyline. In our elevated rooms, you'll have more space to refresh for the next day. Experience the rejuvenating Heavenly Bath and the signature Westin Heavenly Bed, perfect for a blissful night's sleep.

Make sure and visit the resources page for more information.

You can book at room with the conference negotiated rate, here.

Jersey City,

Westin Jersey City
479 Washington Blvd
Jersey City, 07310
United States

Where to stay in Jersey City

We recommend these accommodations for your visit.

Jersey city newport westin jersey city newport hotel exterior hotel

The Westin Jersey City Newport

At the Westin Jersey City Newport, we have negotiated a discounted conference room rate of $236/night + applicable taxes for attendees. Be sure to book prior to March 6, 2017 - the conference rate is not guaranteed after this date.

Rooms may be booked via the Westin website, or via telephone (888) 627-7148. If booking via telephone please mention PGConf US 2017 to receive the group rate.

Guestroom wifi is included in the room rate.

Dt hotellobby03 2 677x380 fittoboxsmalldimension center

DoubleTree by Hilton Hotel & Suites Jersey City

An all-suite hotel just a few blocks from the conference. Rooms may be booked via the DoubleTree website.

Ewrnw phototour23

Courtyard Jersey City Newport

A convenient hotel a short walk from the conference adjacent to the NJ PATH Station. Rooms may be booked via the Marriott website.