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 4EB45D1BA62 for ; Mon, 8 Dec 2003 18:41:45 +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 74864-07 for ; Mon, 8 Dec 2003 14:41:15 -0400 (AST) Received: from lorax.kcilink.com (lorax.kciLink.com [206.112.95.1]) by svr1.postgresql.org (Postfix) with ESMTP id 8F7E4D1B4C1 for ; Mon, 8 Dec 2003 14:41:14 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by lorax.kcilink.com (Postfix) with ESMTP id 6B2C53E55 for ; Mon, 8 Dec 2003 13:41:14 -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 97237-03 for ; Mon, 8 Dec 2003 13:41:13 -0500 (EST) Received: from lorax.kciLink.com (localhost [127.0.0.1]) by lorax.kcilink.com (Postfix) with ESMTP id A5E463E28 for ; Mon, 8 Dec 2003 13:41:13 -0500 (EST) Received: (from news@localhost) by lorax.kciLink.com (8.12.9p2/8.12.9/Submit) id hB8IfDT7082051 for pgsql-performance@postgresql.org; Mon, 8 Dec 2003 13:41:13 -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: Mon, 08 Dec 2003 13:41:12 -0500 Organization: Khera Communications, Inc., Rockville, MD Lines: 20 Message-ID: References: <16332.63508.196365.801418@yertle.int.kciLink.com> <1070516326.1455.11.camel@zedora.zeut.net> <16335.25079.106697.7521@yertle.int.kciLink.com> <3FCF7E74.9060604@bigfoot.com> <3FD40BC1.7050906@zeut.net> NNTP-Posting-Host: yertle.kcilink.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: lorax.kcilink.com 1070908873 32027 216.194.193.105 (8 Dec 2003 18:41:13 GMT) X-Complaints-To: daemon@kciLink.com NNTP-Posting-Date: Mon, 8 Dec 2003 18:41:13 +0000 (UTC) User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, berkeley-unix) Cancel-Lock: sha1:OM58FMOrWScQove6ySmsaM8yG9c= X-Virus-Scanned: by amavisd-new at kciLink.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/155 X-Sequence-Number: 5015 >>>>> "MTO" == Matthew T O'Connor writes: MTO> Yeah, FreeBSD testing would have been nice, but I don't have access to MTO> any FreeBSD boxes so..... FWIW, with the fflush() added after that sleep, and the fix to the long long computation of sleep time to keep it from overflowing, pg_autovacuum has been working flawlessly on my FreeBSD 4.9 + PG 7.4.0 production server. I'm just still playing with tuning pg_autovacuum to keep it from vacuuming my busy tables *too* often. Just a question: will my test program show negative sleep 'diff' on your linux box? I can't imagine that it would give different results than on freebsd. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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/