▲ | rapind 8 days ago | |
You can do targeted materialized view updates via triggers. It's definitely verbose but does give you a lot of control. I'm currently parking PostgREST behind Fastly (varnish) for pretty much the same benefits plus edge CDNs for my read APIs. I really just use materialized views for report generation now. |