> materialized view that includes a ROW_NUMBER() or RANK() function That won't work, as the materialized view's query is applied per inserted chunk, i.e. to ea

> materialized view that includes a ROW_NUMBER() or RANK() function That won't work, as the materialized view's query is applied per inserted chunk, i.e. to each row separately in the most extreme cases.