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 5A0AFD1B4AE for ; Thu, 4 Dec 2003 21:22:38 +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 27632-01 for ; Thu, 4 Dec 2003 17:22:09 -0400 (AST) Received: from yertle.kcilink.com (yertle.kcilink.com [216.194.193.105]) by svr1.postgresql.org (Postfix) with ESMTP id 921C3D1B47A for ; Thu, 4 Dec 2003 17:22:07 -0400 (AST) Received: by yertle.kcilink.com (Postfix, from userid 100) id 60C142178A; Thu, 4 Dec 2003 16:22:09 -0500 (EST) From: Vivek Khera MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <16335.42369.252957.290956@yertle.int.kciLink.com> Date: Thu, 4 Dec 2003 16:22:09 -0500 To: "Matthew T. O'Connor" Cc: Subject: Re: autovacuum daemon stops doing work after about an hour In-Reply-To: <2348.66.106.27.14.1070571171.squirrel@matth.zeut.net> References: <16332.63508.196365.801418@yertle.int.kciLink.com> <1070516326.1455.11.camel@zedora.zeut.net> <2348.66.106.27.14.1070571171.squirrel@matth.zeut.net> X-Mailer: VM 7.17 under 21.4 (patch 14) "Reasonable Discussion" XEmacs Lucid X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/100 X-Sequence-Number: 4960 Actually, you can simplify the fix thusly: diff = (long long)(now.tv_sec - then.tv_sec) * 1000000 + (now.tv_usec - then.tv_usec);