PGConf Local: Austin [PgConf.US] Program
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
Launch
presented by Debra Cerda
Welcome to PGConf US Local: Austin!
09:30 - 09:50 Cypress
OpenSCG Keynote
presented by Jim Mlodgenski
OpenSCG Keynote
09:50 - 10:10 Cypress
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,...
more 10:20 - 11:10 Magnolia B Dev
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...
more 10:20 - 11:10 Cypress Cloud & Data
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.
Dev
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...
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. 
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...
more Dev
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...
more Open Source
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...
more Cloud & Data
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.
Ops
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...
more Training