Sessions at OSCON 2012 about PostgreSQL

View as grid

Tuesday 17th July 2012

• PostgreSQL Unboxing

  by Christophe Pettus

  You have your shiny new PostgreSQL source tarball or package, but what to do with it? In one intense tutorial, we'll go through everything need to install, configure, and maintain your new, tuned, replicated, back-uped PostgreSQL installation.

  • installation
  • PostgreSQL
  • Tutorial

  At 9:00am to 12:30pm, Tuesday 17th July

  In E145-146, Oregon Convention Center

Wednesday 18th July 2012

• PostgreSQL

  Meet and greet members of the Portland PostgreSQL Users Group, and also talk about PostgreSQL.

  • PostgreSQL

  At 7:00pm to 8:00pm, Wednesday 18th July

  In D135, Oregon Convention Center

Thursday 19th July 2012

• A Stitch In Time Saves Nine: Solving the N+1 Problem

  by Paul Jones

  When dealing with databases, developers frequently run into the N+1 problem, in which they populate domain objects via queries in loops. This causes terrible performance drags. The talk shows how to solve the N+1 problem in plain PHP as well as Postgres. It concludes with a way of automating the PHP side, and includes editorializing about the origins of the N+1 problem in the developer mindset.

  • Databases
  • N+1
  • PHP
  • PostgreSQL

  At 11:30am to 12:10pm, Thursday 19th July

  In E144, Oregon Convention Center

• PostgreSQL's place in the new world order

  by Matthew Soldo

  Recent shifts in the tech world - including PaaS, cloud-services, and NoSQL - have dramatically altered the manner in which software is written, deployed, and run. This talk will discuss how PostgreSQL fits into - and can potentially take advantage of - this world.

  • Cloud
  • NoSQL
  • PaaS
  • PostgreSQL

  At 4:10pm to 4:50pm, Thursday 19th July

  In Portland 252, Oregon Convention Center

  Coverage slide deck

• Unlocking Proprietary Data with PostgreSQL Foreign Data Wrappers

  by Pat Patterson

  PostgreSQL 9.1 introduced ‘Foreign Data Wrappers’ (FDW) – a partial implementation of the SQL/MED standard for handling access to remote data sources. FDW allows PostgreSQL to expose remote data as foreign tables which then behave similarly to native PostgreSQL tables, in particular, allowing remote data to be queried with SQL statements.

  This session provides an overview of Foreign Data Wrappers, looks at the native interface for writing FDWs in C, and contrasts this with Multicorn, an open source framework that allows FDWs to be developed in Python. We will show a real-world Python FDW that retrieves business data from salesforce.com, with a sample client application that demonstrates how foreign data can be combined with data held in native PostgreSQL tables using a simple SQL JOIN.

  • PostgreSQL
  • Python

  At 5:00pm to 5:40pm, Thursday 19th July

  In Portland 252, Oregon Convention Center

  Coverage link slide deck

Friday 20th July 2012

• Explaining the Postgres Query Optimizer

  by Bruce Momjian

  The optimizer is the "brain" of the database, interpreting SQL queries and determining the fastest method of execution. This talk uses the explain command to show how the optimizer interprets queries and determines optimal execution.

  • PostgreSQL
  • SQL

  At 11:00am to 11:40am, Friday 20th July

  In Portland 252, Oregon Convention Center