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 1E25B52824 for ; Thu, 2 Jun 2005 10:04:03 -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 94683-02 for ; Thu, 2 Jun 2005 13:03:54 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id AB9CA52872 for ; Thu, 2 Jun 2005 10:03:53 -0300 (ADT) Received: (qmail 11094 invoked by uid 500); 2 Jun 2005 13:02:59 -0000 Date: Thu, 2 Jun 2005 08:02:59 -0500 From: Bruno Wolff III To: Bahadur Singh Cc: pgsql-bugs@postgresql.org, pgsql-novice@postgresql.org Subject: Re: BUG #1697: Select getting slower on continously updating data Message-ID: <20050602130259.GB9716@wolff.to> Mail-Followup-To: pgsql-novice@postgresql.org, Bahadur Singh , Bruno Wolff III References: <20050602110500.59D47F0B00@svr2.postgresql.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050602110500.59D47F0B00@svr2.postgresql.org> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/15 X-Sequence-Number: 11974 This does not belong on the pgsql-bugs list. The pgsql-novice or pgsql-performance lists seem more appropiate. I have set followups to the pgsql-novice list. On Thu, Jun 02, 2005 at 12:05:00 +0100, Bahadur Singh wrote: > > Hello, > > I found situtation that, when I am selecting data from a table of 200 > records, getting slower as I do continous update to the same existing data. You need to be vacuuming (and possibly analyzing) the table more often as the updates will leave dead rows in the table which will bloat the table size and slow down access, particularly sequential scans. If the updates modify the data value distributions significantly, then you will also need to reanalyze the table to help the planner make good decisions.