PGConf Local: Austin [PgConf.US] Program

Jim Mlodgenski PostgreSQL Administration

presented by Jim Mlodgenski

This training workshop covers all aspects of PostgreSQL administration, including installation, security, file structure, configuration, reporting, backup, daily maintenance, monitoring activity, disk space computations, and disaster recovery. It shows how to control host connectivity, configure the server, find the query being run by each session, and find the disk space used by each database.

09:00 - 12:00 Cypress Training
Debra Cerda Launch

presented by Debra Cerda

Welcome to PGConf US Local: Austin!

09:30 - 09:50 Cypress
Jim Mlodgenski OpenSCG Keynote

presented by Jim Mlodgenski

OpenSCG Keynote

09:50 - 10:10 Cypress
Scott Bellware Event Sourcing with a Postgres Event Store
The Service Architecture You Didn't Know You Wanted

presented by Scott Bellware

Event Sourcing is an approach to application data storage based on little more than an event log. While specialized data stores like Datomic and EventStore have been created specifically to address this space, Postgres makes for a pragmatic and broadly-supported data platform for modeling and operating event stores. This presentation provides a rundown of the Event Sourcing architectural style,...


10:20 - 11:10 Magnolia B Dev
James Finnerty Amazon Aurora with PostgreSQL compatibility
Architecture Overview and Performance

presented by James Finnerty

Amazon Aurora with PostgreSQL compatibility was recently released, and is now in production. Learn about how Amazon Aurora re-imagined the traditional database architecture for the AWS cloud, providing a managed database service that improves durability, availability, performance, variability, and recovery time. This presentation will cover some of the architectural details underlying the Ama...


10:20 - 11:10 Cypress Cloud & Data
Unscheduled events
Jim Nasby Python + Jupyter + Postgres

presented by Jim Nasby

Jupyter notebooks are a powerful tool for interacting with code. They provide a combination of documentation and interaction that works well for demos, education, presentation, as well as data exploration. This talk will demonstrate two methods for interacting with Postgres via both python and Jupyter notebooks.

Lloyd Albin Using GIS in PostgreSQL

presented by Lloyd Albin

In this presentation we will go over the old school math and the new school PostGIS method of doing the same math for calculating the distance and cost of an aircraft flight. You will notice how much easier it is to use PostGIS.

  • Installing PostGIS
    • Cloud Solutions
    • From Source
  • Aviation Math
    • Airplane Performance
    • Great Circle Math
  • PostGIS Math
    • Updating your table...

Stephen Holt Multi-cloud deployment of PostgreSQL in minutes
Deploying On-Demand production and development clusters of PostgreSQL to support true DevOps in any cloud environment.

presented by Stephen Holt

EDB Postgres Ark is a DBaaS for hybrid cloud deployments of Postgres to public and private clouds; on Amazon, OpenStack, Azure, and other deployment platforms. EDB Postgres Ark provides a unified UI (graphical and API) to control and manage highly available deployments across multiple platforms from a single management console that you manage and control. ![Ark platform](https://www.enter...


Ryan Murphy Trees/Hierarchical Data in the SQL Database
How to make nested relationships in SQL more easily and fluently

presented by Ryan Murphy

Learn tools and best practices for constructing, querying, visualizing and manipulating trees and hierarchical data in SQL.

We'll compare various design patterns for how to store the hierarchical relationships in the schema, and explore trade-offs and practical use cases for different approaches. Learn how PostreSQL features such as JSON / JSONB / array types, the WITH RECURSIVE keyword, an...


Debra Cerda Open Source Communities as Biological Ecosystems

presented by Debra Cerda

The study of social insects has long demonstrated the critical importance of eusociality to maintain biodiversity in an ecosystem. Eusociality (“eu” from the Greek meaning good/real), the highest level of animal sociality, includes cooperative brood care, overlapping generations within a colony of adults, and the division of labor into specialized behavioral groups. In addition to having a well...


Open Source
Grant McAlister Deep Dive into the RDS PostgreSQL Universe

presented by Grant McAlister

We will do a deep dive into the exciting new features we recently released, including 9.6 support, new extensions, snapshot sharing, enhancements to encryption, vacuum and replication. We will also explore lessons we have learned managing a large fleet of PostgreSQL instances, including important tunables and possible gotchas around pg_upgrade. During the session we also cover our newly announc...


Cloud & Data
Joshua D. Drake The Power of Postgres Replication

presented by Joshua D. Drake

With PostgreSQL v10 a new replication engine has come to town. Let's explore Postgres Logical Replication, how to use it, optimize it and let it best fit in with your organization. We will also discuss its interactions with external tools as well as Binary Replication and features such as Hot Standby.

Joshua D. Drake Postgres Performance and Maintenance

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