Re: Huge archive log generate in Postgresql-13

Mladen Gogala <gogala.mladen@xxxxxxxxx> · Mon, 18 Apr 2022 07:43:39 -0400



    On 4/18/22 07:34, Ram Pratap Maurya
      wrote:

    
        Hi Support,
         
        We have upgraded postgresql DB from version
          11 to 13 .  after upgrade to 13  huge archive log generate in
          system .
        Before upgrade  per day 120GB to 150 GB log
          generated but after upgrade per day approx. 250 to 300 GB log
          generated.
        Can you please suggest why huge archive log
          generated after upgrade  there any configure setting or this
          is Postgresql-13 behaviour.
          
         
        Postgresql-13 Postgresql conf file attached
          for your references.
         
         
        Regards,
        Ram
            Pratap.
         
      
    Have you checked what's in those WAL archives? You can do that
      with pg_waldump. My guess would be that your vacuum is probably
      more active than in the version 11. However, that's just a guess.
      You can also turn on WAL compression. Be aware that compression
      will reduce disk consumption at the expense of CPU consumption.
    Regards

    
    -- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com