Scaling servers with Skytools

A session at Postgres Open 2011

There are many strategies in scaling PostgreSQL infrastructure. Using Skytools, a set of technologies developed by Skype, Postgres can scale easily both horizontally and vertically. Learn in a hands on tutorial on how pgBouncer can be a significant boost to PostgreSQL performance and how to horizontally scale your PostgreSQL data with plProxy.

Skytools includes a variety of tools useful for scaling large PostgreSQL sites. The pgBouncer connection pooler allows incoming database load to be carefully controlled, as well as adding features for easier management of 24x7 availability. And the Skytools pl/Proxy language allows horizontal partitioning of data by ID across multiple servers, allowing a sharding style approach to scaling PostgreSQL. Learn how these tools have been used to scale upwards a PostgreSQL backed web site supporting billions of page views per month.

About the speaker

This person is speaking at this event.
Gavin M. Roy

VP of Architecture @AWeber. Technology-minded geek who enjoys Python & Erlang, music and gaming. Author of RabbitMQ in Depth. bio from Twitter

Coverage of this session

Sign in to add slides, notes or videos to this session

Tell your friends!

View the schedule



See something wrong?

Report an issue with this session