PGConf Local: Philly 2017 [PgConf.US] Program

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.

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...

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...

presented by PostgresConf Organizers

Coffee Break

presented by PostgresConf Organizers

Lunch

presented by PostgresConf Organizers

A quick kickoff session

presented by PostgresConf Organizers

Closing Session

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...

presented by Michael 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 ...

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...

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.

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.

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...

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 ...

presented by PostgresConf Organizers

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