
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.
Program
2017 has the most awesome program ever! See rock-star speakers cover the topics of
Operations
Provisioning and Automating High Availability Postgres on AWS EC2 by Payal Singh
Managing OS Provided PostgreSQL Packages by Keith Fiske
Amazon RDS for PostgreSQL: What’s New and Lessons Learned by Grant McAlister
Restrictions on PostgreSQL Cloud DBaaS by Simon Riggs
High-Availability Postgres with etcd by Tess Rinearson
Columns and Clouds - Hybrid databases by David Rader
DevOps Tools for managing PostgreSQL by Kunal Jain
Patroni - HA PostgreSQL made easy by Alexander Kukushkin
Enterprise Data Architecture with PostgreSQL by Kevin Kempter
PostgreSQL High Availability in a Containerized World by Jignesh Shah
Intro to PostgreSQL by Joe Conway
Advanced Postgres Monitoring by Denish Patel
POWER Platform - The New Home For PostgreSQL by Michael Meskes
From Dev to prod, The ABC's of PostgreSQL backups by Scott Mead
DataGrip, SQL client from JetBrains by Vasiliy Chernov
PostgreSQL worst practices by Ilya Kosmodemiansky
LXD, the Container Hypervisor by Anthony Davis
Postgres Performance for Application Developers by Lukas Fittl
Data Rescue by Debra Cerda
Automating Production-Ready Databases in Docker by Jesse White
Development
Migrating off of MongoDB to PostgreSQL by Alvaro Hernandez
Tour de Data Types: VARCHAR2 or CHAR(255)? by Andreas Scherbaum
ETL Confessions by Corey Huinker
Peeking into the Black Hole called PL/pgSQL - The new PL Profiler by Jan Wieck
Audit Logging for PostgreSQL by David Steele
How Green Was My Valley by Joe Conway
RDS or: How I Learned to Stop Worrying and Love the Cloud by Gavin M. Roy
Python + Jupyter + Postgres by Jim Nasby
Turbocharge your SQL queries in-memory with Apache® Ignite™ by Denis Magda
Time in Databases by Abdullah Uz Tansel
IDENTIFYING SLOW QUERIES AND FIXING THEM! by Stephen Frost
Schema management with Flyway by Scott Mead
Exploiting the hidden talents of JDBC for maximum performance by Dave Cramer
Gophers Riding Elephants: Writing PostgreSQL tools in Go by AJ Bahnken
Designing your SaaS Database for Scale with Postgres by Ozgun Erdogan
TimescaleDB: Designing a scalable time-series database on PostgreSQL by Mike Freedman
Django and PostgreSQL: Two Great Tastes by Christophe Pettus
An Introduction to SQLAlchemy and Friends by Jon Banafato
Use Cases
600k queries per second in PostgreSQL - we do it in TomTom by Michał Gutkowski
Lessons Learned the Hard Way: Postgres in Production at GoCardless by Chris Sinjakli
Collaboration and Community in PostgreSQL by Debra Cerda
Transitioning from MSSQL to PostgreSQL, our trails and tribulations. by Louis Royster
Pgcrypto avast!: A case-study in Django's password hashers by Drew Engelson
The dark side of the universe from Oracle to PostgreSQL by Sara Nieto
Processing 1 billion rows per second by Hans-Jürgen Schönig
Designing The Right Schema To Power Heap by Dan Robinson
TOASTing an Elephant : Building a Custom Data Warehouse Using PostgreSQL by David Kohn
Top 10 Problems Solved by PostGIS by Leo Hsu and Regina Obe
Corruption War Stories by Christophe Pettus
Softlayer vs RDS/AWS: A price to performance perspective by Joshua D. Drake
Analytics Infrastructure Powered by Logical Decoding and Kafka by Jeff Klukas
Training
Linux IO internals for PostgreSQL administrators by Ilya Kosmodemiansky
Pacific Crest Trail: The postgresql.conf from A-Z by Joshua D. Drake
Detecting performance problems and fixing them by Hans-Jürgen Schönig
Getting Stuff done with PostGIS by Leo Hsu and Regina Obe
Designing a Multi-tenant Database for Scale with PostgreSQL by Ozgun Erdogan
PostgreSQL When It's Not Your Job by Christophe Pettus
Internals
a Practical Postgres Protocol Primer by Will Leinweber
Implementing Graph Database based on PostgreSQL by Kisung Kim
Jsonb in Postgres - the present and future by Oleg Bartunov
In-core compression: how to shrink your database size in several times by Anastasia Lubennikova
Speeding up Query Execution by Andres Freund
Sort vs. Hash: A Duality by Peter Geoghegan
All the dirt on VACUUM: 9.6 edition by Jim Nasby
PostgreSQL BI Performance & News from XL project by Tomas Vondra
Logical Replication in PostgreSQL 10 by Peter Eisentraut
MVCC Unmasked by Bruce Momjian
Next-Generation Parallel Query by Robert Haas
Evolution of pgAdmin: pgAdmin4 by Dave Page
Regulated Industry Summit
Secure Containers, Bridging Mainframes to Cloud, (IBM) by Diana Henderson
Blockchain, Distributed Security and Regulated Industries by Chris Dannen
How to Make Security on NoSQL More than just an afterthought by Chad Hardin
Secure Technical Implementation Guide (STIG) For PostgreSQL by Jason O'Donnell
Engineering cloud infrastructure for HIPAA-compliance by Shaun Qualheim
Public Clouds & Risk Assessments for Regulated Industries by Kai Huang
Security Enhancements in Postgres 10 by Simon Riggs
HIPAA Compliant, Scalable and Highly Available PostgreSQL Architecture in AWS by Yaser Raja
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.
Where to stay in Jersey City
We recommend these accommodations for your visit.