Excerpts from Alvaro Herrera's message of lun ago 16 16:58:31 -0400 2010: > I suspect that the problem may lie in the "cost_delay rebalance" code in > autovacuum.
Hmm, so we have this code: void AutoVacuumUpdateDelay(void) { if (MyWorkerInfo) { VacuumCostDelay = MyWorkerInfo->wi_cost_delay; VacuumCostLimit = MyWorkerInfo->wi_cost_limit; } } where the MyWorkerInfo bits come from shared memory and can be modified by other autovac worker processes. We could read an incomplete value into our variables. But this only makes sense if an "int" variable can be subject to a partial read/write, which we already assume not to be so (c.f. GetNewTransactionId). In any case, if you happen to see this reoccur, could you please attach GDB to the misbehaving worker and see what VacuumCostDelay and VacuumCostLimit print out as? -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers