I am having a bit of trouble updating a single integer column.
My table has around 10 columns and 260 000 records.

update no.records set uid = 2; (uid is an integer. It has a btree index)

This update takes more than 20 minutes to execute. Is this normal? This will be totally unacceptable when my table grows.
Any ideas?

---------------------------(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

Reply via email to