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