very slow updates in 8.3?

From: Anton Andreev <fn30762(at)fmi(dot)uni-sofia(dot)bg>
To: pgsql-general(at)postgresql(dot)org
Subject: very slow updates in 8.3?
Date: 2008-04-19 08:33:59
Message-ID: 4809AE77.4000202@fmi.uni-sofia.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Cheers,
Anton

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-04-19 09:23:16 Re: Problem. createdb: could not connect to database postgres: could not connect to server: No such file or directory
Previous Message Jaisen N.D. 2008-04-19 04:44:00 Re: Problem. createdb: could not connect to database postgres: could not connect to server: No such file or directory