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. Thanks, Venkatesh --- Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Venkatesh Babu <venkatbabukr@xxxxxxxxx> 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 > __________________________________ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
