| From: | <lennam(at)incisivetechgroup(dot)com> |
|---|---|
| To: | "'Wells Oliver'" <wells(dot)oliver(at)gmail(dot)com>, "'pgsql-admin'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | RE: Materialized views & dead tuples |
| Date: | 2024-06-18 22:38:03 |
| Message-ID: | 004d01dac1d0$2ee1a8b0$8ca4fa10$@incisivetechgroup.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Get materialized views details
Select shcmename,matviewname,matviewowner from pg_matviews;
--Raju
From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Sent: Tuesday, June 18, 2024 6:29 PM
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Materialized views & dead tuples
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
wells(dot)oliver(at)gmail(dot)com <mailto:wellsoliver(at)gmail(dot)com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2024-06-18 23:45:55 | Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER |
| Previous Message | Wells Oliver | 2024-06-18 22:28:53 | Materialized views & dead tuples |