From PostgreSQL wiki
Jump to navigationJump to search


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!