PGCon2009 - Final Release

PGCon 2009
The PostgreSQL Conference

Marko Kreen
Martin Pihlak
Day Tutorials - second day - 2009-05-20
Room DMS 1110
Start time 09:00
Duration 03:00
ID 138
Event type Other
Track Tutorial
Language used for presentation English

SkyTools: Queues (PgQ)

An introduction into PgQ and SkyTools - efficient queue implementation on top of PostgreSQL and the tools to manage it. Description of PgQ, the different kinds of consumers, queue applications and their usage scenarios and how to tie it all together with SkyTools.

SkyTools is a batch processing framework, initially developed at Skype to simplify the management of distributed databases. It's most prominent features are PgQ queuing and londiste replication system. SkyTools has been released to open source since 2007, and is now approaching release 3.0.

This presentation makes an introduction to PgQ - producing and consuming events, different consumer types, batch processing. Solving common problems with pre-packaged applications - replication, archiving and data loading. Writing custom queue applications with SkyTools framework. Other programming interfaces - SQL, Java, PHP.

We will also discuss upcoming features of SkyTools 3: distributed queues, cooperative consuming and cascaded consumers.