search

JarvusInnovations / lapidus

Stream your PostgreSQL, MySQL or MongoDB databases anywhere, fast.
MIT License
171 stars 23 forks source link

Materialized view refresh example (MySQL -> PostgreSQL) #6

Closed jmealo closed 8 years ago

jmealo commented 8 years ago

Provide an example showing how to use Lapidus to refresh a PostgreSQL materialized view backed by a mysql_fdw foreign table when a change occurs in the backing table in MySQL.

jmealo commented 8 years ago

This pattern creates too much churn and exposed a nasty bug with toast and non-toast tuples in PG core that we're not really too sure about. I do not want to provide a harmful example.