PGCon2010 - Final Release

PGCon 2010
The PostgreSQL Conference

Event Speakers

2 years of londiste

PostgreSQL usage at Hi-Media

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

Application-level Authorization via SET ROLE

Working around connection pooling for permissions

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

Built-in replication in PostgreSQL 9.0

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

Check Please!

What Your Postgres Databases Wishes You Would Monitor

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

Closing sessions

prizes, auctions, fun, games

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

Cluster-Hackers BOF

cluster like you mean it

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

Efficient k-nn search with GiST and other development

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

Exposing PostgreSQL Internals with User-Defined Functions

Easing into PostgreSQL Hacking

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

Forensic Analysis of Corrupted Databases

What to do when things really hit the fan

Event type : Lecture
Track : DBA

Hypothetical Indexes towards self-tuning in PostgreSQL

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

LAPP/SELinux

A secure web-application stack using SE-PostgreSQL

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

Lightning talks

Short sharp descriptions of short topics

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

Monitoring PostgreSQL Buffer Cache Internals

Watching disk caching inside the database

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

No More Waiting

A Guide To PostgreSQL 9.0

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

Not Just UNIQUE

Exclusion Constraints

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

Online financial services & Postgres

Staking our claim on open source technologies

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

PGCon 2010 Major Social Event!

sponsored by EnterpriseDB

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

PL/Parrot

Yep, there's actually code now!

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

PL/Perl - new features in 9.0

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

Perspectives on NoSQL

What NoSQL means to PostgreSQL and why PostgreSQL is YesQL.

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

PgFincore and the OS Page Cache

Is my table in memory ?

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

PgMQ

PgMQ: Embedding messaging in PostgreSQL

Track : Advanced Features
Language used for presentation : English

PostgreSQL Access Controls (AuthN, AuthZ, Perms)

Controlling Access to your database- Roles; Kerberos, LDAP, SSL, RADIUS(!); Database Permissions

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

PostgreSQL as a secret weapon for high-performance Ruby on Rails applications

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

PostgreSQL in Mission-Critical Financial Systems

Case study of PostgreSQL in the Multicanal project of the brazilian bank Caixa Economica Federal

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

Postgres for non-Postgres people

Getting to know the Postgres way

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

Postgres-XC, Write-scalable, synchronous multi-master PostgreSQL cluster with shared nothing approach

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

Probing PostgreSQL with DTrace and SystemTap

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

Realistic Load Testing

HOWTO set up a realistic testing environment using PostgreSQL Functions and Python

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

Reconciling and comparing databases redux

Deploying and testing triggers and functions in multiple databases

Event type : Lecture
Track : Case Studies
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

Replacing GEQO

Join ordering via Simulated Annealing

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

Replication Panel

Track : Scaling Out
Language used for presentation : English

Secure PostgreSQL Deployment

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

Server Health Check

Give your Postgres server a checkup

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

Testing BOF

Testing your database

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

The Illustrated Elephant

Literary modeling and automatic documentation in PostgreSQL

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

The PostgreSQL Query Planner

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

To ORM or not to ORM (that's the question)

Exploring both DBA's and programmers point-of-view

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

Tourist stuff

Spend some time exploring

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

Using Git to work with PostgreSQL

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

We have money, do you have the time?

How commercial companies can fund Postgres development.

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

pg_statsinfo

More useful statistics information for DBAs

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