X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1BDD15336C for ; Tue, 12 Apr 2005 12:17:12 -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 27491-08 for ; Tue, 12 Apr 2005 15:17:07 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id DA8FD53364 for ; Tue, 12 Apr 2005 12:17:02 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j3CFGkXt016173; Tue, 12 Apr 2005 11:16:46 -0400 (EDT) To: "Bendik R. Johansen" Cc: PostgreSQL Perform Subject: Re: Slow update In-reply-to: <4bbbc6d3a436e415be630d768d609ef6@gmail.com> References: <0201deb23790cee173bdd2d3f0e96642@gmail.com> <15725.1113316540@sss.pgh.pa.us> <4bbbc6d3a436e415be630d768d609ef6@gmail.com> Comments: In-reply-to "Bendik R. Johansen" message dated "Tue, 12 Apr 2005 17:03:04 +0200" Date: Tue, 12 Apr 2005 11:16:46 -0400 Message-ID: <16172.1113319006@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/233 X-Sequence-Number: 11630 "Bendik R. Johansen" writes: > Below is the schema for the table i will be using. I tried dropping the > index, but it did not help. > Indexes: > "records_pkey" PRIMARY KEY, btree (id) > "records_category_idx" gist (category) > "records_cid_idx" btree (cid) > "records_uid_idx" btree (uid) Hmm ... my suspicion would fall first on the GIST index, to tell you the truth. Did you try dropping that one? regards, tom lane