Re: [HACKERS] autovacuum workers warning

2011-10-26 Thread Tom Lane
Euler Taveira de Oliveira eu...@timbira.com writes: + if (!can_launch) + ereport(LOG, + (errmsg(maximum number of autovacuum workers reached), + errhint(Consider increasing

Re: [HACKERS] autovacuum workers warning

2011-10-26 Thread Alvaro Herrera
Excerpts from Euler Taveira de Oliveira's message of mar oct 25 16:56:12 -0300 2011: Hi, Some time ago [1], I proposed print a message every time there isn't autovacuum slots available and it asks for another one. It is not a complete solution for autovacuum tuning but it would at least

Re: [HACKERS] autovacuum workers warning

2011-10-26 Thread Euler Taveira de Oliveira
On 26-10-2011 16:14, Alvaro Herrera wrote: Well, just increasing the number of workers would do nothing to solve the problem, because the more workers there are, the slower they work. The actual solution to the problem would be decreasing autovacuum_vacuum_delay_cost, and/or related knobs. Why

Re: [HACKERS] autovacuum workers warning

2011-10-26 Thread Alvaro Herrera
Excerpts from Euler Taveira de Oliveira's message of miƩ oct 26 16:57:18 -0300 2011: On 26-10-2011 16:14, Alvaro Herrera wrote: Well, just increasing the number of workers would do nothing to solve the problem, because the more workers there are, the slower they work. The actual

Re: [HACKERS] autovacuum workers warning

2011-10-26 Thread Dickson S. Guedes
2011/10/26 Euler Taveira de Oliveira eu...@timbira.com: I'm not saying that is not the right direction, I'm arguing that a hint is better than nothing. Right now the only way to know if it is out of workers is to query pg_stat_activity frequently. The currently number of autovaccum workers