| From: | andrew(at)pillette(dot)com |
|---|---|
| To: | Miguel Arroz <arroz(at)guiamac(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: UPDATE 66k rows too slow |
| Date: | 2008-03-10 04:10:10 |
| Message-ID: | 200803100410.m2A4AAd09614@pillette.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Miguel Arroz <arroz(at)guiamac(dot)com> wrote ..
> I'm testing an update on 66k rows on Postgresql, and it seems
> something is not right here.
>
> My server is a Quad-Xeon 3.2 Ghz with 2 GB RAM and a RAID 1 running
> FreeBSD 6.3 and PgSQL 8.3. My development machine is a PowerBook G4
> 1.67 Ghz with 2 GB RAM, OS X Leopard and PgSQL 8.3.
[62 seconds on server, 25 seconds on much weaker development machine]
OK, my guess is that the server's tables are bloated beyond what regular VACUUM can fix. Try a VACUUM FULL VERBOSE or a re-CLUSTER if the tables are clustered.
Hope this helps.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-03-10 04:48:54 | Re: UPDATE 66k rows too slow |
| Previous Message | Miguel Arroz | 2008-03-10 02:21:39 | UPDATE 66k rows too slow |