Re: Update command too slow

Venkatesh Babu <venkatbabukr@yahoo.com> writes:
> We have a table cm_quotastates which has exactly
> 4624564 rows and 25 columns and 9 indexes... Out of
> these, our code retrieves 75262 rows and modifies just
> one column in each row... but updating these to
> database is taking some significant time (around 20
> minutes)... Tried the following with the update

Any triggers or foreign keys on that table?  Also, what PG version is
this?  Are you doing this in a single UPDATE command, or 75262 separate
commands?

            regards, tom lane