Give the schema of your table. Give the exact query/queries you are running. Give the cardinality of the table. -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of vinita bansal Sent: Thursday, February 24, 2005 10:21 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: update queries taking lot of time 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
