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 72C16D1B48E for ; Thu, 4 Dec 2003 19:45:59 +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 03342-10 for ; Thu, 4 Dec 2003 15:45:29 -0400 (AST) Received: from lorax.kcilink.com (lorax.kciLink.com [206.112.95.1]) by svr1.postgresql.org (Postfix) with ESMTP id CD8AED1B521 for ; Thu, 4 Dec 2003 15:44:41 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by lorax.kcilink.com (Postfix) with ESMTP id DF9C73E5B for ; Thu, 4 Dec 2003 14:44:42 -0500 (EST) Received: from lorax.kcilink.com ([127.0.0.1]) by localhost (lorax.kcilink.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 10293-03-5 for ; Thu, 4 Dec 2003 14:44:42 -0500 (EST) Received: from lorax.kciLink.com (localhost [127.0.0.1]) by lorax.kcilink.com (Postfix) with ESMTP id 33E593E16 for ; Thu, 4 Dec 2003 14:44:42 -0500 (EST) Received: (from news@localhost) by lorax.kciLink.com (8.12.9p2/8.12.9/Submit) id hB4JigwZ033557 for pgsql-performance@postgresql.org; Thu, 4 Dec 2003 14:44:42 -0500 (EST) (envelope-from news) To: pgsql-performance@postgresql.org Path: not-for-mail From: Vivek Khera Newsgroups: ml.postgres.performance Subject: Re: autovacuum daemon stops doing work after about an hour Date: Thu, 04 Dec 2003 14:44:41 -0500 Organization: Khera Communications, Inc., Rockville, MD Lines: 32 Message-ID: References: <16332.63508.196365.801418@yertle.int.kciLink.com> <1070516326.1455.11.camel@zedora.zeut.net> NNTP-Posting-Host: yertle.kcilink.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: lorax.kcilink.com 1070567082 32569 216.194.193.105 (4 Dec 2003 19:44:42 GMT) X-Complaints-To: daemon@kciLink.com NNTP-Posting-Date: Thu, 4 Dec 2003 19:44:42 +0000 (UTC) User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, berkeley-unix) Cancel-Lock: sha1:ywPj8067Vdc9BlPRneCXMWnBHFc= X-Virus-Scanned: by amavisd-new at kciLink.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/90 X-Sequence-Number: 4950 >>>>> "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...) MTO> ---------------------------(end of broadcast)--------------------------- MTO> TIP 7: don't forget to increase your free space map settings -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/