X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 39C3FD828B for ; Thu, 13 Oct 2005 15:34:08 -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 76448-04 for ; Thu, 13 Oct 2005 18:34:05 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8BD03D8155 for ; Thu, 13 Oct 2005 15:34:05 -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 j9DIY5Br024584; Thu, 13 Oct 2005 14:34:05 -0400 (EDT) To: Patrick Hatcher Cc: postgres performance list Subject: Re: slow update In-reply-to: References: Comments: In-reply-to Patrick Hatcher message dated "Thu, 13 Oct 2005 09:34:39 -0700" Date: Thu, 13 Oct 2005 14:34:05 -0400 Message-ID: <24583.1129228445@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200510/229 X-Sequence-Number: 14997 Patrick Hatcher writes: > Pg 7.4.5 > Trying to do a update of fields on 23M row database. > Is it normal for this process to take 16hrs and still clocking? Are there foreign keys pointing at the table being updated? If so, failure to index the referencing columns could create this sort of performance problem. Also, in 7.4 you'd better be sure the referencing columns are the same datatype as the referenced column. regards, tom lane