Home > mailing lists

Re: update on a large table - Mailing list pgsql-sql

From	Aaron Held
Subject	Re: update on a large table
Date	August 13, 2002 17:45:32
Msg-id	002101c242f9$a5f3bf60$4b00a8c0@metrony.com Whole thread Raw
In response to	update on a large table ("Aaron Held" <aaron@metrony.com>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Thomas Good
Date: 13 August 2002, 17:17:44
Subject: pg_dump's octal strings -> oracle data load

From: Wei Weng
Date: 13 August 2002, 19:39:30
Subject: concurrent connections is worse than serialization?

Re: update on a large table - Mailing list pgsql-sql

Previous

Next