Sessions at OSCON Data 2011 about PostgreSQL

Monday 25th July 2011

• MVCC Unmasked

  by Bruce Momjian

  Multiversion Concurrency Control (MVCC) allows Postgres to offer high concurrency even during significant database read/write activity. MVCC specifically offers behavior where "readers never block writers, and writers never block readers". This talk explains how MVCC is implemented in Postgres and highlights optimizations which minimize the downsides of MVCC. This talk is for advanced users.

  • MVCC
  • PostgreSQL

  At 2:20pm to 3:00pm, Monday 25th July

  In C121/122, Oregon Convention Center

  Coverage video

• QYZ: LaTeX, R and Redis for Beautiful Analytics

  by Noah Pepper and Homer Strong

  We produce gorgeous LaTeX reports while harnessing the power of R on the backend. The data is pulled from our PostgreSQL database, the analysis and visualizations are fast and distributed thanks to Redis. We'll talk about weaving together open source tools to build powerful analytics reporting engines that rival the commercial alternatives.

  • Data Visualization
  • LaTeX
  • PostgreSQL
  • R
  • Redis

  At 4:20pm to 5:00pm, Monday 25th July

  In C123, Oregon Convention Center

Tuesday 26th July 2011

• Harder, Better, Faster, Stronger: PostgreSQL 9.1

  by Selena Deckelmann

  PostgreSQL continues to provide a major release every year full of improvements, better performance and features that measure up to the most popular commercial databases. Our 2011 release, 9.1, is no exception!

  • PostgreSQL

  At 10:40am to 11:20am, Tuesday 26th July

  In C123, Oregon Convention Center

• Forests Can Fight Back with Open Source Technology

  by Jeff Hamann

  Learn how to cobble together a PostgreSQL database, install a few handy R packages, a pinch of language extensions, and a handful of publicly available data to generate a forest monitoring platform to help landscape managers make better decisions using basic design-engineering paradigms to perform quick trade-off analyses.

  • Open Source
  • PostgreSQL
  • R

  At 11:30am to 12:10pm, Tuesday 26th July

  In C124, Oregon Convention Center

  Coverage video

• Lean Big Data for Mobile

  by Erik Onnen

  This talk will cover lessons learned in building Urban Airship's large-scale data warehouse in EC2 including PostgreSQL, Kafka, Cassandra, HBase and Hadoop.

  • Big Data
  • Cassandra
  • Hadoop
  • PostgreSQL
  • Urban Airship

  At 2:20pm to 3:00pm, Tuesday 26th July

  In B118-119, Oregon Convention Center

Wednesday 27th July 2011

• Pro PostgreSQL 9

  by Rob Treat

  The open source database landscape has never been in more turmoil, and yet the popularity of Postgres continues to grow and grow. Get up to speed on what you need to know to administer the world's most advanced open source database, including installation, configuration, tuning, and how best to use PostgreSQL's community resources; with special focus on Postgres 9 and the upcoming 9.1 release.

  • PostgreSQL

  At 1:40pm to 3:10pm, Wednesday 27th July

  In Oregon Ballroom 204, Oregon Convention Center