X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 348FAD1E2E2 for ; Wed, 17 Mar 2004 15:40:41 +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 51334-08 for ; Wed, 17 Mar 2004 11:40:41 -0400 (AST) Received: from award.gotdns.org (pcp01097251pcs.tsclos01.al.comcast.net [68.62.129.152]) by svr1.postgresql.org (Postfix) with ESMTP id 401FCD1CCD2 for ; Wed, 17 Mar 2004 11:40:35 -0400 (AST) Received: (qmail 8115 invoked by uid 81); 17 Mar 2004 09:40:35 -0600 Received: from 68.62.129.152 (SquirrelMail authenticated user award) by award.gotdns.org with HTTP; Wed, 17 Mar 2004 09:40:35 -0600 (CST) Message-ID: <11658.68.62.129.152.1079538035.squirrel@award.gotdns.org> In-Reply-To: <4057D8BD.4080902@joeconway.com> References: <4052661D.5060505@joeconway.com> <14884.1079150555@sss.pgh.pa.us> <4055F343.6070600@joeconway.com> <405614CA.5030101@zeut.net> <405689A4.4080406@joeconway.com> <16735.1079414723@sss.pgh.pa.us> <4057D8BD.4080902@joeconway.com> Date: Wed, 17 Mar 2004 09:40:35 -0600 (CST) Subject: Re: rapid degradation after postmaster restart From: "Arthur Ward" To: "Joe Conway" Cc: "pgsql-performance" User-Agent: SquirrelMail/1.4.2 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/238 X-Sequence-Number: 6094 > The problem with Jan's more complex version of the patch (at least the > one I found - perhaps not the right one) is it includes a bunch of other > experimental stuff that I'd not want to mess with at the moment. Would > changing the input units (for the original patch) from milli-secs to > micro-secs be a bad idea? If so, I guess I'll get to extracting what I > need from Jan's patch. Jan's vacuum-delay-only patch that nobody can find is here: http://archives.postgresql.org/pgsql-hackers/2003-11/msg00518.php I've been using it in testing & production without any problems.