> are FDW's a reasonable way to migrate data between databases? As I was trying to find a reference to when SQL Anywhere introduced proxy tables, I came across

> are FDW's a reasonable way to migrate data between databases? As I was trying to find a reference to when SQL Anywhere introduced proxy tables, I came across a post [1] that discussed the speed improvement in proxy table bulk loads introduced in SQL Anywhere 11. It is reasonable to do the same with PostgreSQL's FDWs if the underlying query optimizer detects when a bulk load technique should be used. Sounds like a good experiment to run. [1] http://sqlanywhere.blogspot.com/2010/01/omigosh-proxy-tables-are-fast.html http://sqlanywhere.blogspot.com/2010/01/omigosh-proxy-tables...