Postgres Pro
Downloads
Home   >   mailing lists

very slow updates in 8.3? - Mailing list pgsql-general

From Anton Andreev
Subject very slow updates in 8.3?
Date
Msg-id 4809AE77.4000202@fmi.uni-sofia.bg
Whole thread Raw
Responses Re: very slow updates in 8.3?  ("Richard Broersma" <richard.broersma@gmail.com>)
Re: very slow updates in 8.3?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Jaisen N.D."
Date:
Subject: Re: Problem. createdb: could not connect to database postgres: could not connect to server: No such file or directory
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Problem. createdb: could not connect to database postgres: could not connect to server: No such file or directory