PGCon2009 - Final Release

PGCon 2009
The PostgreSQL Conference

Event Speakers

Building PetaByte Warehouses with Unmodified PostgreSQL

Event type : Lecture
Track : Case Studies
Language used for presentation : English

Closing sessions

prizes, auctions, fun, games

Event type : Other
Track : Plenary
Language used for presentation : English

Converting 100 databases to PostgreSQL

Wisconsin State Courts implementation

Event type : Lecture
Track : Case Studies
Language used for presentation : English

Database Hardware Benchmarking

How big is the elephant in your room?

Event type : Lecture
Track : Performance
Language used for presentation : English

Database Refactoring

An idea on how to redesign an existing database with minimal downtime

Event type : Lecture
Track : DBA
Language used for presentation : English

Encrypted PostgreSQL

Event type : Lecture
Track : Advanced Features
Language used for presentation : English

How to Get Your PostgreSQL Patch Accepted

patch submission accepted

Event type : Lecture
Track : Hacking
Language used for presentation : English

Introducing Windowing Functions

Internals and Externals

Event type : Lecture
Track : Version 8.4
Language used for presentation : English

Introduction to Golconde

Golconde is a queue-based data distribution system

Event type : Lecture
Track : Scaling Out
Language used for presentation : English

Introduction to Recursive Queries

Recursion: see recursion

Event type : Lecture
Track : Version 8.4
Language used for presentation : English

Lightning talks

Short sharp descriptions of short topics

Event type : Lightning-Talk
Track : Community
Language used for presentation : English

No More Waiting

A Guide To PostgreSQL 8.4

Track : Version 8.4
Language used for presentation : English

OpenStreetMap with PostgreSQL

The free wiki world map & PostgreSQL

Event type : Lecture
Track : GIS
Language used for presentation : English

Opening Session

Welcome

Event type : Other
Track : Plenary
Language used for presentation : English

PGCon 2009 dinner

sponsored by EnterpriseDB

Event type : Other
Track : Social
Language used for presentation : English

Performance Whack-a-Mole II

The Moles Are Back, and Bigger Than Ever

Event type : Other
Track : Tutorial
Language used for presentation : English

Post Facto, version control for PostgreSQL

Event type : Lecture
Track : DBA
Language used for presentation : English

PostgreSQL 8.4Beta Vs PostgreSQL 8.3

A view from the Performance world

Event type : Lecture
Track : Version 8.4
Language used for presentation : English

PostgreSQL Access Controls (AuthN, AuthZ, Perms)

Controlling Access to your database- Roles; Kerberos, LDAP integration; Database, Schema, Table, and Column-level(!) permissions

Event type : Other
Track : Tutorial
Language used for presentation : English

PostgreSQL Unit Testing

A BOF

Event type : Workshop
Track : BOF
Language used for presentation : English

PostgreSQL and Temporal Data

Event type : Lecture
Track : Advanced Features
Language used for presentation : English

Power psql

All about everyone's favorite utility

Event type : Lecture
Track : DBA
Language used for presentation : English

Predicting Postgres Performance

Practical Queueing Theory for Postgres DBAs

Event type : Lecture
Track : Performance
Language used for presentation : English

Pub Night!

Last chance for social intercourse before the Touristy stuff tomorrow

Event type : Other
Track : Social
Language used for presentation : English

Reconciling and comparing databases

Using schemas, Slony, DBI-link, pgTAP and other tools to compare different databases

Event type : Lecture
Track : DBA
Language used for presentation : English

Registration pickup

The social way to register: at the pub

Event type : Other
Track : Social
Language used for presentation : English

SQL/MED

Doping for PostgreSQL

Event type : Lecture
Track : Version 8.4
Language used for presentation : English

Saving the Amazon with PostGIS

Spatial Manipulation in the Rain Forest

Event type : Lecture
Track : GIS
Language used for presentation : English

SkyTools3: Replication (Londiste3)

Overview of Londiste and what's new in version 3

Event type : Lecture
Track : Scaling Out
Language used for presentation : English

SkyTools: Queues (PgQ)

Event type : Other
Track : Tutorial
Language used for presentation : English

Solid State Drives

A BOF

Event type : Workshop
Track : BOF
Language used for presentation : English

Some recent advances in full-text search

Event type : Lecture
Track : Advanced Features
Language used for presentation : English

Spatial Analysis with PostGIS

Event type : Lecture
Track : GIS
Language used for presentation : English

The Lives of Others

Open-Source Development Practices Elsewhere

Event type : Lecture
Track : Community
Language used for presentation : English

The design, architecture, and tradeoffs of FluidDB

The database with the heart of a wiki.

Event type : Lecture
Track : Case Studies
Language used for presentation : English

Tourist Time

See the sights in and/or around Ottawa

Event type : Other
Track : Social
Language used for presentation : English

Unit Test Your Database!

Use a flexible database unit testing framework to assure database integrity and functionality

Event type : Lecture
Track : DBA
Language used for presentation : English

Upgrade Melee

A free-for-all on PostgreSQL's biggest remaining problem

Event type : Meeting
Track : Hacking
Language used for presentation : English

VACUUM Strategy

Autovacuum, FSM, Visibility Map

Event type : Lecture
Track : Version 8.4
Language used for presentation : English

Visualizing Postgres

Event type : Lecture
Track : DBA
Language used for presentation : English

Writing a Procedural Language

I CAN HAZ P.L.Z PLZ?

Event type : Other
Track : Tutorial
Language used for presentation : English

pg_similarity

Functions and Operators for Executing Similarity Queries

Event type : Lecture
Track : Advanced Features
Language used for presentation : English