Here's a nice writeup of Materialize: https://lucperkins.dev/blog/new-db-tech-1/#materialize https://lucperkins.dev/blog/new-db-tech-1/#materialize Not really

Here's a nice writeup of Materialize: https://lucperkins.dev/blog/new-db-tech-1/#materialize https://lucperkins.dev/blog/new-db-tech-1/#materialize Not really mentioned here, but in standard postgres it might be quite expensive to update the view so you can only do it periodically. Materialize keeps that up-to-date continuously.