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
