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 B87B6D1DD14 for ; Tue, 16 Mar 2004 05:49:05 +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 23822-07 for ; Tue, 16 Mar 2004 01:49:05 -0400 (AST) Received: from joeconway.com (66-146-172-86.skyriver.net [66.146.172.86]) by svr1.postgresql.org (Postfix) with ESMTP id BD914D1D2DC for ; Tue, 16 Mar 2004 01:49:03 -0400 (AST) Received: from [192.168.5.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 1086938; Mon, 15 Mar 2004 21:44:28 -0800 Message-ID: <40569515.70902@joeconway.com> Date: Mon, 15 Mar 2004 21:48:05 -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: "Matthew T. O'Connor" Cc: Tom Lane , pgsql-performance , Josh Berkus 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> <4056916B.5090204@zeut.net> In-Reply-To: <4056916B.5090204@zeut.net> 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/216 X-Sequence-Number: 6072 Matthew T. O'Connor wrote: > Strange... I wonder if this is some integer overflow problem. There was > one reported recently and fixed as of CVS head yesterday, you might try > that, however without the -d2 output I'm only guessing at why > pg_autovacuum is vacuuming so much / so often. I'll see what I can do tomorrow to track it down. I have already recommended to the program manager that they switch to 7.4.2 plus the autovacuum patch. Not sure they will be willing to make any changes at this stage in their release process though. > If we can't find one, any chance you can > do some testing with CVS HEAD just to see if that works any better. I > know there has been a fair amount of work done to improve this situation > (not just vacuum delay, but ARC etc...) I might do that, but not likely on Solaris. I can probably get a copy of the current database and testing scripts, and give it a try on one of my own machines (all Linux, either RHAS3, RH9, or Fedora). Joe