Schedule - PGConf.EU 2013

Using Postgres FDW w/ a sharded PostgreSQL Database

Date: 2013-11-01
Time: 10:50–11:40
Room: Earlsfort
Level: Intermediate

PostgreSQL 9.3 will be the first PG major release to include an in-core Foreign Data Wrapper for talking to other PostgreSQL databases- and it supports writing to those databases through the FDW. This talk will discuss how to set up and use the Postgres FDW with a 32-way sharded PostgreSQL database and go over pros, cons, and limitations.

Once you've gone beyond being able to (reasonably) acquire single-image (single-system) hardware for your master server, it's time to shift to a sharded database- but how do you manage and deal with all of those shards? We'll talk about how you can use the Postgres FDW to bring all those shards back together- where it works and where it doesn't, and discuss the possible future for the Postgres FDW and how it might be changed to work better.

Speaker

Stephen Frost

Platinum Sponsors

2ndQuadrant
EnterpriseDB

Gold Sponsors

Cybertec
Heroku

Silver Sponsors

Dalibo
Gilt
VMware
Zalando
EngineYard
Servoy
Vertabelo