Re: very slow updates in 8.3?

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

In response to

Browse pgsql-general by date

  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