| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | ken(at)scottshill(dot)com, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Slow update SQL |
| Date: | 2006-02-14 16:39:03 |
| Message-ID: | 43F207A7.1030303@logix-tt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Hill | 2006-02-14 20:55:07 | Re: Non Matching Records in Two Tables |
| Previous Message | Ken Hill | 2006-02-14 16:35:16 | Re: Slow update SQL |