As to the first question -- I haven't done it, but have you tried materialized views? EDIT: You've probably already tried that if you're following the docs, si

As to the first question -- I haven't done it, but have you tried materialized views? EDIT: You've probably already tried that if you're following the docs, since they recommend it -- https://www.postgresql.org/docs/current/rules-materializedviews.html https://www.postgresql.org/docs/current/rules-materializedvi...