Re: Slow update SQL

Hi, Ken,

Ken Hill wrote:

> Removing the indexes, running the update SQL, and then adding back the
> indexes worked much faster. Thank you for you help.

It might be a good idea to run VACUUM FULL between updating and reindexing.

If you want to CLUSTER on an index, it will be best to create this index
first, then CLUSTER the table, and then recreate the other indices.

HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org