Re: Update command too slow

Venkatesh Babu  writes:

> Hi,
> 
> There aren't any triggers but there are 75262 update
> statements. The problem is that we have a datatype
> called as "Collection" and we are fetching the data
> rows into it, modifying the data and call
> Collection.save(). This save method generates one
> update satement per record present in it.

Are you running in autocommit mode? You might try disabling autocommit and
committing once at the end of the transaction. Postgres runs faster when not
committing more than necessary.

-- 
greg