Re: [GENERAL] parameter "vacuum_defer_cleanup_age"

[Tulio]

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 <tu...@informidia.com.br> 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: tu...@informidia.com.br twitter: @informidia Web: www.informidia.com.br Antes de imprimir lembre-se de sua responsabilidade e comprometimento com o Meio Ambiente