Re: Manual Vacuum Analyze Take More Time

Ron <ronljohnsonjr@xxxxxxxxx> · Wed, 28 Nov 2018 08:55:17 -0600



    On 11/28/2018 08:22 AM, Moin Akther wrote:

    
      Dear All,
      

      While
            running Manual “VACUUM ANALYZE” on table size of 1.2TB, its
            running more than 1 Hour and generated almost 15K WAL files
            and due to this we have faced huge replication lag on our
            standby db.
      

      I have
            maitenance_work_mem of 6GB
              and RAM Size of 128GB.
      

      There
              is no lock and blocking queries at that time and CPU and
              memory utilization also normal.
      

      How we can fix this issue ?
    
    
    Not an answer to your question, but you should really think about
    partitioning that table.

    
    -- 

      Angular momentum makes the world go 'round.