Re: update on a large table

From: "Aaron Held" <aaron(at)metrony(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: "Douglas Trainor" <trainor(at)uic(dot)edu>, "Christoph Haller" <ch(at)rodos(dot)com>
Subject: Re: update on a large table
Date: 2002-08-13 18:45:42
Message-ID: 002101c242f9$a5f3bf60$4b00a8c0@metrony.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Wei Weng 2002-08-13 20:39:24 concurrent connections is worse than serialization?
Previous Message Thomas Good 2002-08-13 18:00:13 pg_dump's octal strings -> oracle data load