Re: Materialized views & dead tuples

Achilleas Mantzios <a.mantzios@xxxxxxxxxxxxxxxxxxxx> · Wed, 19 Jun 2024 07:24:10 +0300



    Στις 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@xxxxxxxxx
          
        
    -- 
Achilleas Mantzios
 IT DEV - HEAD
 IT DEPT
 Dynacom Tankers Mgmt (as agents only)