Schedule - PGConf.EU 2013Using Postgres FDW w/ a sharded PostgreSQL Database
Date: 2013-11-01
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. SpeakerStephen Frost |