X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A0396D1B443 for ; Thu, 4 Dec 2003 20:53:44 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 20708-05 for ; Thu, 4 Dec 2003 16:53:15 -0400 (AST) Received: from dezeut.zeut.net (ool-4352919e.dyn.optonline.net [67.82.145.158]) by svr1.postgresql.org (Postfix) with ESMTP id BBAB6D1B47A for ; Thu, 4 Dec 2003 16:52:57 -0400 (AST) Received: from dezeut.zeut.net (localhost.localdomain [127.0.0.1]) by dezeut.zeut.net (8.12.8/8.12.8) with ESMTP id hB4Kqp7N021686; Thu, 4 Dec 2003 15:52:51 -0500 Received: (from apache@localhost) by dezeut.zeut.net (8.12.8/8.12.8/Submit) id hB4KqpDP021684; Thu, 4 Dec 2003 15:52:51 -0500 X-Authentication-Warning: dezeut.zeut.net: apache set sender to matthew@zeut.net using -f Received: from 66.106.27.14 (SquirrelMail authenticated user dbmailtest) by matth.zeut.net with HTTP; Thu, 4 Dec 2003 15:52:51 -0500 (EST) Message-ID: <2348.66.106.27.14.1070571171.squirrel@matth.zeut.net> Date: Thu, 4 Dec 2003 15:52:51 -0500 (EST) Subject: Re: autovacuum daemon stops doing work after about an hour From: "Matthew T. O'Connor" To: In-Reply-To: References: <16332.63508.196365.801418@yertle.int.kciLink.com> <1070516326.1455.11.camel@zedora.zeut.net> X-Priority: 3 Importance: Normal Cc: X-Mailer: SquirrelMail (version 1.2.11) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/98 X-Sequence-Number: 4958 >>>>>> "MTO" == Matthew T O'Connor writes: > > MTO> I don't run FreeBSD, so I haven't tested with FreeBSD. Recently > Craig MTO> Boston reported and submitted a patch for a crash on FreeBSD, > but that > > some more debugging data: > > (gdb) print now > $2 = {tv_sec = 1070565077, tv_usec = 216477} > (gdb) print then > $3 = {tv_sec = 1070561568, tv_usec = 668963} > (gdb) print diff > $4 = -5459981371352 > (gdb) print sleep_secs > $5 = -1272 > > so for some reason, instead of calculating 3508547514 as the diff, it > got a hugely negative number. > > I'll bet it has something to do with the compiler... more debugging to > follow (without -O compilation...) Could this be the recently reported bug where time goes backwards on FreeBSD? Can anyone who knows more about this problem chime in, I know it was recently discussed on Hackers. The simple fix is to just make sure it's a positive number. If not, then just sleep for some small positive amount. I can make a patch for this, probably sometime this weekend. Thanks for tracking this down.