Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sJmrt-006iId-4j for pgsql-admin@arkaria.postgresql.org; Wed, 19 Jun 2024 04:24:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sJmrp-008rkD-SN for pgsql-admin@arkaria.postgresql.org; Wed, 19 Jun 2024 04:24:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sJmrp-008rk5-H6 for pgsql-admin@lists.postgresql.org; Wed, 19 Jun 2024 04:24:18 +0000 Received: from cloud.gatewaynet.com ([185.90.37.94]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sJmro-002OR8-50 for pgsql-admin@lists.postgresql.org; Wed, 19 Jun 2024 04:24:17 +0000 Content-Type: multipart/alternative; boundary="------------kC9IUBcusSKiBaj063Ed0lRV" Message-ID: Date: Wed, 19 Jun 2024 07:24:10 +0300 MIME-Version: 1.0 Subject: Re: Materialized views & dead tuples To: pgsql-admin@lists.postgresql.org References: Content-Language: en-US From: Achilleas Mantzios In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------kC9IUBcusSKiBaj063Ed0lRV Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Στις 19/6/24 01:28, ο/η Wells Oliver έγραψε: > 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? MVs they are just ordinary tables with the addition of having a definition, and not being able to be directly manipulated. They can be bloated just like normal tables, so they need the classic maintenance. > > -- > Wells Oliver > wells.oliver@gmail.com -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only) --------------kC9IUBcusSKiBaj063Ed0lRV Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
Στις 19/6/24 01:28, ο/η Wells Oliver έγραψε:
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?
MVs they are just ordinary tables with the addition of having a definition, and not being able to be directly manipulated. They can be bloated just like normal tables, so they need the classic maintenance.

-- 
-- 
Achilleas Mantzios
 IT DEV - HEAD
 IT DEPT
 Dynacom Tankers Mgmt (as agents only)
--------------kC9IUBcusSKiBaj063Ed0lRV--