PGCon2008 - Final - we hope

PGCon 2008
The PostgreSQL Conference

Asko Oja
Day Talks - second day (2008-05-23)
Room B
Start time 13:30
Duration 01:00
ID 78
Event type lecture
Track Horizontal Scaling
Language en

plProxy, pgBouncer, pgBalancer

Paritioning databases and using remote calls

There are several ways how plProxy can be useful in case of large sets of online data. It was designed for partitioning databases but now we have taken it into use also for remote calls. pgBouncer is natural part of plProxy installations.

I would like to describe some growth paths for a company and its databases. In the beginning it's usual to have one server and one database. Depending on success you may end up with any number of database servers. Load balancing with pgBalancer, pgBouncer and plProxy Using plProxy for remote calls Using plProxy for Partitoning