Venkatesh Babu <venkatbabukr(at)yahoo(dot)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