Re: 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, 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