parameter "vacuum_defer_cleanup_age"

[Tulio <tulio@xxxxxxxxxxxxxxxxx>]

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

--

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@xxxxxxxxxxxxxxxxx twitter: @informidia Web: www.informidia.com.br

Antes de imprimir lembre-se de sua responsabilidade e comprometimento com o Meio Ambiente