X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6631DD1B518 for ; Sun, 7 Dec 2003 14:53:02 +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 61222-06 for ; Sun, 7 Dec 2003 10:52:35 -0400 (AST) Received: from noao.edu (noao.edu [140.252.1.54]) by svr1.postgresql.org (Postfix) with ESMTP id 75BF6D1B48F for ; Sun, 7 Dec 2003 10:52:31 -0400 (AST) Received: from weaver.tuc.noao.edu ([140.252.38.8] verified) by noao.edu (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 9808033; Sun, 07 Dec 2003 07:52:36 -0700 Received: from weaver.tuc.noao.edu (localhost.localdomain [127.0.0.1]) by weaver.tuc.noao.edu (8.12.8/8.12.5) with ESMTP id hB7EqZ7Q008814; Sun, 7 Dec 2003 07:52:35 -0700 Received: (from swampler@localhost) by weaver.tuc.noao.edu (8.12.8/8.12.8/Submit) id hB7EqZOc008812; Sun, 7 Dec 2003 07:52:35 -0700 Date: Sun, 7 Dec 2003 07:52:35 -0700 From: Steve Wampler To: Steve Wampler Cc: Robert Treat , Postgres-performance Subject: Re: Help tracking down problem with inserts slowing down... Message-ID: <20031207145235.GA8734@weaver.tuc.noao.edu> References: <1070661108.20063.86.camel@weaver.tuc.noao.edu> <200312052154.52223.xzilla@users.sourceforge.net> <20031207142816.GA8321@weaver.tuc.noao.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20031207142816.GA8321@weaver.tuc.noao.edu> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/145 X-Sequence-Number: 5005 On Fri, Dec 05, 2003 at 09:54:52PM -0500, Robert Treat wrote: >... > A vacuum verbose could give you a good indication if you need to reindex, > compare the # of pages in the index with the # in the table. Hmmm, I have a feeling that's not as obvious as I thought... I can't identify the index (named 'id_index') in the output of vacuum verbose. The closest I can find is: NOTICE: --Relation pg_index-- NOTICE: Pages 2: Changed 0, Empty 0; Tup 56: Vac 0, Keep 0, UnUsed 42. Total CPU 0.00s/0.00u sec elapsed 0.00 sec. Which probably isn't correct, right (the name doesn't seem to match)? The table's entry is: NOTICE: --Relation attributes_table-- NOTICE: Pages 639: Changed 0, Empty 0; Tup 52846: Vac 0, Keep 0, UnUsed 48. Total CPU 0.00s/0.01u sec elapsed 0.01 sec. Thanks! Steve -- Steve Wampler -- swampler@noao.edu The gods that smiled on your birth are now laughing out loud.