From: | Tulio <tulio(at)informidia(dot)com(dot)br> |
---|---|
To: | fabriziomello(at)gmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: parameter "vacuum_defer_cleanup_age" |
Date: | 2012-01-31 15:10:36 |
Message-ID: | 4F28046C.1080809@informidia.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 tulio(at)informidia(dot)com(dot)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: tulio(at)informidia(dot)com(dot)br
twitter: @informidia
Web: www.informidia.com.br
Antes de imprimir lembre-se de sua responsabilidade e comprometimento com o Meio Ambiente
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2012-01-31 15:54:28 | Re: [GENERAL] pg_dump -s dumps data?! |
Previous Message | Merlin Moncure | 2012-01-31 15:06:25 | Re: Index on parent/child hierarchy |