Re: [GENERAL] parameter vacuum_defer_cleanup_age
Hi Marti, The parameter statement_timeout isn't configured.. I'm using the value default.. 0.. And this is happening when I'm doing large querys on the slave.. thanks, Tulio Em 01/02/2012 12:33, Marti Raudsepp escreveu: On Mon, Jan 30, 2012 at 20:55, Tulio tu...@informidia.com.br wrote: 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? This error doesn't happen due to recovery conflict, so vacuum_defer_cleanup_age doesn't make any difference. The error happens because the statement_timeout setting is configured somewhere (maybe per-database or per-user settings). Set it to 0 to disable the statement timeout. Regards, Marti
Re: [GENERAL] parameter vacuum_defer_cleanup_age
On Mon, Jan 30, 2012 at 20:55, Tulio tu...@informidia.com.br wrote: 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? This error doesn't happen due to recovery conflict, so vacuum_defer_cleanup_age doesn't make any difference. The error happens because the statement_timeout setting is configured somewhere (maybe per-database or per-user settings). Set it to 0 to disable the statement timeout. Regards, Marti -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] parameter vacuum_defer_cleanup_age
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, Fabrzio 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" ? -- Fabrzio 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 -- Tlio Gustavo dos Santos Adm. Tc. em Banco de Dados - TI Informdia 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
Re: [GENERAL] parameter vacuum_defer_cleanup_age
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
