Hi, There aren't any foreign keys and we are currently using Postgres version 7.4... --- Venkatesh Babu <venkatbabukr@xxxxxxxxx> wrote: > 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 > __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
