Re: parameter "vacuum_defer_cleanup_age"

Tulio <tulio@xxxxxxxxxxxxxxxxx> · Tue, 31 Jan 2012 13:10:36 -0200



    Fabrizio,

    
    I'm using the value default..

    The situation was when I executed some query large in the server
    Slave, because I'm trying do balancement of charge.

    
    Somebody could help me to solve this problem?

    
    System: CentOS 

    Postgresql version:  9.1

    
    Em 30/01/2012 22:12, Fabrízio de Royes Mello escreveu:
    

      2012/1/30 Tulio <tulio@xxxxxxxxxxxxxxxxx>

        
           Hi,

            
            I have 2 servers, working with Hot-Standby and Streaming
            Replication...

            and when we executed some query much large returns a
            message.. 

            "canceling statement due to statement
              timeout"

              I want know, how can I calculate the better value to
              "vacuum_defer_cleanup_age" in my case? 

              
              Tell me if you recommend changes in other parameter.

              
      Which the value of the parameter "statement_timeout" ?

      
      -- 

      Fabrízio de Royes Mello
      Consultoria/Coaching PostgreSQL

        >> Blog sobre TI: http://fabriziomello.blogspot.com
        >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
        >> Twitter: http://twitter.com/fabriziomello
      
      
    -- 

      
            Túlio Gustavo dos Santos

                Adm. Téc. em Banco de Dados - TI

                Informídia Pesquisas Esportivas Ltda.

                Tel./Fax.: 55 11 3673 5566

                Email: tulio@xxxxxxxxxxxxxxxxx

                twitter: @informidia

                Web: www.informidia.com.br
          
        
      Antes de imprimir lembre-se de sua responsabilidade
        e comprometimento com o Meio Ambiente