Re: Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples?

Fabio Pardi <f.pardi@xxxxxxxxxxxx> · Wed, 18 Jul 2018 12:32:45 +0200



    Hi Raghavendra
    

    answers in line here below:

    
    On 18/07/18 11:13, Raghavendra Rao J S
      V wrote:

    
        We have thousands of
          tables. But out of those tables, around 20 to 40 tables are
          always busy due to that those tables are bloating.
        

        In order to avoid this
          we are running a shell script which performs vacuum full on
          the tables which has more than ten thousand dead tuples. While
          running this we are stopping all application processors and
          running vacuum full on the tables which has more dead tuples.
        

            Is it ok to run vacuum
                full verbose command for live database for the
              tables which has more dead tuples(greater than)?
          
        
    nope

    
            Does it cause any adverse effect?

            
    exclusively locks the
    table. Recipe for disaster.

    
    What's wrong with the normal operations of autovacuum?

    
    regards,

    
    fabio pardi

    
        Please clarify me.
          Thanks in advance.
        

        -- 

        
          Regards,

            Raghavendra Rao J S V