PGConf Local: Philly 2017 Program

Bruce Momjian Mastering PostgreSQL Administration

presented by Bruce Momjian

In this course you will learn the essential details of PostgreSQL configuration, security, maintenance, monitoring, tuning, backups, recovery. The course is designed for people with experience in database administration but who are new to the Postgres platform.

09:00 - 12:00 G50 PostgreSQL
Joshua D. Drake Postgres Performance and Maintenance
Tuning and configuration for optimum performance

presented by Joshua D. Drake

When you are optimizing PostgreSQL it is usually maintenance that goes by the wayside. How do we fix autovacuum? Where did all of this bloat come from? Why am I getting IO spikes? How do I get RDS to behave?! Why are commits so slow on replication? The answer to all of these questions is understanding the relationship between proper Postgres maintenance and performance. Join us for a 3 hour jau...


13:00 - 16:00 G50 PostgreSQL
PgConf US Organizers Registration and Breakfast

presented by PgConf US Organizers

Come check-in, pick up your badge and have some coffee and a light breakfast.

08:00 - 09:00 370 PostgreSQL
PgConf US Organizers Welcome & Opening

presented by PgConf US Organizers

A quick kickoff session

09:00 - 09:20 370
Bruce Momjian Major Features: Postgres 10

presented by Bruce Momjian

PostgreSQL 10 is moving along its beta cycle with a likely release this fall. It has many new and exciting features like Logical Replication and Partitioning. This talk will discuss the many upcoming features in PostgreSQL 10.

09:20 - 10:10 370 PostgreSQL
Payal Singh Securing Your Data on Postgres

presented by Payal Singh

This talk will cover the various features that Postgres provides for data security, from the very basic to the most advanced.

While most applications are aware of the minimum basic security features and use them, there is often a lack of understanding about how best to manage them, especially with major security features being released with every major version of Postgres. As for advanced f...


10:10 - 11:00 370 PostgreSQL
Baron Schwartz PostgreSQL Performance Theory Made Practical
PostgreSQL Performance Theory Made Practical

presented by Baron Schwartz

Like most people, I've Googled for advice and recommended best practices for PostgreSQL performance, but I always wondered: are we there yet? How do I know if my performance is optimized? What if I could still get better performance?

Then one day I discovered Cary Millsap, the light-bulb turned on, and I found the answers. (For Oracle, but it started me on the path that led me to today.) It ...


11:00 - 11:50 370 PostgreSQL
PgConf US Organizers Friday Lunch

presented by PgConf US Organizers


11:50 - 12:50 370
Derek Dohler Attaching flexible metadata to geometries: marrying PostGIS and JSONB

presented by Derek Dohler

We were asked to design a system for storing and analyzing information about traffic accidents in the Philippines. The solution needed to support flexible metadata attached to each record, as well as allow geospatial analysis of records. We also needed to be able to make guarantees about data integrity.

To satisfy these requirements, we adopted a database architecture that is a hybrid of do...


12:50 - 13:40 370 PostgreSQL
Timothy Allen Introspective RESTful APIs with PostgreSQL and Django
Permission based access from your data to the world.

presented by Timothy Allen

Databases are the elephants in the room of modern technology: mature, reliable, sturdy fixtures in the technology world that have served us well for many decades. Databases stay relevant by continuing to reinvent themselves to serve new technologies further up the stack. The latest buzzwords further up that stack are APIs and Microservices, so prevalent that it is hard to see a tech advertiseme...


13:40 - 14:30 370 PostgreSQL
Mike Freedman Building a scalable time-series database on PostgreSQL
TimescaleDB, packaged as a PostgresSQL extension

presented by Mike Freedman

Today everything is instrumented, generating more and more time-series data streams that need to be monitored and analyzed. When it comes to storing this data, many developers often start with some well-trusted system like PostgreSQL, enjoying the convenience of having their data in one place, with time-series data stored alongside relational data and queried together using SQL. But when their ...


14:30 - 15:20 370 PostgreSQL
PgConf US Organizers Coffee Break

presented by PgConf US Organizers

Coffee Break

15:20 - 15:40 370
Hector Castro Life in the Fast Lane: Speeding up an AWS RDS for PostgreSQL Migration

presented by Hector Castro

Every once in a while, you find yourself in a situation where you need to migrate data from one PostgreSQL database instance to another. Whether it’s 10 gigabytes or 1,000 gigabytes, being able to execute the dump/restore process as quickly as possible is always desirable.

In this talk, we’ll go through a handful of steps that’ll minimize the amount of time it takes to dump the contents of a...


15:40 - 16:30 370 PostgreSQL
Jim Mlodgenski Top 10 Mistakes When Migrating From Oracle to PostgreSQL

presented by Jim Mlodgenski

As more and more people are moving to PostgreSQL from Oracle, a pattern of mistakes is emerging. They can be caused by the tools being used or just not understanding how PostgreSQL is different than Oracle. In this talk we will discuss the top mistakes people generally make when moving to PostgreSQL from Oracle and what the correct course of action.

16:30 - 17:20 370 PostgreSQL
PgConf US Organizers Closing

presented by PgConf US Organizers

Closing Session

17:20 - 17:40 370
Bruce Momjian Postgres Party

presented by Bruce Momjian

After a fun day at PGConf Local: Philly, end the week with a little more PostgreSQL on your way home. If you are near Philadelphia and a PostgreSQL lover, Bruce Momjian has invited you to attend the 2017 Postgres Party at his home in Newtown Square:

When: Friday, July 14, 6:20pm

Where: Momjian Residence in Newtown Square, Pennsylvania (directions)...


18:20 - 22:20 370