Postgres Open 2014

Conference website: PostgresOpen 2014

Wednesday September 17 (Tutorials)

• Adv. SQL + Functions (Joe Conway, Stephen Frost)
• PostGIS Introduction: Geometry, Geography, and Geocoding (Regina Obe, Leo Hsu) HTML PDF related data and docs
• PostGIS on caffeine: Raster, Topology, and pgRouting (Regina Obe, Leo Hsu) HTML PDF related data and docs
• Writing & Using Postgres Extensions (Dimitri Fontaine) PostgresOpen_2014_Extension.pdf
• Using the Heroku Platform (Free) (Harold Giménez) (Slides)
• NoSQL on ACID (Free) (Bruce Momjian)

Thursday September 18

• Sponsor Keynote (Marc Linster)

• Explaining the Postgres Query Optimizer (Bruce Momjian)
• Postgres in Amazon RDS (Denish Patel)
• How Databases Work - For Developers, Accidental DBAs and Managers (Gurjeet Singh)

• Scalability, Consistency, Replication, Availability and Performance (Simon Riggs)
• The NoSQL Way In PostgreSQL (Vibhor Kumar)
• So you're new to Postgres... (Michael Alan Brewer)

• Who's the Fairest of Them All? Postgres Interface Performance (Joe Conway)
• What's new in PostgreSQL 9.4 (Magnus Hagander)
• Postgres on OpenStack (Dave Page)

• Automated Performance Testing of Postgres (Greg Burek)
• Survival analysis of customer retention using Postgres, SQL and R (Gleb Arshinov)
• The Three Musketeers: Authentication, Authorization and Accounting (Sarah Conway)

• On Beyond Data Types (Jonathan S. Katz)
• Supersized Postgres: Postgres-XL for OLTP and Big Data Analytics (Mason Sharp)
• Use PostgreSQL, not Rails, to make Rails faster! (Dan McClain)

Lightning Talks

• Collations and Filesystem-based Copies (Matthew Kelly)
• pgcharts (Dimitri Fontaine)
• Terra Populus (David Haynes)
• DDL generator (Catherine Devlin)
• Is Your Bank Really on Acid? (Rob Treat)
• crontabber (Peter Bengtsson)
• Chelnik Update (Mark Wong)

Friday, September 19

• PostgreSQL Scale-Out at InMobi (Sivakumar)
• Row-Estimation Revelation and the Monolithic Query Syndrome (Jeff Amiel)
• Tales from the Postgres Front, and What We Can Learn (Marc Linster)

• PostgreSQL for developers (Dimitri Fontaine) PostgresOpen_2014_PostgreSQL_for_Developers.pdf
• Database Security and Audit Logging: User-Centered Security with JackDB (Sehrope Sarkuni)
• Immutable Data in Postgres (Gary Sieling)

• How VACUUM works, and what to do when it doesn't (Simon Riggs)
• Heavy Duty Backup with PgBackRest (David Steele)
• Migrating away from MySQL for an awesome fulltext search (Peter Bengtsson)

• PostgreSQL and Java: best practices + Source code (Álvaro Hernández)
• Collectd and Graphite: Monitoring PostgreSQL with Style (Shaun Thomas)
• Columnar Store for PostgreSQL (Ben Redman)

• Row Level Security (Stephen Frost)
• Holistic Database Application Tuning – Factoring UDFs in an All-new Way Grant Evans, (Henrietta Dombrovskaya)
• Frictionless Data Science with Python (Catherine Devlin)
• Understanding logical decoding and replication (Michael Paquier)
• A Performance Characterization of Postgres on Different Storage Systems (Dong Ye, Syed Faisal Akber)
• A Quantitative Look at Partitions (john melesky)

• Sponsor Keynote (Simon Riggs)