Hi,
I am running update query of the form "update tablename set x = y where exists (select .....)"
These queries are taking lots of time. I dropped all indices on the table which provided some improvement but not remarkable performance. I am looking for ways to improve it. Can someone suggest what all can be done to improve it. These queries are being executed from within a pl/pgsql function.
Regards, Vinita Bansal
_________________________________________________________________
Try the all-new MSN Search! Find exactly what you want. http://search.msn.co.in Get more value for your time.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
