From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | "vinita bansal" <sagivini(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: update queries taking lot of time |
Date: | 2005-02-24 18:40:23 |
Message-ID: | D425483C2C5C9F49B5B7A41F8944154705596F@postal.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of vinita bansal
Sent: Thursday, February 24, 2005 10:21 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Bryden | 2005-02-24 18:41:38 | Re: ADO and timestamp/date errors |
Previous Message | vinita bansal | 2005-02-24 18:21:01 | update queries taking lot of time |