Get materialized views details Select shcmename,matviewname,matviewowner from pg_matviews; --Raju From: Wells Oliver <wells.oliver@xxxxxxxxx> Apologies for the daft question, but I am surprised to see materialized views show up in pg_stat_user_tables with lots of dead tuples. These are rematerialized nightly and, I thought, this had the effect of replacing/recreating them anew. Can someone shed some light on this? -- Wells Oliver |
