Re: materialized view refresh of a foreign table

2019-06-25 Thread Rick Otten
On Sun, Jun 23, 2019 at 10:21 AM Rick Otten wrote: > I'm not sure where else to look, so I'm asking here for tips. > > I have a table in a remote (Heroku-managed) postgresql database (PG 10.7). > > On the other end, (PG 11.3) I have a foreign table configured with a > materialized view in front

materialized view refresh of a foreign table

2019-06-23 Thread Rick Otten
I'm not sure where else to look, so I'm asking here for tips. I have a table in a remote (Heroku-managed) postgresql database (PG 10.7). On the other end, (PG 11.3) I have a foreign table configured with a materialized view in front of it. Up until Thursday evening, it was taking about 12 - 15