PostgreSQL 12 High Availability Cookbook - Third Edition

There's more...

As powerful as this technique might be, its utility is limited by the fact that we're using views to circumvent normal table access methods. This means that our foreign table now has the same limitations as views. Unless the view is very simple—which would defeat the purpose of using a view like this—we cannot perform any of the following actions:

• We cannot insert into a foreign table view
• We cannot update records in a foreign table view
• We cannot delete from a foreign table view

However, there is one thing that we can do with a foreign table view that we can't do with a local view. As foreign tables can be analyzed to gather statistics, we can analyze foreign table views as well. This produces local statistics that may ...