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 19705D1C9E6 for ; Wed, 17 Mar 2004 19:40:40 +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 42795-06 for ; Wed, 17 Mar 2004 15:40:28 -0400 (AST) Received: from joeconway.com (66-146-172-86.skyriver.net [66.146.172.86]) by svr1.postgresql.org (Postfix) with ESMTP id 0712DD1B80B for ; Wed, 17 Mar 2004 15:40:27 -0400 (AST) Received: from [206.19.64.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 1092044; Wed, 17 Mar 2004 11:35:49 -0800 Message-ID: <4058A94E.10808@joeconway.com> Date: Wed, 17 Mar 2004 11:38:54 -0800 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Arthur Ward Cc: pgsql-performance Subject: Re: rapid degradation after postmaster restart 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> <11658.68.62.129.152.1079538035.squirrel@award.gotdns.org> In-Reply-To: <11658.68.62.129.152.1079538035.squirrel@award.gotdns.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/244 X-Sequence-Number: 6100 Arthur Ward wrote: > 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. Great to know -- many thanks. I've hacked my own vacuum-delay-only patch form Jan's all_performance patch. It looks like the only difference is that it uses usleep() instead of select(). So far the tests look promising. Thanks, Joe