| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | anton(dot)andreev(at)fmi(dot)uni-sofia(dot)bg |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: very slow updates in 8.3? |
| Date: | 2008-04-19 15:06:40 |
| Message-ID: | 480A0A80.1030208@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Anton Andreev wrote:
> Hi,
>
> I have noticed that the first time you execute an:
>
> update table1 set params_count=0;
>
> it takes too long to complete: 11000 rows - 100 s.
>
> Postgresql 8.3 configuration on Turion 64 with 1.4 Gb RAM, Windows XP
>
> Which compiler is used to build Postgresql on Windows? Is it 9?
>
> Any comment?
You really haven't provided any information. What kind of disk do you
have? What does your postgresql.conf look like? How many times have you
run update against that table without vacuuming? What does your update
statement look like?
Joshua D. Drake
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2008-04-19 15:07:23 | Re: SQL error |
| Previous Message | Craig Ringer | 2008-04-19 14:52:07 | Initial ugly reverse-translator |