PgConfUS Talks 2017

PGConf US 2017 Talks

Conference Website

https://www.pgconf.us/conferences/2017

Videos

https://www.youtube.com/pgconfus/

Trainings: Tuesday, 28 March 2017

• PostgreSQL When It's Not Your Job, Christophe Pettus
• Designing a Multi-tenant Database for Scale with PostgreSQL, Ozgun Erdogan and Lukas Fittl
• Pacific Crest Trail: The postgresql.conf from A-Z, Joshua D. Drake
• Detecting performance problems and fixing them, Hans-Jürgen Schönig
• Getting Stuff done with PostGIS, Leo Hsu and Regina Obe
• Linux IO internals for PostgreSQL administrators, Ilya Kosmodemiansky

Regulated Industry Summit

• Creating blockchain platforms and future directions, Ryan Smith
• Blockchain, Distributed Security and Regulated Industries, Chris Dannen
• Public Clouds & Risk Assessments for Regulated Industries, Kai Huang
• Secure Containers, Bridging Mainframes to Cloud, (IBM), Diana Henderson
• Engineering cloud infrastructure for HIPAA-compliance, Shaun Qualheim
• HIPAA Compliant, Scalable and Highly Available PostgreSQL Architecture in AWS, Yaser Raja and Glenn Poston
• How to Make Security on NoSQL More than just an afterthought, Chad Hardin
• Secure Technical Implementation Guide (STIG) For PostgreSQL, Jason O'Donnell
• Security Enhancements in Postgres 10, Simon Riggs

Sessions: Wednesday, 29 March 2017

Liberty I

• Intro to PostgreSQL - a jumpstart to up and running, Joe Conway
• Speeding up Query Execution, Andres Freund
• Sort vs. Hash: A Duality, Peter Geoghegan
• In-core compression: how to shrink your database size in several times, Anastasia Lubennikova and Aleksander Alekseev
• MVCC Unmasked, Bruce Momjian
• Peeking into the Black Hole called PL/pgSQL - The new PL Profiler, Jan Wieck

Liberty II

• Designing your SaaS Database for Scale with Postgres, Ozgun Erdogan
• Time in Databases, Abdullah Uz Tansel
• Gophers Riding Elephants: Writing PostgreSQL tools in Go, AJ Bahnken
• Migration from Oracle to native PostgreSQL, Max ten Dam
• IDENTIFYING SLOW QUERIES AND FIXING THEM!, Stephen Frost
• Tour de Data Types: VARCHAR2 or CHAR(255)?, Andreas Scherbaum

Liberty III

• Analytics Infrastructure Powered by Logical Decoding and Kafka, Jeff Klukas
• Lessons Learned the Hard Way: Postgres in Production at GoCardless, Chris Sinjakli
• Designing The Right Schema To Power Heap, Dan Robinson
• Softlayer vs RDS/AWS: A price to performance perspective, Joshua D. Drake
• Transitioning from MSSQL to PostgreSQL, our trails and tribulations, Louis Royster
• Pgcrypto avast!: A case-study in Django's password hashers, Drew Engelson

America

• Enterprise Data Architecture with PostgreSQL, Kevin Kempter
• POWER Platform - The New Home For PostgreSQL, Michael Meskes
• PostgreSQL worst practices, Ilya Kosmodemiansky
• Patroni - HA PostgreSQL made easy, Alexander Kukushkin
• High-Availability Postgres with etcd, Tess Rinearson
• DevOps Tools for managing PostgreSQL, Kunal Jain,Yun Guo

Sessions: Thursday, 30 March 2017

Liberty I

• Logical Replication in PostgreSQL 10, Peter Eisentraut
• Jsonb in Postgres - the present and future, Oleg Bartunov
• All the dirt on VACUUM: 9.6 edition, Jim Nasby
• Next-Generation Parallel Query, Robert Haas
• Collaboration and Community in PostgreSQL, Debra Cerda
• Data Rescue, Debra Cerda,Jim Nasby

Liberty II

• Google Workshop: Cloud SQL, Alexis Guajardo
• Schema management with Flyway, Scott Mead
• Audit Logging for PostgreSQL, David Steele
• Migrating off of MongoDB to PostgreSQL, Alvaro Hernandez
• Turbocharge your SQL queries in-memory with Apache Ignite, Denis Magda
• OpenSCG Workshop: Hands on Oracle to PostgreSQL Migration, David Rader,Scott Mead,Jan Wieck,Denis Lussier

Liberty III

• The dark side of the universe from Oracle to PostgreSQL, Sara Nieto
• Top 10 Problems Solved by PostGIS, Leo Hsu and Regina Obe
• Processing 1 billion rows per second, Hans Jürgen Schönig
• Corruption War Stories, Christophe Pettus
• EDB Workshop: 5 Things Developers Need to Know About Digital Transformation with Postgres, Bruce Momjian

America

• LXD, the Container Hypervisor, Anthony Davis
• Columns and Clouds - Hybrid databases, David Rader
• PostgreSQL High Availability in a Containerized World, Jignesh Shah
• From Dev to prod, The ABC's of PostgreSQL backups, Scott Mead
• Amazon RDS for PostgreSQL: What's New and Lessons Learned, Grant McAlister
• Automating Production-Ready Databases in Docker, Jesse White

Enterprise

• DataGrip, SQL client from JetBrains, Vasiliy Chernov
• Python + Jupyter + Postgres, Jim Nasby
• Postgres Performance for Application Developers, Lukas Fittl
• Django and PostgreSQL: Two Great Tastes, Christophe Pettus
• An Introduction to SQLAlchemy and Friends, Jon Banafato

Sessions:Friday, 31 March 2017

Liberty I

• 2ndQuadrant Workshop: Logical replication deep dive, Peter Eisentraut
• a Practical Postgres Protocol Primer, Will Leinweber
• PostgreSQL BI Performance & News from XL project, Tomas Vondra
• Implementing Graph Database based on PostgreSQL, Kisung Kim
• Evolution of pgAdmin: pgAdmin4, Dave Page

Liberty II

• ETL Confessions, Corey Huinker
• RDS or: How I Learned to Stop Worrying and Love the Cloud, Gavin M. Roy
• How Green Was My Valley - Spatial Analytics, Joe Conway
• Exploiting the hidden talents of JDBC for maximum performance, Dave Cramer

Liberty III

• TOASTing an Elephant : Building a Custom Data Warehouse Using PostgreSQL, David Kohn
• 600k queries per second in PostgreSQL - we do it in TomTom, Michał Gutkowski
• Managing OS Provided PostgreSQL Packages, Keith Fiske
• Advanced Postgres Monitoring, Denish Patel

America

• Restrictions on PostgreSQL Cloud DBaaS, Simon Riggs
• Provisioning and Automating High Availability Postgres on AWS EC2, Payal Singh
• TimescaleDB: Designing a scalable time-series database on PostgreSQL, Mike Freedman