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.
has the most awesome program ever!
See rock-star speakers cover the topics of
How Postgres Fails In the Cloud and How to Recover It by Greg Burek
PostgreSQL worst practices by Ilya Kosmodemiansky
Columns and Clouds - Hybrid databases by David Rader
From Dev to prod, The ABC's of PostgreSQL backups by Scott Mead
POWER Platform - The New Home For PostgreSQL by Michael Meskes
Things we love about pgpool and things we hate by Sameer Kumar
Advanced Postgres Monitoring by Denish Patel
PostgreSQL High Availability in a Containerized World by Jignesh Shah
Patroni - HA PostgreSQL made easy by Alexander Kukushkin
DevOps Tools for managing PostgreSQL by Kunal Jain
Amazon RDS for PostgreSQL: What’s New and Lessons Learned by Grant McAlister
Managing OS Provided PostgreSQL Packages by Keith Fiske
High-Availability Postgres with etcd by Tess Rinearson
ZooKeeper for fault tolerant PostgreSQL databases & Name Service by KRISHNA SARABU
Restrictions on PostgreSQL Cloud DBaaS by Simon Riggs
Provisioning and Automating High Availability Postgres on AWS EC2 by Payal Singh
Time in Databases by Abdullah Uz Tansel
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
Migration from Oracle to native PostgreSQL by Max ten Dam
IDENTIFYING SLOW QUERIES AND FIXING THEM! by Stephen Frost
Turbocharge your SQL queries in-memory with Apache® Ignite™ by Denis Magda
Tips & Tricks for Using MADlib with PostgreSQL and Greenplum by Charles Killam
ETL Confessions by Corey Huinker
RDS or: How I Learned to Stop Worrying and Love the Cloud by Gavin M. Roy
Tour de Data Types: VARCHAR2 or CHAR(255)? by Andreas Scherbaum
How Green Was My Valley - Advanced Spatial Analytics by Joe Conway
Becoming A SQL Guru by Stella Nisenbaum
Audit Logging for PostgreSQL by David Steele
Migrating off of MongoDB to PostgreSQL by Alvaro Hernandez
Peeking into the Black Hole called PL/pgSQL - The new PL Profiler by Jan Wieck
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
Processing 1 billion rows per second by Hans-Jürgen Schönig
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
Lessons Learned the Hard Way: Postgres in Production at GoCardless by Chris Sinjakli
The dark side of the universe from Oracle to PostgreSQL by Sara Nieto
600k queries per second in PostgreSQL - we do it in TomTom by Michał Gutkowski
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
Linux IO internals for PostgreSQL administrators by Ilya Kosmodemiansky
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
Evolution of pgAdmin: pgAdmin4 by Dave Page
Next-Generation Parallel Query by Robert Haas
Fuzzy Elephants with LLVM by Gregory Stark
a Pratical Postgres Protocol Primer by Will Leinweber
Speeding up Query Execution by Andres Freund
MVCC Unmasked by Bruce Momjian
Logical Replication in PostgreSQL 10 by Peter Eisentraut
Sort vs. Hash: A Duality by Peter Geoghegan
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
PostgreSQL BI Performance & News from XL project by Tomas Vondra
Implementing Graph Database based on PostgreSQL by Kisung Kim
All the dirt on VACUUM: 9.6 edition by Jim Nasby
Regulated Industry Summit
Jersey City / United States479 Washington Blvd
07310, Jersey City
For information on sponsoring please download the PgConf US 2017 prospectus
Newark Liberty International Airport (EWR) is the closest airport to Jersey City and PGConf US 2017. We highly recommend traveling via Newark if you can find a reasonable route and fare.
La Guardia Airport (LGA) is about 15 miles away from the Westin. Drive time from La Guardia to Jersey City ranges from 30 minutes to an hour depending on traffic.
John F. Kennedy International Airport (JFK) is about 25 miles away from the Westin. Drive time from JFK to Jersey City ranges from 40 minutes to 2 hours depending on traffic.
The Westin Jersey City is just steps away from the PATH Newport station. The Newport Station is served by Hoboken and Journal Square-33rdStreet and Hoboken-World Trade Center lines. From the Newport Station, walk across Washington Boulevard, turn left and the Westin will be visible.
Via MTA Subway
Transfer to the PATH are available at a number of stations along the 33rdStreet line as well as WTC.
From the South, take Amtrak to Newark, Penn Station (NWK). From Newark, Penn Station, take the PATH World Trade Center line. Switch trains at Journal Square to the PATH 33rdStreet line. Exit at Newport Station.
From the North, take Amtrak to New York, Penn Station (NYP). From New York, Penn Station, take the PATH 33rdStreet line to Newport Station.
Things to do
Statue of Liberty
Take the ferry from Liberty State Park to get a close-up look at Lady Liberty.
See the gateway for over 12 million immigrants to the United States as the nation's busiest immigrant inspection station for over sixty years from 1892 until 1954.
Take the PATH to the World Trade Center Transportation Hub, aka The Oculus.
Liberty Science Center
Whether you’re traveling with kids or if you’re a full-grown science fanatic, LSC has an exhibit, event or show that is right up your alley. Check out the IMAX theater, dinosaur dig, virtual reality and the soon-to-be biggest planetarium in the west. Sign up for a lecture or take a tour through the Center.
This old-fashioned biergarten is the only hot spot on this side of the Hudson or craft beer, good food and a great time. Fill up a stein with one of the 144 brews on tap, grab a bite of traditional European fare from the walk-up window and take a seat at the massive patio’s big community tables.
Friday, March 24
NCAA Men's Tournament (Sweet 16) at Madison Square Garden
Sunday, March 26
NCAA Men's Tournament (Elite 8) at Madison Square Garden
Monday, March 27
NBA - New York Knicks and Detroit Pistons at Madison Square Garden
Wednesday, March 29
NBA - New York Knicks and Miami Heat at Madison Square Garden
Wednesday, March 29
The Beach Boys at Bergen Performing Arts Center in Englewood, NJ
Wednesday, March 29
Anthrax, Killswitch Engage & The Devil Wears Prada at The Wellmont Theatre in Montclair, NJ
Saturday, April 1
Lionel Richie & Mariah Carey at Madison Square Garden
Code of Conduct : Treat people well.
If you feel that you are being harassed, notice that someone else is being harassed, or have any other concerns, please contact a PGConf US 2017 volunteer immediately. Other forms of contact:
For All Emergencies (Medical, Police, Fire): 911
PGConf US does not tolerate harassment of PGConf US 2017 participants in any form. Harassment includes offensive verbal comments related to gender, sexual orientation, disability, physical appearance, body size, race, religion, displaying sexual images in public spaces, deliberate intimidation, stalking, following, harassing photography or recording, sustained disruption of talks or other events, inappropriate physical contact, and unwelcome sexual attention. Participants asked to stop any harassing behavior are expected to comply immediately.
Sexual language and imagery is not appropriate for any conference venue, including talks and social events around PGConf US 2017. Conference participants violating these rules may be sanctioned or expelled from the conference without a refund at the discretion of the PGConf US 2017 co-chairs.
If a participant engages in behavior violating this code of conduct, the PGConf US 2017 co-chairs may take any action they deem appropriate, including ejection from the conference with no refund or contacting the authorities.
PGConf US 2017 staff are willing to help participants contact hotel/venue security or the NJPD, provide escorts, or otherwise assist those experiencing harassment to feel safe for the duration of the conference.
Thank you for your help in making PGConf US 2017 fun and enjoyable for everyone! Refunds
If for any reason you have registered PGConf US 2017 but are unable to attend, PGConf US 2016 will permit full refunds up until 30 days before the conference. After this period, your ticket is nonrefundable.