Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 16A80475C5E
	for <pgsql-sql@postgresql.org>; Tue, 13 Aug 2002 14:45:31 -0400 (EDT)
Received: from metrony.com (webware.metrony.com [207.159.131.106])
	by postgresql.org (Postfix) with ESMTP id 50358475833
	for <pgsql-sql@postgresql.org>; Tue, 13 Aug 2002 14:45:30 -0400 (EDT)
Received: from aaronlaptop (ool-4350168d.dyn.optonline.net [67.80.22.141])
	by metrony.com (8.11.0/8.11.0) with SMTP id g7DIjST57069;
	Tue, 13 Aug 2002 18:45:29 GMT (envelope-from aaron@metrony.com)
Message-ID: <002101c242f9$a5f3bf60$4b00a8c0@metrony.com>
From: "Aaron Held" <aaron@metrony.com>
To: <pgsql-sql@postgresql.org>
Cc: "Douglas Trainor" <trainor@uic.edu>,
	"Christoph Haller" <ch@rodos.com>
References: <200208130808.KAA02491@rodos>
Subject: Re: update on a large table
Date: Tue, 13 Aug 2002 14:45:42 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/207
X-Sequence-Number: 9053

Thanks Doug,

I was doing an UPATE on 100 million rows and I was updating an indexed column, it was also
the column that I was basing my seach on.

UPDATE "Calls" SET "GroupCode"='100 my street' WHERE "GroupCode"='' AND "Site"='000005'

GroupCode was Indexed.  I dropped the index and the query ran in under one hour.

Now I have been running Vaccum Analyze for three days......

Thanks,
-Aaron Held