Columns and Clouds - Hybrid databases
Faster queries, smaller data, and elastic archive for large databases using FDWs
Dave is the VP of Engineering for OpenSCG and the BigSQL projects. He has over 20 years experience leading large scale technology and data analytics projects. Previously he was CTO for cloud Master Data Management provider MDX, Alliance Global Services and Fusion Technologies.
Dealing with a large database? Want your queries to run faster? How about saving space in large tables? What if you don't want to delete old history records - can you keep them in the cloud?
In this talk about using advanced Postgres features to create hybrid databases we'll show how to use partitioning and Foreign Data Wrappers (FDW) to speed up queries, make your database smaller and stretch your on-premise database to the cloud.
- 50 min
- PGConf US 2017 [PgConf.US]