postgresql - 如何在 postgreSQL 中实现物化视图的 MVCC 概念？

Question

create materialized view mtview
as 
select * from table_name
with no data;

refresh materialized view mtview;

create or replace function refresh_mat_view()
returns trigger language plpgsql
as $$
begin
     refresh materialized view mtview
      return null;
end $$;


create trigger refresh_mat_view
after insert or update or delete or truncate
on table_name for each statement
execute procedure refresh_mat_view();

标签： postgresql