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 24ABFD1D16E for ; Mon, 2 Feb 2004 02:58:31 +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 00339-07 for ; Sun, 1 Feb 2004 22:58:32 -0400 (AST) Received: from millenium.mst.co.jp (unknown [210.230.185.241]) by svr1.postgresql.org (Postfix) with ESMTP id EA745D1CCDB for ; Sun, 1 Feb 2004 22:58:27 -0400 (AST) Received: from mst1x5r347kymb (lc12114 [192.168.1.114]) by millenium.mst.co.jp (8.11.6p2/3.7W) with SMTP id i122wTY24655; Mon, 2 Feb 2004 11:58:29 +0900 Message-ID: <005d01c3e938$75ab8040$7201a8c0@mst1x5r347kymb> From: "Iain" To: "Tom Lane" Cc: References: <000901c3e64e$9611c390$7201a8c0@mst1x5r347kymb> <23606.1075393949@sss.pgh.pa.us> <004201c3e931$52120d90$7201a8c0@mst1x5r347kymb> <26786.1075688030@sss.pgh.pa.us> Subject: Re: Routine maintenance - vacuum, analyse and autovacuum Date: Mon, 2 Feb 2004 11:58:39 +0900 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/9 X-Sequence-Number: 12183 > Kinda sounds like index bloat to me --- have you done any looking to > determine which files are growing? > No, I havn't. I don't actually have access to that machine, and there is a cirtain reluctance to tamper with it. However Ithink that it will need some attention soon. I'll keepin mind what you said. regards iain