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 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 value to > "vacuum_

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

Re: [GENERAL] parameter "vacuum_defer_cleanup_age"

2012-01-30 Thread Fabrízio de Royes Mello
2012/1/30 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 > "vacuum_defer_cleanup_a

[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 "vacuum_d