X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 75B1FD1B373 for ; Fri, 2 Jul 2004 04:50:14 -0300 (ADT) 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 60972-10 for ; Fri, 2 Jul 2004 07:50:09 +0000 (GMT) Received: from www.postgresql.com (www.postgresql.com [200.46.204.209]) by svr1.postgresql.org (Postfix) with ESMTP id 08125D1B27C for ; Fri, 2 Jul 2004 04:50:08 -0300 (ADT) Received: by www.postgresql.com (Postfix, from userid 80) id B448FCF4D52; Fri, 2 Jul 2004 04:50:07 -0300 (ADT) To: pgsql-bugs@postgresql.org Subject: BUG #1186: Broken Index? From: "PostgreSQL Bugs List" Reply-To: "Gosen, Hitoshi" Message-Id: <20040702075007.B448FCF4D52@www.postgresql.com> Date: Fri, 2 Jul 2004 04:50:07 -0300 (ADT) 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: 200407/19 X-Sequence-Number: 8601 The following bug has been logged online: Bug reference: 1186 Logged by: Gosen, Hitoshi Email address: mic-gosen@ns.inter-mic.co.jp PostgreSQL version: 7.4 Operating system: linux 2.4.18 Description: Broken Index? Details: Hello All, We are using PostgreSQL 7.4.2 for our website that handles over 200,000 transactions a day. About a month ago, the responses from the SELECT queries on the database became terribly slow. We tried to anaylze the cause of the problem, searching throught the system logs and all, but nothing appeared to be out of the ordinary. What we did to resolve this was to dump the database, delete the database, recreate the database, and finally restore it. After that, things were back to normal.