[dbnewbie]

OK that makes sense, and I’ll do a bit of reading on materialized view functionality before actually implementing anything.

[gigatexal]

Again not my idea. It was suggested to me in response to the very problem you’re having. I’m just so happy to have it as an idea that I didn’t want to keep it to myself. Here’s the link. https://hashrocket.com/blog/posts/materialized-view-strategi...

[gigatexal]

I have a link somewhere I’ll find it