TIL3 postgresql - relispopulated SELECT relispopulated FROM pg_class WHERE relname = 'table_name'; 테이블에 데이터 있는지 bool 으로 표현 2022. 5. 20. postgresql - REFRESH MATERIALIZED VIEW REFRESH MATERIALIZED VIEW name [ WITH [ NO ] DATA ] Parameters CONCURRENTLY Refresh the materialized view without locking out concurrent selects on the materialized view. Without this option a refresh which affects a lot of rows will tend to use fewer resources and complete more quickly, but could block other connections which are trying to read from the materialized view. This option may be fas.. 2022. 5. 20. es module commonJS node.js 표준 es module 2022. 5. 18. 이전 1 다음