How to run queries from a function in parallel in Postgresql?

Question

PostgreSQL

There are materialized views in postgres. There is a procedure:

FOR r IN SELECT matviewname FROM pg_matviews
    LOOP
        EXECUTE 'REFRESH MATERIALIZED VIEW ' || schema_arg || '.' || r.matviewname;
    END LOOP;

which takes the titles from pg_matviews and calls them with EXECUTE refresh. Is it possible to run these updates at once in parallel instead of one by one?

Answer 1

Your disk slows down, not the processor, how do you plan to parallelize the disk?