<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