| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Bobbie van der Westhuizen <Bobbie(at)idpi1(dot)agric(dot)za> |
| Cc: | <pgsql-general(at)postgresql(dot)org>, <tomcat(at)designmagick(dot)com> |
| Subject: | Re: updates (postgreSQL) very slow |
| Date: | 2004-03-10 17:17:57 |
| Message-ID: | Pine.LNX.4.33.0403101015540.10418-100000@css120.ihs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Have you run this update query again and again with vacuuming?
http://www.postgresql.org/docs/7.4/static/maintenance.html#ROUTINE-VACUUMING
If so, you might have millions and millions of dead tuples taking up
space and slowing things down. If you're running 7.4, install the
autovacuum daemon and turn it on. Nice little program that should mostly
take care of this issue for you.
Got any foreign keys on that field? Triggers?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank van Vugt | 2004-03-10 17:33:12 | Re: does this look more like a possible bug or more like a possible hardware problem...? (long) |
| Previous Message | Bruno Wolff III | 2004-03-10 17:13:15 | Re: Moving from 7.3.4 to 7.4.x? |