Обсуждение: parameter "vacuum_defer_cleanup_age"
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. Thanks -- <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="2"> <img style="width: 139px; height: 75px;" alt="" src="cid:part1.03010107.08090502@informidia.com.br"> <span style="font-weight: bold;">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@informidia.com.br twitter: <a href="mailto:www.twitter.com/informidia.com.br">@informidia Web: www.informidia.com.br <span style="font-size:8.0pt;font-family:Tahoma; color:green">Antes de imprimir lembre-se de sua responsabilidade e comprometimento com o Meio Ambiente
2012/1/30 Tulio <tulio@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.
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
<meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"> 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: <blockquote cite="mid:CAFcNs+ok8ZJEatZRWd6Mo6m0JufDpPmsNa6ZBExicm8go9-jEg@mail.gmail.com" type="cite"> 2012/1/30 Tulio <<a moz-do-not-send="true" href="mailto:tulio@informidia.com.br">tulio@informidia.com.br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> 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" ?<br clear="all"> -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Blog sobre TI: <a moz-do-not-send="true" href="http://fabriziomello.blogspot.com" target="_blank">http://fabriziomello.blogspot.com >> Perfil Linkedin: <a moz-do-not-send="true" href="http://br.linkedin.com/in/fabriziomello" target="_blank">http://br.linkedin.com/in/fabriziomello >> Twitter: <a moz-do-not-send="true" href="http://twitter.com/fabriziomello" target="_blank">http://twitter.com/fabriziomello -- <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="2"> <img style="width: 139px; height: 75px;" alt="" src="cid:part1.00060209.04040305@informidia.com.br"> <span style="font-weight: bold;">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@informidia.com.br twitter: <a href="mailto:www.twitter.com/informidia.com.br">@informidia Web: www.informidia.com.br <span style="font-size:8.0pt;font-family:Tahoma; color:green">Antes de imprimir lembre-se de sua responsabilidade e comprometimento com o Meio Ambiente
On Mon, Jan 30, 2012 at 20:55, Tulio <tulio@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
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: <blockquote cite="mid:CABRT9RC=XoYRx=eHtkAYSxAGesU_hKGAORCzZV1WbqkGfOmYWw@mail.gmail.com" type="cite"> On Mon, Jan 30, 2012 at 20:55, Tulio <tulio@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