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

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 19 Jul 2018 10:06:28 -0500



    On 07/19/2018 06:00 AM, Raghavendra Rao J S V wrote:

    
        Please find my inline
          comments.
        

          On 18 July 2018 at 18:48, Adrian
            Klaver <adrian.klaver@xxxxxxxxxxx>
            wrote:

            On
                07/18/2018 02:13 AM, 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.

                
              Define bloating?

                
                    Table contains more dead tuples more than 5000
                    records. Sometimes few tables may contains 50million
                    records and size also in GB's. Refer below screen
                    print.
                
              
    When's your maintenance window?

    
    -- 

      Angular momentum makes the world go 'round.