Re: Autovacuum after bulk data insert(millions!)

Thomas Markus <t.markus@xxxxxxxxxxxxx> · Tue, 17 Oct 2017 13:48:21 +0200



    Hi,

    
    Am 17.10.17 um 13:37 schrieb Günce
      Kaya:

    
      Hello Fabrízio,
        

        Thank you for your
          advice but I'm not asking for only a specific table and not
          looking for temporary solution. Previous post may not clear to
          much and I'd explain again. 
        

        So autovacuum
          process takes long time for that database. I don't know how
          can I estimate timing for a vacuum after insert millions of
          bulk data to a table. So there are many table inserting bulk
          data daily. This solution not for only a table. I'm looking a
          solution for a database. Data volume of this database is
          around 2GB so many transactions in a day. 
        

        This is only
          suggestion and I'm really curious because can not estimate
          what do you think about that, what if disable autovacuum and
          vacuum all tables in every month?
        

        Regards,
        Gunce
      
    
    works same for a database, so it depends on your usecase

    
    * disable autovacuum for instance

    * run 'vacuumdb -a -z' manually/in cron

    
    Regards

    Thomas