PDXPUGDay2011

PDXPUG Day OSCON 2011

PDXPUG is the Portland PostgreSQL Users' Group.

Date: Sunday, July 24, 2011

Time: 9:30 am to 5:30pm, with a break for lunch and a party afterwards

Place: Oregon Convention Center, room E147

Content: Sessions covering PostgreSQL-related topics not included in the main program.

Invited: PDXPUG, PostgreSQL community members, Collaboration Summit participants, OSCON participants

Fee: Suggested donation of $30 to the PostgreSQL Fund

Party: afterwards, join us for a party (details below)

Registration: Sign up for free!

Schedule (subject to change):

10:00am	Welcome and Introductions	Mark Wong
10:30am	MVCC Unmasked	Bruce Momjian
12:00pm	Lunch
1:30pm	Building and Distributing PostgreSQL Extensions Without Learning C	David E. Wheeler
2:30pm	PL/Perl6: Butterflies in your PostgreSQL Database	Jonathan "Duke" Leto
3:30pm	Advanced WAL file management with OmniPITR	Rob Treat
4:30pm	Zooming with PostgreSQL	Tom Raney
6:00pm - 10:00pm	Party at Gotham Tavern! 2240 N Interstate Avenue, Portland, Oregon 97227

Talk Descriptions

MVCC Unmasked (Bruce Momjian)

Multi-Version 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.

Building and Distributing PostgreSQL Extensions Without Learning C (David E. Wheeler)

PostgreSQL is extensible like a dynamic programming language. Support for custom functions, operators, types, domains, and other database objects is built right into SQL. This talk will take you through the process of creating a pure-SQL extension and distributing it on [PGXN], the "CPAN for PostgreSQL extensions".

PL/Perl6: Butterflies in your PostgreSQL Database (Jonathan "Duke" Leto)

PL/Perl6 is a new PostgreSQL Procedural Language that allows one to write stored procedures in Perl 6.

Advanced WAL file management with OmniPITR (Robert Treat)

OmniPITR is a set of scripts designed to help manage and maintain database operations that revolve around Postgres WAL files. It was created in an effort to replace the myriad scripts we've encountered and/or written managing our clients Postgres installs over the years. It includes tools for both archiving, restoration, and creating portable backups on both the master and slave instance.

Zooming with PostgreSQL (Tom Raney)

How do you build an advanced medical record system in just a few months that is lightening fast, supports multiple clinics and scales well? Easy! PostgreSQL, Java and the power of OSS!