Talk by Gabrielle Roth
https://www.socallinuxexpo.org/scale/...
If you're managing multiple datastores and want to Just Use Postgres, foreign data wrappers are a good option. There are loads of them available, for nearly every datastore you can think of, and you can write your own if you can't find what you're looking for.This mostly-demo talk showcases file_fdw, which allows you to query local resources from your database, and postgres_fdw, which allows you to query other postgres databases. I'll cover use (and mis-use) cases, configuration of each, and interesting quirks.