agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: lennam@incisivetechgroup.com
To: 'Wells Oliver' <wells.oliver@gmail.com>
To: 'pgsql-admin' <pgsql-admin@postgresql.org>
Subject: RE: Materialized views & dead tuples
Date: Tue, 18 Jun 2024 18:38:03 -0400
Message-ID: <004d01dac1d0$2ee1a8b0$8ca4fa10$@incisivetechgroup.com> (raw)
In-Reply-To: <CAOC+FBU1d_VXbWsx6fNXaANQCKD0SRLB4Tupm4dC-7JiU5rdhg@mail.gmail.com>
References: <CAOC+FBU1d_VXbWsx6fNXaANQCKD0SRLB4Tupm4dC-7JiU5rdhg@mail.gmail.com>
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?
--
Wells Oliver
wells.oliver@gmail.com <mailto:wellsoliver@gmail.com>
view thread (5+ messages) latest in thread
Message-ID: <004d01dac1d0$2ee1a8b0$8ca4fa10$@incisivetechgroup.com>
Permalink: ../004d01dac1d0$2ee1a8b0$8ca4fa10$@incisivetechgroup.com/
Also on: postgresql.org/message-id/004d01dac1d0$2ee1a8b0$8ca4fa10$@incisivetechgroup.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lennam@incisivetechgroup.com, wells.oliver@gmail.com
Subject: RE: Materialized views & dead tuples
In-Reply-To: <004d01dac1d0$2ee1a8b0$8ca4fa10$@incisivetechgroup.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox