Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Closed
jmealo opened this issue Dec 9, 2015 · 1 comment
Closed

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

jmealo opened this issue Dec 9, 2015 · 1 comment

Comments

@jmealo
Copy link
Collaborator

jmealo commented Dec 9, 2015

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
Copy link
Collaborator Author

jmealo commented Jul 26, 2016 •
edited
Loading

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.

@jmealo jmealo closed this as completed Jul 26, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@jmealo