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 7850D536F7 for ; Tue, 12 Apr 2005 11:12:45 -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 04934-04 for ; Tue, 12 Apr 2005 14:12:37 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.195]) by svr1.postgresql.org (Postfix) with ESMTP id 9D799535A4 for ; Tue, 12 Apr 2005 11:12:35 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so1901125wri for ; Tue, 12 Apr 2005 07:12:40 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:mime-version:content-transfer-encoding:message-id:content-type:to:from:subject:date:x-mailer; b=Bj3MnGHicaDcePb/cld93hJMULPJQ0GwA21CTKTb31AmUCg08orGaxTVy43mD6JZHPvbJprZ/FmS/rYRL5PRp1J8P0/rUnBRROB3HvOdN32mwMQ8UCUfWzhKfZueHreJ7Zvn+IMtSEhppzEyUpY1btixTygH35X+GJTFzzoccgw= Received: by 10.54.79.17 with SMTP id c17mr1071842wrb; Tue, 12 Apr 2005 07:12:39 -0700 (PDT) Received: from ?10.80.1.43? ([194.248.208.82]) by mx.gmail.com with ESMTP id 64sm908888wra.2005.04.12.07.12.38; Tue, 12 Apr 2005 07:12:39 -0700 (PDT) Mime-Version: 1.0 (Apple Message framework v619.2) Content-Transfer-Encoding: 7bit Message-Id: <0201deb23790cee173bdd2d3f0e96642@gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed To: PostgreSQL Perform From: Bendik R.Johansen Subject: Slow update Date: Tue, 12 Apr 2005 16:12:32 +0200 X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.398 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/226 X-Sequence-Number: 11623 Hello, I am having a bit of trouble updating a single integer column. My table has around 10 columns and 260 000 records. update no.records set uid = 2; (uid is an integer. It has a btree index) This update takes more than 20 minutes to execute. Is this normal? This will be totally unacceptable when my table grows. Any ideas?