How are you updating this tables? Do you use UPDATE .... WHERE ....
On Fri, 4 Feb 2005 05:57:32 -0800 (PST), Venkatesh Babu <[EMAIL PROTECTED]> wrote: > Hello, > > 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 > > (a) Tried updating after removing all the 9 indexes > associated with the table > (b) Tried updating the 75K rows in batches > (c) vacuum analyze the table before updation > > but none are helping and update still takes the same > amount of time. Is there anything else that can be > done so that update takes lesser time... Also, where > can I find info about how postgres update actually > works? > > Thanks, > Venkatesh > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
