Re: parameter "vacuum_defer_cleanup_age"

Fabrízio de Royes Mello <fabriziomello@xxxxxxxxx> · Mon, 30 Jan 2012 22:12:40 -0200

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 MelloConsultoria/Coaching PostgreSQL

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