X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 51CAAD1B581 for ; Fri, 6 Feb 2004 00:13:06 +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 53608-07 for ; Thu, 5 Feb 2004 20:13:06 -0400 (AST) Received: from www.axa.it (unknown [194.242.232.5]) by svr1.postgresql.org (Postfix) with ESMTP id 31676D1B4B7 for ; Thu, 5 Feb 2004 20:13:02 -0400 (AST) Received: from www.expot.it (axa.it [127.0.0.1]) by www.axa.it (8.11.6/8.11.6) with ESMTP id i160Cug30625 for ; Fri, 6 Feb 2004 01:12:56 +0100 From: "Edoardo" To: pgsql-admin@postgresql.org Subject: Re: R: R: slow seqscan after vacuum analize Date: Fri, 6 Feb 2004 02:12:56 +0200 Message-Id: <20040206001228.M48308@axa.it> In-Reply-To: <5732.1076009625@sss.pgh.pa.us> References: <2s28b9$l7fca@mailr-1.tiscali.it> <5732.1076009625@sss.pgh.pa.us> X-Mailer: Open WebMail 2.00 20030325 X-OriginatingIP: 213.213.41.185 (eddy) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/66 X-Sequence-Number: 12240 On Thu, 05 Feb 2004 14:33:45 -0500, Tom Lane wrote > "Edoardo Ceccarelli" writes: > > Given a query that HAS to be executed with a seqscan I have noticed an > > increase in time comparing before and after the vacuum. > > This is really hard to believe --- I cannot think of any mechanism that > would result in that effect. Unless the vacuum were flushing the > kernel's disk cache, but the effects of that would only persist for one > scan. You did say that the increased time is repeatable if you do > multiple seqscans after the vacuum? > > regards, tom lane Yes, I can assure you that was repeatable and has disappeared only after a VACUUM FULL ANALYZE it was something really stable in it's bad behaviour. I am going to make some test soon and I will post here the results. Best Regards Edoardo -- The net spotter (http://expot.it) Open WebMail Project (http://openwebmail.org)