You can use https://github.com/twosigma/postgresql-contrib/blob/master/mat_views.sql https://github.com/twosigma/postgresql-contrib/blob/master/m... and write t

You can use https://github.com/twosigma/postgresql-contrib/blob/master/mat_views.sql https://github.com/twosigma/postgresql-contrib/blob/master/m... and write triggers to update your views or mark them as needing asynchronous refreshes. It's not as automatic as what you'd like, but it's a lot better than having to keep waiting.