Alvaro Herrera wrote:
> Stefan Kaltenbrunner wrote:
>> I'm still getting random failures from some of my buildfarm members
>> which is starting to get a bit irritating and annoying :-(
>> some recent failures:
>> any ideas ?
> Since they are sporadic, my guess is that it's due to autovacuum not
> letting pgstat catch up. I'd try either setting
> autovacuum_vacuum_cost_delay to a low value, or extending the sleep
> period in the stats test, to give more time for pgstat to catch up with
> those messages.
hmm now that I look closer - all those members above are actually VMs of
some sort and the host is rather busy at times (multiple VMs competing
for CPU and IO) so that might be a factor here.
> Setting the cost_delay sounds a reasonable thing to do anyway, and in
> fact I already proposed it and nobody objected (AFAIR). Now we only
> have to agree on a reasonable value.
note sure on a reasonable value but we still have time to test different
values if needed for 8.3 - but I think we should really try to get rid
of those sporadic failures because they might lead to getting other
issues going unnoticed.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at