Re: Autovacuum Problem

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Tue, 3 Apr 2018 11:39:12 +0300



    On 03/04/2018 10:54, Kein Name wrote:

    
            > Why would you want that? Do you have any control
              over the application? Any "special" patterns used in the
              app?

              
            Drive is running full :/

          
          Sadly I have no control and knowledge whatsoever over/about
          the application.

          
        I tuned the autovacuum parameters now for the critical tables,
        to have it run more often and using greater ressources while
        doing so.... but I am unsure if this helps with the bloating.

      
    You could try to setting log_statement=all for a (short) period with
    a typical "heavy-ish" write activity to know what the app is doing.

    IMHO you must prepare for a larger storage. After that you should
    monitor disk usage periodically to see if usage is stabilized or at
    least if the increase rate drops.

    
        2018-04-03 9:39 GMT+02:00 Achilleas
          Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx>:

          
                On
                  03/04/2018 10:00, Kein Name wrote:

                
                    > VACUUM <> VACUUM FULL

                      > Normally running VACUUM via autovacuum should
                      help reuse free space but not actually return it
                      to the filesystem / OS (unless it happens to be
                      the last blocks in the data file(s)).

                      > Ppl in normal/average type of
                      installations/workloads no longer (since 8.2) run
                      VACUUM (or VACUUM FULL) by hand, except in extra
                      ordinary cases where e.g. need for free space is
                      urgent.

                      
                    Hmmmm then when is the space released to the system
                    when the manual VACUUM FULL run is not done? Any way
                    to "force" this?

                  
               Why would you want that? Do you have any control
              over the application? Any "special" patterns used in the
              app?

                
                    2018-04-03 8:49 GMT+02:00
                      Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx>:

                      On 03/04/2018
                          09:36, Kein Name wrote:

                           However no
                            space seems to be freed to the system.

                            
                            Is there any way a bloody newbie can debug
                            this behaviour?

                          
                         VACUUM <> VACUUM FULL

                        Normally running VACUUM via autovacuum should
                        help reuse free space but not actually return it
                        to the filesystem / OS (unless it happens to be
                        the last blocks in the data file(s)).

                        Ppl in normal/average type of
                        installations/workloads no longer (since 8.2)
                        run VACUUM (or VACUUM FULL) by hand, except in
                        extra ordinary cases where e.g. need for free
                        space is urgent.
                        
                          
                             Any help is
                              appreciated!

                              
                              Thanks

                              Stefan

                              
                         -- 

                            Achilleas Mantzios

                            IT DEV Lead

                            IT DEPT

                            Dynacom Tankers Mgmt

                            
                -- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
              
          
    -- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt