Postgres Pro
Downloads
Home   >   mailing lists

RE: Materialized views & dead tuples - Mailing list pgsql-admin

From
Subject RE: Materialized views & dead tuples
Date
Msg-id 004d01dac1d0$2ee1a8b0$8ca4fa10$@incisivetechgroup.com
Whole thread Raw
In response to Materialized views & dead tuples  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view

Get materialized views details

 

Select shcmename,matviewname,matviewowner from pg_matviews;

 

--Raju

 

From: Wells Oliver <wells.oliver@gmail.com>
Sent: Tuesday, June 18, 2024 6:29 PM
To: pgsql-admin <pgsql-admin@postgresql.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?

 

--

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Materialized views & dead tuples
Next
From: "David G. Johnston"
Date:
Subject: Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER