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|
|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|
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!