PgSQL——使用觸發器自動重新整理物化視圖

前言

普通視圖就是一個虛拟表，不占​​記憶體​​。而物化視圖是存在的，占記憶體。

物化視圖，預設是手動重新整理。下面是手動重新整理的例子。我們來建立一個物化視圖。

Step1 建立函數重新整理視圖

create or replace function tri_refresh_ydpf_func() returns trigger as $$ 
declare
begin 
  refresh materialized view mv_ydsjpf with data; 
  refresh materialized view mv_ydejpf with data; 
  refresh materialized view mv_ydyjpf with data; 
  refresh materialized view mv_ydzpf with data; 
  return null; 
end; 
$$ language plpgsql;      

Step2 建立觸發器

create trigger tri_refresh_ydpf
after insert or update or delete on tyzk_point_report
for each statement 
execute procedure tri_refresh_ydpf_func();