Re: Performance of update

sam wrote:
> Hi
> Iam trying to update a database table with approx 45000 rows. Iam not
> updating all rows at a time. Iam updating 60 rows at a given time for
> example. and this is happening in a FOR LOOP. A function that has the
> update statements is called within the loop.
>
> The updates take too long.....is postgres slow in doing updates on
> large tables or is it because of the function call within the loop???


45000 rows isn't a large table, and there's no reason why it should be
slow in updating 60 rows.
Did you VACUUM ANALYZE; your table recently? Are the columns you use in
your WHERE indexed?
What does EXPLAIN ANALYZE say?


--
Tommy Gildseth