X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EC26B329E6F for ; Sat, 18 Sep 2004 15:09:51 +0100 (BST) 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 28115-08 for ; Sat, 18 Sep 2004 14:09:41 +0000 (GMT) Received: from mail.gmx.net (mail.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 5DD98329E7D for ; Sat, 18 Sep 2004 15:09:44 +0100 (BST) Received: (qmail 25200 invoked by uid 65534); 18 Sep 2004 14:09:44 -0000 Received: from line-c-199.dynamic-athome.inode.at (EHLO zaphod) (81.223.97.199) by mail.gmx.net (mp020) with SMTP; 18 Sep 2004 16:09:44 +0200 X-Authenticated: #1946847 Message-ID: <008a01c49d89$27eb02d0$d604460a@zaphod> From: "Michael Paesold" To: "R. Willmington" , References: Subject: Re: Update and some verbose output Date: Sat, 18 Sep 2004 16:09:47 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/165 X-Sequence-Number: 14868 R. Willmington wrote: > In fact, it seems to perform well and removes the deleted records. > The problem is that the performance of queries against the table is > as low as it was before i ran VACUUM FULL for the first time in a > year, > whereas performance on the staging system with the SAME database and > the exact same data was dramatically increased. Have you tried to reindex the table? (\help REINDEX) If table indexes have grown very big, I think just vacuum full is not enough. At least you could try and see, if it makes a difference. Regards, Michael Paesold