Re: [GENERAL] parameter vacuum_defer_cleanup_age

2012-02-02 Thread Tulio
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: On Mon, Jan

Re: [GENERAL] parameter vacuum_defer_cleanup_age

2012-02-01 Thread Marti Raudsepp
On Mon, Jan 30, 2012 at 20:55, Tulio tu...@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

Re: [GENERAL] parameter vacuum_defer_cleanup_age

2012-01-31 Thread Tulio
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

[GENERAL] parameter vacuum_defer_cleanup_age

2012-01-30 Thread Tulio
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

Re: [GENERAL] parameter vacuum_defer_cleanup_age

2012-01-30 Thread Fabrízio de Royes Mello
2012/1/30 Tulio tu...@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