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 1BD82D1D1D5 for ; Thu, 5 Feb 2004 17:01:46 +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 78991-07 for ; Thu, 5 Feb 2004 13:01:38 -0400 (AST) Received: from mailr-1.tiscali.it (mailr-1.tiscali.it [212.123.84.81]) by svr1.postgresql.org (Postfix) with ESMTP id 0A9FFD1CCA6 for ; Thu, 5 Feb 2004 13:01:36 -0400 (AST) Received: from ppp-82-84-56-186.cust-adsl.tiscali.it (HELO alphaville) (82.84.56.186) by mailr-1.tiscali.it with ESMTP; 05 Feb 2004 18:01:17 +0100 Message-Id: <2s28b9$l7fca@mailr-1.tiscali.it> X-BrightmailFiltered: true Reply-To: From: "Edoardo Ceccarelli" To: "'Christopher Browne'" , Subject: R: R: slow seqscan after vacuum analize Date: Thu, 5 Feb 2004 18:00:52 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: Thread-Index: AcPsBOOoWfW6JhgpQ66o1AzBgPUf1wABEy3w X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/58 X-Sequence-Number: 12232 > But if the Original Poster is encountering that the database > is doing Seq Scans when it would be better to do an Index > Scan, that is a separate problem, and focusing on the VACUUM > may distract from the _real_ problem... > -- I have only noticed that after a VACUUM ANALYZE of the db the time of a seq scan (when a seqscan is required) has increased by a factor of ten, this is my primary focus, otherwise I would have posted something about "my select is really slow ..." To be more precise: Given a query that HAS to be executed with a seqscan I have noticed an increase in time comparing before and after the vacuum. Anyway I am working to create the same situation again to post some output of the verbose option of the vacuum. Edoardo