From: Aaron Held <aaron@metrony.com>
To: pgsql-sql@postgresql.org
Cc: Douglas Trainor <trainor@uic.edu>
Cc: Christoph Haller <ch@rodos.com>
Subject: Re: update on a large table
Date: Tue, 13 Aug 2002 14:45:42 -0400
Message-ID: <002101c242f9$a5f3bf60$4b00a8c0@metrony.com> (raw)
References: <200208130808.KAA02491@rodos>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: aaron@metrony.com, trainor@uic.edu, ch@rodos.com
Subject: Re: update on a large table
In-Reply-To: <002101c242f9$a5f3bf60$4b00a8c0@metrony.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox