X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 779A152A3C for ; Mon, 18 Jul 2005 11:53:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66483-04 for ; Mon, 18 Jul 2005 14:53:00 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 788F752CB2 for ; Mon, 18 Jul 2005 11:53:00 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j6IEr43g003284; Mon, 18 Jul 2005 10:53:04 -0400 (EDT) To: "Matthew T. O'Connor" Cc: Robert Creager , PGPerformance , Andy Hewitt Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - In-reply-to: <42DBBD4A.6030209@zeut.net> References: <20050717213416.59dcb52e@thunder.logicalchaos.org> <24520.1121659853@sss.pgh.pa.us> <20050717235630.26a7c979@thunder.logicalchaos.org> <2466.1121692991@sss.pgh.pa.us> <42DBBD4A.6030209@zeut.net> Comments: In-reply-to "Matthew T. O'Connor" message dated "Mon, 18 Jul 2005 10:31:38 -0400" Date: Mon, 18 Jul 2005 10:53:04 -0400 Message-ID: <3283.1121698384@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/261 X-Sequence-Number: 13502 "Matthew T. O'Connor" writes: > Therefore (if you aren't specifying them from the command line), on 803, > the vacuum delay settings should be the same for a cron issued vacuum > and an autovacuum issued vacuum. So if the vacuum delay settings are > the problem, then it should show up either way. ... as indeed it does according to Robert's recent reports. Still awaiting the definitive test, but I'm starting to think this is another case of the strange behavior Ian Westmacott exhibited. regards, tom lane